Background
A series of MySQL queries on the popular sakila schema to obtain information on the tables actor, address, category, city, country, customer, film, film_actor, film_category, inventory, language, payment, rental, staff and store.
Queries Used Data Definition Language Statements:
ALTER DROP CREATE VIEW DROP VIEW
Data Manipulation Language Statements:
SELECT APPEND DELETE UPDATE JOIN
Aggregate Functions:
SUM COUNT GROUP BY WHERE