Https://www.codecademy.com/paths/analyze-data-with-sql/tracks/analyze-data-sql-analyze-real-data/modules/analyze-data-sql-usage-funnels/projects/analyze-data-sql-usage-funnels-with-warby-parker

When you ask a question, don’t forget to include a link to the exercise or project you’re dealing with!

If you want to have the best chances of getting a useful answer quickly, make sure you follow our guidelines about how to ask a good question. That way you’ll be helping everyone – helping people to answer your question and helping others who are stuck to find the question and answer! :slight_smile:

https://www.codecademy.com/paths/analyze-data-with-sql/tracks/analyze-data-sql-analyze-real-data/modules/analyze-data-sql-usage-funnels/projects/analyze-data-sql-usage-funnels-with-warby-parker

Hello,

I would like to know if the function of with in this project is correct

with q as (select ‘1-quiz’ as stage, count(distinct user_id)
from quiz

‘1-quiz’ this column never exist in quiz table. In with clause, can I create new column ?

I got this query from codecademy you tube video. This is question 6.

What I know is that after Select only existing column list can come
select ( column_list ) from (table).

Thanks,

jinny