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

Islam Elkhateeb

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

Batool Osama Khalid

Resolved: INNER JOIN results .....

Jorge Monti

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

Pawee Chiranothai

Why does drawing data from dept_manager_dup table get different results?

Essien Alex-bennet Elijah

Solution to Question

Oriji Sandra Onyinyechi

The solution has two select statement

Ahmed Hesham

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