6. Using the Rental table, select all rentals that occurred before 08-01-2005. List Rental_Date, Inventory_ID, Customer_ID and Staff_ID. Order by Customer_ID then by Rental_Date.

7. Using the Customer and the Address table (you will need to Join the tables), list the customer_id, first_name, last_name, address, district, city_id, postal_code, phone, and email. Join on the address_id from both tables. Order by last_name then first_name.

8. Using the Customer and the Address table (you will need to Join the tables), list the customer_id, first_name, last_name, address, district, city_id, postal_code, phone, and email for those customers that live in California. Join on the address_id from both tables. Order by last_name then first_name.

9. Using the Customer and the Address table (you will need to Join the tables), list the customer_id, first_name, last_name, address, district, city_id, postal_code, phone, and email where the city_id is greater than 500. Join on the address_id from both tables. Order by city_id.

10. Using the actor and film_actor table, join using the actor_id field from both tables. List the actor_id, first_name, last_name, and film_id. Order by film_id, actor_id