CREATE TABLE table_79006 ("Player" CLOB, "Team" CLOB, "Round 1" FLOAT, "Round 2" CLOB, "Subtotal" FLOAT, "Finals" CLOB, "Total" FLOAT)

Which player has a subtotal of more than 3 and more than 8 in round 1?
SELECT "Player" FROM table_79006 WHERE "Subtotal" > '3' AND "Round 1" > '8'
SELECT "Player" FROM "table_79006" WHERE "Round 1" > '8' AND "Subtotal" > '3'