Report question

Question: How to combine GROUP BY, ORDER BY and HAVING