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!
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)
‘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).