Full Outer Join Simulation
Medium
joins
Stripe
LinkedIn
Airbnb
SQLite does not support FULL OUTER JOIN directly. Write a query that simulates a FULL OUTER JOIN between students and enrollments to show all students and all enrollments, even unmatched ones. Return student_name and course, ordered by student_name (NULLs last), then course.
Expected Output: All students and all enrollments, with NULLs for non-matches on either side.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...