Solution to Q#4

Question

I am quite confused regarding question #4 and its solution

The question asks to obtain the result without using CTE while the answer does

Answer 1

Hi Eslam!

Thanks for reaching out!

Actually, you have to use the CROSS JOIN in a query. It is not mentioned to not use a common table expression. In exercise 3, for instance, it is mentioned not to use one – so here in this particular case you have to use the CROSS JOIN and still use a common table expression.

Hope this helps.
Best,
Martin

Solution to Q#4

Submit an answer

related questions