The following questions will help you to practice writing SQL statements. The questions are based on the "sakila" database schema on MySQL Workbench.

1. Write the sql statement that will provide you a list of active customers by full address. Sorted by country, city and last name. (Without using the wildcard (*) for the fields.) How many active households do we have?

2. Write the sql statement that will provide you a list of rental dates looking from today, back into history, and the count of rented films per day. (Without using the wildcard (*) for the fields.) How many days did we have movies rented?

3. Write the sql statement that will provide you a list all films that were rented. (Without using the wildcard (*) for the fields.) How many titles did we rent since the beginning?

4. Write the sql statement that will provide you the title of the movie that was most rented in June, 2005. How many times was it rented?

5. Write the sql statement that will provide you with the highest revenue day we had in the past. How much did we make? What was the highest revenue date?