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
Which coach started in 2010?
assistant
SELECT Coach_ID FROM player_coach WHERE starting_year = 2010;
human
What are the names of the coaches that started in 2010?
assistant
SELECT coach_name FROM coach AS t1 JOIN player_coach AS t2 ON t1.coach_id = t2.coach_id WHERE starting_year = 2010;
human
What are the names of the players who were coached by Jameson Tomas?
assistant
SELECT T3.Player_name FROM player_coach AS T1 JOIN coach AS T2 ON T1.Coach_ID = T2.Coach_ID JOIN player AS T3 ON T1.Player_ID = T3.Player_ID WHERE t2.coach_name = 'Jameson Tomas';
human
What are the names of the players who were coached by Smith Brown?
assistant
SELECT T3.Player_name FROM player_coach AS T1 JOIN coach AS T2 ON T1.Coach_ID = T2.Coach_ID JOIN player AS T3 ON T1.Player_ID = T3.Player_ID WHERE t2.coach_name = "Smith Brown" ;