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.
- Customers whose first name is Terry
- Customers whose first name is Jessie or the last name is Torres
- Staff member named Mike
- Customer named Sue Peters
- Payments made by customer Sue Peters in excess of $1 at employee Mike
- 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.