Skip to content

Practice MySQL queries focusing on the customer and payment tables of the Sakila database.

Notifications You must be signed in to change notification settings

er-hiba/MySQL-sakila-customer-payment-practice

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

Description

This repository contains a collection of practice MySQL queries focusing on the customer and payment tables of the Sakila database. The queries cover a variety of scenarios, including retrieving customer information, analyzing payments, and querying staff details.

Queries Summary

  1. Customers whose first name is Terry
  2. Customers whose first name is Jessie or the last name is Torres
  3. Staff member named Mike
  4. Customer named Sue Peters
  5. Payments made by customer Sue Peters in excess of $1 at employee Mike
  6. Payments made by customer Sue Peters in excess of $1 at employee Mike and made before August 2005

These queries are designed for educational purposes and serve as practice for MySQL query writing.

About

Practice MySQL queries focusing on the customer and payment tables of the Sakila database.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published