/MySQL-sakila

MySQL queries on the sakila database

Primary LanguageTSQL

MySQL-sakila-

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:
  1. ALTER
  2. DROP
  3. CREATE VIEW
  4. DROP VIEW
  • Data Manipulation Language Statements:
  1. SELECT
  2. APPEND
  3. DELETE
  4. UPDATE
  5. JOIN
  • Aggregate Functions:
  1. SUM
  2. COUNT
  3. GROUP BY
  4. WHERE