What are the different colleges this season?
select distinct college from match_season
How many players are playing for the listed colleges?
select college, count ( * ) from match_season group by college
What are the draft classes for the players from UCLA and Duke?
select distinct draft_class from match_season where college = "UCLA" or college = "Duke"
Could you tell me the draft pick numbers of the players from those draft classes?
select draft_pick_number from match_season where draft_class in ( select distinct draft_class from match_season where college = "UCLA" or college = "Duke" )
Yes please.
select player, draft_pick_number from match_season where draft_class in ( select distinct draft_class from match_season where college = "UCLA" or college = "Duke" )
What are the positions of each of those players?
select position, player, draft_pick_number from match_season where draft_class in ( select distinct draft_class from match_season where college = "UCLA" or college = "Duke" )