Telegram Channel: t.me/allaboutsemicolons
In this video, we continue SQL JOINs practice with detailed examples covering LEFT JOIN, RIGHT JOIN, and CROSS JOIN. Step-by-step queries and explanations in Bangla make it easy to follow.
Covered Topics (Q11–Q21):
Q11: All students even if no enrollment
Q12: All courses even if no students
Q13: Students not enrolled in any course
Q14: Courses with no students
Q15: Instructors + courses (even if none)
Q16: Course + student count (0 if none)
Q17: Students + number of courses (0 if none)
Q18: Students with instructors
Q19: All possible student-course combinations
Q20: Students + distinct instructors
Q21: Number of students per instructor
👍 Don’t forget to:
Like this video if it helped you
Subscribe for more SQL tutorials
