CREATE TABLE table_name_20 (points VARCHAR2, time_retired VARCHAR2, car_no VARCHAR2)

How many points were scored by car number 10 that ended with a collision?
SELECT points FROM table_name_20 WHERE time_retired = "collision" AND car_no = "10"
SELECT "points" FROM "table_name_20" WHERE "10" = "car_no" AND "collision" = "time_retired"