Preview of practice Right Join / Full Outer Join (2.3) - SQL for Business Analysts
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

RIGHT JOIN / FULL OUTER JOIN

Practice - RIGHT JOIN / FULL OUTER JOIN

Learning

Practice Questions

Test your understanding with targeted questions

Question 1 Easy

What does RIGHT JOIN accomplish?

💡 Hint: Think about which table is prioritized in a RIGHT JOIN.

Question 2 Easy

Write a SQL statement using FULL OUTER JOIN to find all customers and their orders.

💡 Hint: Remember it combines all records from both tables.

4 more questions available

Interactive Quizzes

Quick quizzes to reinforce your learning

Question 1

What type of records does RIGHT JOIN return?

Only from the left table
Only from the right table
Both tables with priority on the right

💡 Hint: Focus on which table data is prioritized.

Question 2

FULL OUTER JOIN includes records from which tables?

True
False

💡 Hint: Recollect the definition of FULL OUTER JOIN.

1 more question available

Challenge Problems

Push your limits with advanced challenges

Challenge 1 Hard

Given two tables: employees and departments, write a SQL query to find employees even if they are not assigned to any department. Include the department name if present.

💡 Hint: Think about focusing on employee data and what happens if they belong to no department.

Challenge 2 Hard

Create a query using FULL OUTER JOIN that lists all products and sales, but marks products not sold with NULL.

💡 Hint: Focus on ensuring every product appears even if it has not been sold.

Get performance evaluation

Reference links

Supplementary resources to enhance your learning experience.