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

Jose Luis Loren

Alternative code using group by

Mohamed AbdulHalim

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

Maxime Darbouze

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

Batool Osama Khalid

Resolved: INNER JOIN results .....

Jorge Monti

Resolved: AVG's salaries are about the same, but what about the other benchmarks?

Essien Alex-bennet Elijah

Solution to Question