MODULE 05 / LESSON 23● READY TO LEARN

Subqueries and CTE

Hands-on tutorial

01 / THE CONCEPT

Understand the idea

In this lesson, explore subqueries and cte. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.

02 / SQL EXAMPLE

◉ example.sqlSQL

WITH high AS (SELECT * FROM students WHERE score>=80) SELECT COUNT(*) FROM high;

Try in SQL Lab ↗

03 / KNOWLEDGE CHECK

Check your understanding

Which statement best describes subqueries and cte?

◈

Enjoying the lesson?

Create a free account to take the quiz and save your progress.

Create account ↗