38. All Students and All Memberships
A FULL OUTER JOIN keeps every row from both tables — matched rows are paired, and the unmatched rows from either side appear with NULL on the other side. It surfaces orphans on both ends at once: students in no club, and club memberships pointing at an unknown student.
Task: list every student paired with every club they belong to. A student with no membership must still appear (with club = NULL), and a membership whose student_id matches no student must still appear (with student = NULL).
Output columns, in this exact order: student, club. Order by student ascending with NULLs last, then by club ascending with NULLs last.
This is the result for the example data above. On Submit your query is graded against this example plus 4 hidden edge cases — 5test cases in all. A sloppy query that only fits the example won't pass.