A collection of SQL exercises and mini projects covering database creation, table design, filtering, aggregation, and grouping. This repo is a snapshot of hands-on SQL practice using different datasets, from football player stats to student records.
Players.sql Queries against a football players dataset (Thexora database). Covers filtering by age, contract year, position, and nationality, wildcard searches, and aggregations like counting forwards, summing wages by nationality, and finding average age and pay by position and team.
SQL_Students.sql Creates a students database and table from scratch, including column definitions with varchar and date types, then inserts sample student records with names, contact info, and date of birth.
Thexora.sql Sets up a workers database and table with fields for name, hourly pay, and hire date, then inserts a sample record.
customer_profile_dataset.sql A quick look at a customer profile dataset used for an assessment.
courses.sql Works across three related tables, students, courses, and enrollments, to answer questions like which students enrolled in which courses, which course had the most registrations, and the average age of students. Covers inner, left, and right joins across multiple tables.
database pipeline.sql Analysis of a pipeline incident dataset. Answers real world style questions like the costliest accident year, the pipeline type with the fewest injuries in Texas, which liquid type exploded most often, top operators by injuries caused, property damage totals, and whether any underground pipelines shut down in 2014, complete with operator details.
world economic classification.sql Looks at a dataset classifying countries by UN and IMF economic status. Covers filtering countries by classification (developed, developing, advanced, unclassified), wealth rank ranges, fuel exporting status, and pattern matching on country names.
- Database and table creation with defined data types
- Inserting and selecting records
- Filtering with WHERE, AND, OR, NOT, IN, BETWEEN, and LIKE (wildcards)
- Aggregate functions: COUNT, SUM, AVG, ROUND
- GROUP BY, HAVING, and ORDER BY with LIMIT
- Joins across multiple related tables (INNER, LEFT, RIGHT)
- Working with columns containing spaces and special characters using backticks
- Working across multiple small datasets and schemas
MySQL