This repository contains a collection of simple and clear SQL query examples demonstrating how to:
- Join multiple tables using
INNER JOIN,LEFT JOIN,RIGHT JOIN, andCROSS JOIN - Filter data using
WHERE,LIKE, andIS NULL - Use
GROUP BYand aggregation functions likeCOUNT() - Sort query results with
ORDER BY - Generate random dates using
RAND(),FLOOR(), andDATE_ADD()
Each file contains examples with clear explanations and result tables, covering a specific SQL topic.
- Basic and advanced
JOINoperations - Filtering and sorting data
- Working with
NULLvalues - Generating random dates in SQL
- Combining data from multiple related tables
You can open any file to read examples and copy-paste the SQL queries into your SQL environment to practice or test.
- Beginners learning SQL joins and grouped queries
- Students preparing for exams
- Instructors looking for teaching materials
Feel free to explore, modify, and learn! π