CREATE TABLE table_name_8 (rank VARCHAR2, rider VARCHAR2)

How many Ranks have ray pickrell as a Rider?
SELECT COUNT(rank) FROM table_name_8 WHERE rider = "ray pickrell"
SELECT COUNT("rank") FROM "table_name_8" WHERE "ray pickrell" = "rider"