CREATE TABLE table_name_75 (name VARCHAR2, rank VARCHAR2, year VARCHAR2)

I want the name for rank less than 6 and year more than 1974
SELECT name FROM table_name_75 WHERE rank < 6 AND year > 1974
SELECT "name" FROM "table_name_75" WHERE "rank" < 6 AND "year" > 1974