LeetCode 1303 Interview SQL Question with Detailed Explanation | Practice SQL | Window Functions

[@krishnaKumar-fx6eu]

Hey, your videos are super helpful. Do you have any study material that I can refer for all the concepts?

[@shivambansal3560]

was Order by required in the query'

[@kavyabanka4482]

Yes here how query ordered by team id

[@ManasNandMohan]

@@kavyabanka4482 No, it should be like this SELECT employee_id, COUNT(employee_id) OVER(PARTITION BY team_id ) AS team_size FROM Employee ORDER BY employee_id

[@jasimuddinmondal2007]

is the code is correct for this question select employee_id,count(team_id) as team_size from employee group team_size;

[@mickyman753]

you can't use employee_id in select since only group by columns and non group by col in agregate function can be used in select when using group by/parititionby

[@AmanAshutoshBCS]

sir, bhoot sare question premium hote hai....😓

[@mlvprasadofficial]

22