Is there an existing issue for this?

• I have searched the existing issues

Issue Description

Summary

The current SQL documentation lacks detailed notes on the topic "JOINS", making it harder for beginners to understand different join operations and their use cases. I would like to introduces comprehensive explanation notes for INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, and CROSS JOIN, with examples for each.

Suggested Change

What's will be Implemented ?

• Adding a new section "Understanding SQL Joins" under the SQL documentation.
• Covering following topics with explanations and syntax:
  • INNER JOIN
  • LEFT (OUTER) JOIN
  • RIGHT (OUTER) JOIN
  • FULL OUTER JOIN
  • CROSS JOIN
• Including diagrams and example queries for better visualization.
• Will try to include interactive join visualizations or playground examples for users to try queries live.
• Adding comparison table summarizing the differences between join types.
• Providing real-world examples to demonstrate practical usage of joins.

Rationale

Why This Change is Needed

• Improves the SQL docs by making them more beginner-friendly.
• Provides clear, structured content for quick learning and reference.
• Addresses a documentation gap for a core SQL concept.

Urgency

High

Record

• I have read the Contributing Guidelines
• Are you a GSSOC'25 contributor
• I want to work on this issue