CREATE TABLE table_name_23 (motorcycle VARCHAR2, rider VARCHAR2)

Anthony West ride which Motorcyle?
SELECT motorcycle FROM table_name_23 WHERE rider = "anthony west"
SELECT "motorcycle" FROM "table_name_23" WHERE "anthony west" = "rider"