CREATE TABLE table_name_78 (team VARCHAR, name VARCHAR)

What team was Andrew Ranger in?
SELECT team FROM table_name_78 WHERE name = "andrew ranger"
SELECT "team" FROM "table_name_78" WHERE "andrew ranger" = "name"