Practice - SQL Joins
Practice Questions
Test your understanding with targeted questions
What does an INNER JOIN do?
💡 Hint: Think about when two tables share common data.
What type of JOIN would show all students even if they do not have a department?
💡 Hint: Remember the left table keeps all its rows.
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
Which JOIN returns all rows from the left table and matched rows from the right table?
💡 Hint: Which join is all about keeping the left side?
True or False: A RIGHT JOIN returns only rows where there is a matching record in the left table.
💡 Hint: Think about what each side retains.
1 more question available
Challenge Problems
Push your limits with advanced challenges
What would happen if you applied a LEFT JOIN to a table that has several NULL values for the join column? Illustrate with an example SQL query.
💡 Hint: Consider how NULL values affect the outcome.
Write a SQL statement using FULL JOIN to find all departments and students, regardless of whether there is a match.
💡 Hint: Think about how you’d include unmatched entries on both sides.
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.