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.