Answers for "average in sql based on group by"

sql avg and group by

SELECT
  AVG(depdelay),
  origin
FROM flight_delays
WHERE distance > 2000
GROUP BY origin;

Posted by: Guest on October-18-2020

sql avg group by

SELECT student_name, avg(notes) FROM student_notes GROUP BY student_name;

Posted by: Guest on April-21-2021

Code answers related to "average in sql based on group by"