CREATE TABLE table_name_43 (name VARCHAR2, games VARCHAR2, order VARCHAR2, goals VARCHAR2)

Which name has an Order smaller than 997,more than 5 goals, and 215 games?
SELECT name FROM table_name_43 WHERE order < 997 AND goals > 5 AND games = 215
SELECT "name" FROM "table_name_43" WHERE "games" = 215 AND "goals" > 5 AND "order" < 997