SQL Queries using Sakila Database

This repository contains a series of exercises resolved using SQL, based on the commonly used database "Sakila".

Objectives

The exercises focus on solving specific problems using SQL queries while working with the following tables:

• actor
• customer
• rental
• film
• category;
• film_category
• inventory
• film_actor

SQL concepts covered

The tasks explore a variety of SQL concepts, including:

• Aggregation (COUNT, AVG, SUM)
• Filtering (WHERE, HAVING)
• Use of set operators (NOT IN, EXISTS, LIKE) and REGEXP
• Joins (INNER, LEFT, SELF JOIN)
• Subqueries
• CTE's