Need help writing a query. See question below

Using the database you installed from Module 1, provide an example query using both a group by clause and a having clause. Show no more than ten rows of your query result. Discuss if the query you wrote can be rewritten without those clauses.

The example database is "world_x" at the following link. https://dev.mysql.com/doc/index-other.html