CREATE TABLE table_57536 ("Finishing position" CLOB, "Points awarded  ( Platinum ) " FLOAT, "Points awarded  ( Gold ) " FLOAT, "Points awarded  ( Silver ) " FLOAT, "Points awarded  ( Satellite ) " FLOAT)

What points awarded are higher than 6 but smaller than 9
SELECT MAX("Points awarded (Platinum)") FROM table_57536 WHERE "Points awarded (Gold)" = '9' AND "Points awarded (Silver)" > '6'
SELECT MAX("Points awarded (Platinum)") FROM "table_57536" WHERE "Points awarded (Gold)" = '9' AND "Points awarded (Silver)" > '6'