CREATE TABLE table_29474407_11 (year_of_intro VARCHAR2, name__designation VARCHAR2)

How many years of introduction does the Neal Submachine Gun have?
SELECT COUNT(year_of_intro) FROM table_29474407_11 WHERE name__designation = "Neal submachine gun"
SELECT COUNT("year_of_intro") FROM "table_29474407_11" WHERE "Neal submachine gun" = "name__designation"