Tell me the Draft Class for the season 1996.0 ?
select draft_class from match_season where season = 1996.0
for 1998.0
select draft_pick_number from match_season where season = "1998.0" and country = "6"
Tell me the player for team 1 in the season 1996 ?
select player from match_season where season = "1996.0" and team = "1"
Which college have both players with position midfielder and players with position defender ?
select college from match_season where position = "Midfielder" intersect select college from match_season where position = "Defender"