Question: SELECT stay, COUNT ( * ) AS count _ int, ROUND ( AVG ( todep ) , 2 ) AS average _ phq , ROUND

SELECT
stay,
COUNT(*) AS count_int,
ROUND(AVG(todep),2) AS average_phq,
ROUND(AVG(tosc),2) AS average_scs,
ROUND(AVG(toas),2) AS average_as
FROM
students
WHERE
stay IS NOT NULL
GROUP BY
stay
ORDER BY
stay DESC
LIMIT 9;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!