Day 15: SQL Fundamentals Overview

Basics: SELECT queries to extract titles, directors, and years from movies.
Filtering: WHERE clause to filter movies by ID and year range.
Pattern Matching: LIKE operator for finding specific movie titles and directors.
Aggregation: DISTINCT, LIMIT, and aggregation functions like SUM, AVG.
Joining Tables: INNER JOIN for combining movies and box office data.
Subqueries: Utilizing subqueries for advanced data extraction.
Modifying Data: INSERT, UPDATE, DELETE for managing database records.
Schema Modification: ALTER TABLE for adding or modifying table columns.
Database Maintenance: CREATE TABLE, DROP TABLE for managing database schema.