Telegram Channel: t.me/allaboutsemicolons
In this video, we discuss SQL JOINs with step-by-step examples.
Covered Topics (Q1–Q10):
1️⃣ List all students with their enrolled courses
2️⃣ Show each student’s total score
3️⃣ Students with total score greater than 200
4️⃣ Average score per course
5️⃣ Average score per course (only if more than 2 students)
6️⃣ CSE students with average greater than 85
7️⃣ Courses where the highest score is less than 90
8️⃣ Students who scored greater than 80 per course
9️⃣ Courses where all scores are greater than 60
🔟 Highest scorer per course (Correlated Subquery explained)
👍 Don’t forget to:
Like this video if it helped you
Subscribe for more SQL tutorials
