LeetCode Medium 1867 Interview SQL Question with Detailed Explanation

[@sivasrimakurthi206]

@everyday Data Science - I am getting addicted to your videos ;-) it is fun to follow the lessons, you are teaching the techniques of SQL piece by piece, and the examples you choose are apt and real time scenarios. Thanks a lot for designing and delivering such a great content 🤩

[@EverydayDataScience]

Glad that the videos are helping you 😊 Thanks for such kind words.

[@ujjwalvarshney3188]

create temp table Order_detaill1as (select order_id,avg(Quantity) as avg1from Orderdetails group by 1) ; select distinct orderid from Orderdetails where quantity >(select max(avg1) from Order_detaill1)

[@darshansr9025]

MAX(AVG) made my day !!

[@gagansingh3481]

Awesome questions 👏

[@EverydayDataScience]

Glad that you found the video useful.

[@ekosetiawan_indo]

what a great content, thanks a lot

[@EverydayDataScience]

Glad that you are finding the videos helpful, Eko.

[@rinkali7654]

Hi, could you please explain why we don't use window function in this problem?

[@Mr_D0T]

i found this question lacking some testcases like if we have same product in same order id then it gives wrong answer

[@mlvprasadofficial]

75