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
Show the residences that have both a player of gender 'M' and a player 'F'.
assistant
SELECT Residence FROM player WHERE gender = 'M' INTERSECT SELECT Residence FROM player WHERE gender = 'F';
human
who is the sponsor of jean luc bouche?
assistant
SELECT Sponsor_Name FROM player WHERE Player_name = 'Jean Luc Bouch ';
human
Final question is how many votes for Niki Ashton?
assistant
SELECT Votes FROM player WHERE player_name = "Niki Ashton" ;