Table: race_team_stats
Columns: team
truck_s
col
driver_s
primary_sponsor_s
listed_owner_s
crew_chief

Question: Name the team for susan bates
SQL: SELECT "team" FROM race_team_stats WHERE "listed_owner_s" = 'Susan Bates'

Question: Name the truck for eric phillips
SQL: SELECT "truck_s" FROM race_team_stats WHERE "crew_chief" = 'Eric Phillips'

Question: Name the listed owner for mike garvey
SQL: SELECT "listed_owner_s" FROM race_team_stats WHERE "crew_chief" = 'Mike Garvey'

Question: Name the least listed owner for pete raymer
SQL: SELECT MIN("col") FROM race_team_stats WHERE "listed_owner_s" = 'Pete Raymer'

Question: Name the crew chief for rhonda thorson
SQL: SELECT "crew_chief" FROM race_team_stats WHERE "listed_owner_s" = 'Rhonda Thorson'