Create a SQL SELECT statement using a basic CTE(s) on the WorldWideImportersDW database.

Your query needs to have the following:

Easy to read

Could be a useful report/data feed

Contains an INNER JOIN, GROUP BY and an aggregate functiON

ALSO Find a case for and write a query with a recursive CTE for one of your databases