CREATE TABLE table_name_32 (team VARCHAR2, rider VARCHAR2)

What team does Anthony Redmond ride for?
SELECT team FROM table_name_32 WHERE rider = "anthony redmond"
SELECT "team" FROM "table_name_32" WHERE "anthony redmond" = "rider"