This repository contains SQL queries executed on the Sakila database, commonly used to practice data analysis and queries in MySQL.
The queries are organized into categories, covering topics such as:
✔️ Data selection (SELECT, WHERE, ORDER BY)
✔️ Use of aggregations (COUNT, SUM, AVG)
✔️ Grouping (GROUP BY, HAVING)
✔️ Using JOINs to combine tables
✔️ Data analysis on rentals, customers, and films
To run the queries, you need:
- MySQL installed on your machine
- Sakila database imported (download from MySQL Sakila Sample Database)
Contributions, issues, and feature requests are welcome! Feel free to fork this repository and submit a pull request.
Developed with ❤️ by Alejandra Villa Posada