Practice - Joins (Combining Tables)
Practice Questions
Test your understanding with targeted questions
What does INNER JOIN do?
💡 Hint: Think about how it works with overlapping data.
What is a LEFT JOIN?
💡 Hint: What happens to non-matched records?
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
What does an INNER JOIN do?
💡 Hint: Consider what it means for records to match.
True or False: A LEFT JOIN will return only matching records from the left table.
💡 Hint: Think about the nature of all records being included.
1 more question available
Challenge Problems
Push your limits with advanced challenges
Create a dataset of students and classes. Write a SQL query that lists all students and their classes, including students who are not enrolled in any classes.
💡 Hint: Think of how you can keep all students in the results.
You have two tables: Employees and Projects. Use a FULL OUTER JOIN to find all employees and their projects, showing employees without projects and projects without employees.
💡 Hint: Consider how to capture every employee and project, regardless of their pairing.
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.