CREATE TABLE table_79242 ("Position" CLOB, "Gymnast" CLOB, "A Score" FLOAT, "B Score" FLOAT, "Total" FLOAT)

Which gymnast had a b score of 8.95 and an a score less than 6.9
SELECT "Gymnast" FROM table_79242 WHERE "B Score" = '8.95' AND "A Score" < '6.9'
SELECT "Gymnast" FROM "table_79242" WHERE "A Score" < '6.9' AND "B Score" = '8.95'