human
Schema:
country (Country_id, Country_name, Capital, Official_native_language)
team (Team_id, Name)
match_season (Season, Player, Position, Country, Team, Draft_Pick_Number, Draft_Class, College)
player (Player_ID, Player, Years_Played, Total_WL, Singles_WL, Doubles_WL, Team)
Please answer with SQL.
assistant
Sure, I understand.
human
Show all the information about the match season.
assistant
SELECT * FROM match_season;
human
List the positions.
assistant
SELECT position FROM match_season;
human
How many distinct positions are there?
assistant
SELECT COUNT( distinct position ) FROM match_season;
human
What are the distinct position of players from college Virginia?
assistant
SELECT DISTINCT POSITION FROM match_season WHERE College = 'Virginia';
human
What about UCLA or Duke?
assistant
SELECT DISTINCT POSITION FROM match_season WHERE College = "UCLA" OR College = "Duke" ;