CREATE TABLE table_name_87 (team VARCHAR, rank VARCHAR, rider VARCHAR)

Rank larger than 8, and a Rider of chris barrett is what team?
SELECT team FROM table_name_87 WHERE rank > 8 AND rider = "chris barrett"
SELECT "team" FROM "table_name_87" WHERE "chris barrett" = "rider" AND "rank" > 8