You have a DataFrame df loaded from a CSV file with columns 'id', 'name', and 'age'. You need to create a Common Table Expression (CTE) named 'young_people' that includes only the rows where 'age' is less than 30. Write the Spark SQL query to achieve this._

Simulated

WITH young_people AS (SELECT * FROM df WHERE age < 30) SELECT * FROM young_people

68.6%

WITH young_people AS (SELECT * FROM df WHERE age < 30) CREATE TABLE young_people AS SELECT * FROM young_people_

17.4%

WITH young_people AS (SELECT * FROM df WHERE age < 30) INSERT INTO young_people SELECT * FROM young_people_

9.7%

WITH young_people AS (SELECT * FROM df WHERE age < 30) UPDATE young_people SET * FROM young_people_

4.3%

Databricks Certified Data Engineer - Associate