Posted by Esin Seçil, Feb. 5, 2024, 7:18 a.m.

Unpopular movies

Hello,

Firstly, Thank you so much for the nice environment for learning SQL better. 

I forced the question that I tpye the title above.

My question is there any other solving method instead of CTEs. For example; I tried to solve it by using JOINs. But, I confused. 

Could you please explain id there is any other method?

 

PS: Do you recommend me to develop by subquery by using IN operator.

 

Best regards

Esin

Answer

Answers


Comment
SQLPad user: Leon Wei

- Leon (934)

Feb. 5, 2024, 9:21 a.m.