sql subqueries nested in select and from

Question

There is this video under "SQL subqueries nested in select and from" which makes me feel so confused and lost. I watched it many times however I did not get where the question is coming from. How did the instructor realize he should include the dept code? I saw everyone in the Q&A section wrote the code and I even could not find the question itself.

Answer 1

Hi Yasaman!
Thanks for reaching out.

We will be needing this in the next few lectures. This is why it is provided in the video.

Hope this helps.
Best,
Tsvetelin

sql subqueries nested in select and from

Submit an answer

related questions