alternative solution same results . Is it valid?

in SQL / SQL Subqueries with IN nested inside WHERE

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

20 Jan 2023

Hi Ahmed!
Thanks for reaching out.

Yes, this is a valid solution. The structure of the query is not recommended as there are a lot of subqueries. This makes the performance slower. Anyway, congratulations to the alternative solution!

Hope this helps.
Best,
Tsvetelin

Submit an answer

related questions

Marcus Wern Han Leong

Why did you not do not null, primary key and auto increment for customer id in the solution?

Abdelrahman Samy

Resolved: why this code not valid

Mohamed AbdulHalim

Resolved: Playing the text in the video does not work, although I have cc enabled, what is the solution please

Jose Luis Loren

Alternative code using group by

Maxime Darbouze

I wrote the same command that is the sql file and it did not work

Mayank Mittal

why distinct in this case doesn't work same as group by

Islam Elkhateeb

I have a different answer than 365 data solution when I this code

Batool Osama Khalid

Resolved: INNER JOIN results .....