Question

How do i add the median height and weight into my SQL at the very end? I already have a median age but not the other two. everything i do produces a syntax error.

SELECT sum(age) AS "Age Sum",

sum(height) AS "Height Sum",

sum(weight) AS "Weight Sum",

       round(avg(age), 0) AS "Age Average",

              round(avg(height), 0) AS "Height Average",

              round(avg(weight), 0) AS "Weight Average",

       percentile_cont(.5)

       WITHIN GROUP (ORDER BY age) AS "Age Median",

               FROM nfl_player_stats;

Answer 1

You can use the below SQL query,

SELECT sum(age) AS "Age Sum",

sum(height) AS "Height Sum",

sum(weight) AS "Weight Sum",

       round(avg(age), 0) AS "Age Average",

              round(avg(height), 0) AS "Height Average",

              round(avg(weight), 0) AS "Weight Average",

       percentile_cont(.5)

       WITHIN GROUP (ORDER BY age) AS "Age Median",

(SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY height) OVER () FROM nfl_player_stats) AS "Height Median",

(SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY weight) OVER () FROM nfl_player_stats) AS "Weight Median",

               FROM nfl_player_stats;