Sakila Queries on MySQL

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