Good job! Another common report type is a report on certain objects, often based on a time filter. Take a look:
WHERE order_date >= '2016-07-01' AND order_date < '2016-08-01';
In this query, we count the number of orders placed in July 2016. Note how we used the
WHERE clause to get the time limit we're interested in.
Also note that dates in SQL are always placed inside single quotes and are typically formatted as
YYYY-MM-DD (i.e., year-month-day). This may be a bit counterintuitive in countries that use other date formats, so watch out. Depending on the exact database engine you use and its configuration, your database may use a different date format. When in doubt, check your database documentation.