Practice Common Table Expressions (ctes) (19.1.2) - Advanced 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 CTE stand for?
Show hintHide hint
Think of temporary results in SQL.
Question 2.
Write a simple CTE to get total sales from an orders table by region.
Show hintHide hint
Remember to use the SUM function and GROUP BY.
3Question 3.
What keyword is used to define a CTE?
- CREATE
- WITH
- DEFINE
Show hintHide hint
Think about how we start a new SQL block.
4Question 4.
CTEs can reference themselves. Can they be used for hierarchical data?
- True
- False
Show hintHide hint
Consider what recursion allows us to do.
Question 5.
Write a CTE that computes the average sales for each region and returns those above a certain threshold, while using ranking to list them.
Show hintHide hint
Consider how averages are calculated with GROUP BY.
Question 6.
Create a recursive CTE that traces a product's lineage through categories and subcategories, displaying each step.
Show hintHide hint
Focus on constructing the category tree with proper joins.

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