Which coach started in 2010?
select coach_id from player_coach where starting_year = 2010
What are the names of the coaches that started in 2010?
select coach_name from coach as t1 join player_coach as t2 on t1.coach_id = t2.coach_id where starting_year = 2010
What are the names of the players who were coached by Jameson Tomas?
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"
What are the names of the players who were coached by Smith Brown?
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"
What is the name of the coach who started in 2011?
select t1.coach_name from coach as t1 join player_coach as t2 on t1.coach_id = t2.coach_id where t2.starting_year = 2011
What are the names of the players who were coached by Robert Chen?
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 = "Robert Chen"