List dept_id and avg_salary (rounded to 0) for departments whose average salary is above 1,00,000. Ignore employees with no department.
dept_id
avg_salary
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.