CREATE TABLE table_29474407_11 (major_users VARCHAR2, name__designation VARCHAR2)

Who are all the major users of the Gordon Close-Support Weapon System?
SELECT major_users FROM table_29474407_11 WHERE name__designation = "Gordon Close-Support Weapon System"
SELECT "major_users" FROM "table_29474407_11" WHERE "Gordon Close-Support Weapon System" = "name__designation"