Practice Advanced Joins And Set Operations (19.1.5) - Advanced SQL and NoSQL for Data Science

Practice: Advanced Joins and Set Operations

Lesson 19.1.5Advanced SQL and NoSQL for Data Science

Practise this section

9 questions

Flashcard drill
4 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 a FULL OUTER JOIN do?
Show hintHide hint
Think about how rows might not match between two tables.
Question 2.
What does SELF JOIN allow you to do?
Show hintHide hint
Consider comparing entries within the same entity.
3Question 3.
What will a FULL OUTER JOIN return?
- Only matching rows
- All rows from both tables
- Only rows from the left table
Show hintHide hint
Consider what each join type typically provides.
4Question 4.
True or False: INTERSECT will return all rows from the first dataset.
- True
- False
Show hintHide hint
Think about the commonality of data between two datasets.
Question 5.
Create an SQL query that utilizes FULL OUTER JOIN and CROSS APPLY between two tables, demonstrating how they work together in a complex dataset.
Show hintHide hint
Consider how CROSS APPLY can dynamically apply functions to pulled rows.
Question 6.
Write a complex query using INTERSECT and EXCEPT to filter down a list of products that are available in both the current inventory and the archived sales, excluding any that are marked as discontinued.
Show hintHide hint
Break down the query by defining each part before composing it together for clarity.

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