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

Pawee Chiranothai

Why does drawing data from dept_manager_dup table get different results?

Yogesh Batra

Resolved: Given solution didn't work and showing error

Ahmed Hesham

does not rollback and i don't know what i have to do , i do all sug solution with no result