Practice Full Join (or Full Outer Join) (5.5.4) - Structured Query Language (SQL) - Part 2
Students

Academic Programs

AI-powered learning for grades 8-12, aligned with major curricula

Engineering Courses
Professional

Professional Courses

Industry-relevant training in Business, Technology, and Design

Certifications
Games

Interactive Games

Fun games to boost memory, math, typing, and English skills

FULL JOIN (or FULL OUTER JOIN)

Practice - FULL JOIN (or FULL OUTER JOIN)

Learning

Practice Questions

Test your understanding with targeted questions

Question 1 Easy

What does a FULL JOIN do?

💡 Hint: Think about what happens when there are no matches.

Question 2 Easy

What keyword is used to perform a FULL JOIN?

💡 Hint: Look for the terms used for both sides in SQL.

4 more questions available

Interactive Quizzes

Quick quizzes to reinforce your learning

Question 1

What does a FULL JOIN return?

Only matching records
All records from both tables
with NULLs where there's no match
Only records from the left table

💡 Hint: Remember the purpose of a FULL JOIN.

Question 2

True or False: FULL JOIN can be implemented directly in MySQL.

True
False

💡 Hint: Consider the SQL features supported by your database.

1 more question available

Challenge Problems

Push your limits with advanced challenges

Challenge 1 Hard

Write a SQL query using FULL JOIN to display all students and departments, while making sure to show students who do not belong to any department and departments without students. What is the expected output?

💡 Hint: Think about how joins work and fill in NULL values.

Challenge 2 Hard

Create a function in PostgreSQL that uses FULL OUTER JOIN to combine data from two related tables and masks the NULL results with a specific word 'Unknown'.

💡 Hint: Look for how to use COALESCE to handle NULL in your SQL queries.

Get performance evaluation

Reference links

Supplementary resources to enhance your learning experience.