CREATE TABLE box_scores AS
   SELECT "LeBron James" AS name, 20.4 AS minutes, 14 AS points, 4 AS rebounds, 4 AS assists UNION
   SELECT "Anthony Edwards" AS name, 20.6 AS minutes, 13 AS points, 2 AS rebounds, 1 AS assists UNION
   SELECT "Stephen Curry" AS name, 21.8 AS minutes, 13 AS points, 2 AS rebounds, 2 AS assists UNION
   SELECT "Anthony Davis" AS name, 17.6 AS minutes, 12 AS points, 10 AS rebounds, 1 AS assists UNION
   SELECT "Joel Embiid" AS name, 16.6 AS minutes, 10 AS points, 7 AS rebounds, 3 AS assists UNION
   SELECT "Jrue Holiday" AS name, 17.8 AS minutes, 8 AS points, 4 AS rebounds, 3 AS assists UNION
   SELECT "Bam Adebayo" AS name, 17.6 AS minutes, 8 AS points, 5 AS rebounds, 1 AS assists UNION
   SELECT "Devin Booker" AS name, 20.0 AS minutes, 7 AS points, 2 AS rebounds, 1 AS assists UNION
   SELECT "Jayson Tatum" AS name, 17.8 AS minutes, 6 AS points, 3 AS rebounds, 2 AS assists UNION
   SELECT "Micah Potter" AS name, 2.5 AS minutes, 3 AS points, 0 AS rebounds, 0 AS assists UNION
   SELECT "Tyrese Haliburton" AS name, 14.8 AS minutes, 2 AS points, 2 AS rebounds, 3 AS assists UNION
   SELECT "Langston Galloway" AS name, 2.5 AS minutes, 2 AS points, 0 AS rebounds, 0 AS assists UNION
   SELECT "Derrick White" AS name, 11.3 AS minutes, 1 AS points, 2 AS rebounds, 2 AS assists UNION
   SELECT "Nigel Hayes" AS name, 2.5 AS minutes, 0 AS points, 0 AS rebounds, 0 AS assists;


CREATE TABLE nba_data AS
    SELECT "LeBron James" AS name, "Lakers" AS nba_team, "Forward" AS position UNION
    SELECT "Anthony Edwards" AS name, "Timberwolves" AS nba_team, "Guard" AS position UNION
    SELECT "Stephen Curry" AS name, "Warriors" AS nba_team, "Guard" AS position UNION
    SELECT "Anthony Davis" AS name, "Lakers" AS nba_team, "Center" AS position UNION
    SELECT "Joel Embiid" AS name, "Sixers" AS nba_team, "Center" AS position UNION
    SELECT "Jrue Holiday" AS name, "Celtics" AS nba_team, "Guard" AS position UNION
    SELECT "Bam Adebayo" AS name, "Heat" AS nba_team, "Center" AS position UNION
    SELECT "Devin Booker" AS name, "Suns" AS nba_team, "Guard" AS position UNION
    SELECT "Jayson Tatum" AS name, "Celtics" AS nba_team, "Forward" AS position UNION
    SELECT "Micah Potter" AS name, "Jazz" AS nba_team, "Center" AS position UNION
    SELECT "Tyrese Haliburton" AS name, "Pacers" AS nba_team, "Guard" AS position UNION
    SELECT "Langston Galloway" AS name, null AS nba_team, "Guard" AS position UNION
    SELECT "Derrick White" AS name, "Celtics" AS nba_team, "Guard" AS position UNION
    SELECT "Nigel Hayes" AS name, null AS nba_team, "Forward" AS position;




-- Part A: Top 5 players by points-per-minute, where they play at least 5 minutes
-- EXPECTED OUTPUT: 
-- LeBron James
-- Anthony Davis
-- Anthony Edwards
-- Joel Embiid
-- Stephen Curry

SELECT name FROM box_scores __________;





-- Part B: Team and average points in order of descending average rebounds with at least 5 total rebounds
-- EXPECTED OUTPUT:
-- Lakers|13.0
-- Sixers|10.4
-- Heat|8.4
-- Celtics|5.266666666666667

SELECT __________ FROM __________ WHERE __________ GROUP BY __________ __________;





-- Part C: Position, player with most assists per minute, and value of most assists per minute.
-- EXPECTED OUTPUT:
-- Guard|Tyrese Haliburton|0.18918918918918917
-- Forward|LeBron James|0.17647058823529413
-- Center|Joel Embiid|0.1686746987951807

SELECT __________ FROM __________ WHERE __________ GROUP BY __________;
