Skip to content

Latest commit

 

History

History
35 lines (23 loc) · 1.06 KB

File metadata and controls

35 lines (23 loc) · 1.06 KB

SQL Join Queries Examples

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, and CROSS JOIN
  • Filter data using WHERE, LIKE, and IS NULL
  • Use GROUP BY and aggregation functions like COUNT()
  • Sort query results with ORDER BY
  • Generate random dates using RAND(), FLOOR(), and DATE_ADD()

📁 Structure

Each file contains examples with clear explanations and result tables, covering a specific SQL topic.

📘 Topics Covered

  • Basic and advanced JOIN operations
  • Filtering and sorting data
  • Working with NULL values
  • Generating random dates in SQL
  • Combining data from multiple related tables

📦 How to Use

You can open any file to read examples and copy-paste the SQL queries into your SQL environment to practice or test.

🧠 Good For

  • Beginners learning SQL joins and grouped queries
  • Students preparing for exams
  • Instructors looking for teaching materials

Feel free to explore, modify, and learn! 🚀