[SQL] groupBy & having?

[SQL] groupBy & having?

// GroupBy & Having & OrderBy

SELECT b.dept_name AS dept_name, COUNT(dept_name) AS count 
FROM a RIGHT OUTER JOIN b 
WHERE a.dept_id = b.dept_id 
HAVING COUNT(dept_name) < 5
ORDER BY count;