human
Schema:
player (Player_ID, Sponsor_name, Player_name, Gender, Residence, Occupation, Votes, Rank)
club (Club_ID, Club_name, Region, Start_year)
coach (Coach_ID, Coach_name, Gender, Club_ID, Rank)
player_coach (Player_ID, Coach_ID, Starting_year)
match_result (Rank, Club_ID, Gold, Big_Silver, Small_Silver, Bronze, Points)
Please answer with SQL.
assistant
Sure, I understand.
human
Hello. Can you list the top three vote getters?
assistant
SELECT Player_name FROM player ORDER BY Votes DESC LIMIT 3;
human
Excellent! Which had the greatest number of votes?
assistant
SELECT Player_name FROM player ORDER BY Votes DESC LIMIT 1;
human
And who were the top three, in order from most to least?
assistant
SELECT Player_name FROM player ORDER BY Votes DESC LIMIT 3;
human
How many votes did Jim receive?
assistant
SELECT votes FROM player WHERE Player_name LIKE 'Jim%';
human
And what is his occupation?
assistant
SELECT occupation FROM player WHERE Player_name LIKE "Jim%" ;