Practice Right Join / Full Outer Join (2.3) - SQL for Business Analysts

Practice: RIGHT JOIN / FULL OUTER JOIN

Lesson 2.3SQL for Business Analysts

Practise this section

9 questions

Flashcard drill
3 cards from this section. Quick, good the night before a test.
Exercise
6 questions · about 4 min · pass mark 70%. Hints available.
Sign up to start the exercise
Quiz
3 questions · about 2 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What does RIGHT JOIN accomplish?
Show hintHide hint
Think about which table is prioritized in a RIGHT JOIN.
Question 2.
Write a SQL statement using FULL OUTER JOIN to find all customers and their orders.
Show hintHide hint
Remember it combines all records from both tables.
3Question 3.
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
Show hintHide hint
Focus on which table data is prioritized.
4Question 4.
FULL OUTER JOIN includes records from which tables?
- True
- False
Show hintHide hint
Recollect the definition of FULL OUTER JOIN.
Question 5.
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.
Show hintHide hint
Think about focusing on employee data and what happens if they belong to no department.
Question 6.
Create a query using FULL OUTER JOIN that lists all products and sales, but marks products not sold with NULL.
Show hintHide hint
Focus on ensuring every product appears even if it has not been sold.

5 more questions in this section. Enroll free to practise them all.