CREATE TABLE table_31897 ("Rank" FLOAT, "Name" TEXT, "Team" TEXT, "Goals" FLOAT, "Appearances" FLOAT)

Who had less than 7 goals, was ranked under 7, and had more than 8 appearances?
SELECT "Name" FROM table_31897 WHERE "Goals" < '7' AND "Rank" < '7' AND "Appearances" > '8'
SELECT "Name" FROM "table_31897" WHERE "Appearances" > '8' AND "Goals" < '7' AND "Rank" < '7'