SELECT t.team_name, t.location, COUNT(p.name) as player_count FROM player p JOIN team t ON p.team = t.team_name WHERE p.draft_year > 2000 OR p.position = 'Frontcourt' OR t.founded_year < 1980 OR p.age > 30 GROUP BY t.team_name, t.location, t.founded_year;
SELECT * FROM player WHERE age > 25
SELECT mvp_awards, draft_pick, name FROM player WHERE mvp_awards >= 1;
SELECT age, birth_date, team FROM player WHERE team = 'Phoenix Suns';
SELECT nationality, COUNT(*) AS count_all FROM player GROUP BY nationality;
SELECT nationality, MAX(mvp_awards) AS max_mvp_awards FROM player WHERE draft_year > 2012 OR nba_championships > 0 GROUP BY nationality;
SELECT p.name, t.team_name, t.location, p.mvp_awards FROM player p JOIN team t ON p.team = t.team_name WHERE p.mvp_awards >= 2 ORDER BY p.mvp_awards DESC;
SELECT draft_pick, nba_championships, team FROM player WHERE draft_pick < 17 AND draft_pick >= 5 LIMIT 20;
Ready to run. Click below to execute QuWARTS.