CREATE TABLE table_name_31 (rider VARCHAR2, rounds VARCHAR2, motorcycle VARCHAR2)

Who is riding the Ducati 999 RS in Round 7?
SELECT rider FROM table_name_31 WHERE rounds = "7" AND motorcycle = "ducati 999 rs"
SELECT "rider" FROM "table_name_31" WHERE "7" = "rounds" AND "ducati 999 rs" = "motorcycle"