select subject_id, AVG(grade_num)
from grade
group by subject_id
HAVING AVG(grade_num) > 1
ORDER BY max(grade_num)
select subject_id, AVG(grade_num)
from grade
group by term_id
HAVING AVG(grade_num) > .5
ORDER BY max(term_id)
SELECT teach_id, AVG(salary)
FROM teacher
group by name
HAVING min(salary) > 80000
ORDER BY Avg(salary)
https://parkland1-my.sharepoint.com/:w:/r/personal/sdow3_stu_parkland_edu/_layouts/15/Doc.aspx?sourcedoc=%7B49198A6F-18AB-40C0-BF1C-94B3CD5DF86B%7D&file=Module%202_%20CSC176%20Data%20Systems_Sharon%20Dow%20102318.docx&action=default&mobileredirect=true
https://parkland1-my.sharepoint.com/:w:/r/personal/sdow3_stu_parkland_edu/_layouts/15/Doc.aspx?sourcedoc=%7B49198A6F-18AB-40C0-BF1C-94B3CD5DF86B%7D&file=Module%202_%20CSC176%20Data%20Systems_Sharon%20Dow%20102318.docx&action=default&mobileredirect=true