วีดีโอ

Thanks for this nice explanation

bro awesome explanation really liked your vedio

one simple correction would be rather than using Right(name,3) , we canalso make use of SubString(Name,-3) - substing is a best practise I feel than using Right(...)

your code is really good but naming convention has to be corrected and please maintain some gap for every query

Bro my doubt is why rnk_num_submissions = 1 (so that the highest submitted hacker I'd get be get?)

Making it easy super brother also give the code

Great job, i understood perfectly even without sound

You are the best i was literally tearing my hair over this question

SELECT c.contest_id , c.hacker_id , c.name, sum(ss.total_submissions), sum(ss.total_accepted_submissions),sum(vs.total_views),sum(vs.total_unique_views) from contests c inner join colleges cl on cl.contest_id = c.contest_id inner join challenges ch on ch.college_id = cl.college_id inner join submission_stats ss on ss.challenge_id = ch.challenge_id inner join view_stats vs on vs.challenge_id = ch.challenge_id group by c.contest_id can't we do the way I did , if not whats the reason?

but why are we checking startdate not in enddate , whats the purpose?

are hackrank sql sufficient for interviews? or what to do next for sql

Nice way of explanation. thanks

Thank you

Thank you so much.. Now I got it what actually question wants

Nice Explanation

Why group by B.hacker_id,B.name? Why B.name?

Please explain the code line by line otherwise video will be of no use Why did you use ROW_NUMBER Why not count(*) instead of count(*) over() ?? Also mention which SQL you are using MySQL,MSSQL,??

Good and clear detailed explanation

👌👌👌

. .🎉

😊

I subscribed your channel with another account also. One suggestion you may change your channel name because it's difficult to search. If the name of channel related to data or sql may be it's easy to search

😊

🎉

🎉

I m waiting for you video daily , one suggestion you can explain logic in general language it help us more

❤

Keep working

I am getting error i used the same code but not working

U really doing hardwork , best of luck

Where is audio

Comment your dream job 😊

I'm finding it just after paying 10.18rs

How we will solve this? Any link. Any dataset? Its impossible for us its just watch and forget.

👍👌

Wtf 😂 Chakke ke bhi din Aa gaye bhai, lekin hamare naa ayenge 😂

Yes

Thoda hindi bhi bola kijiye

Nice content

Hello EduZy, amazing work bro. Best of luck 👍👍👍👍

Nice Explanation 🎉

Very detailed Explanation thank you 🫡

Nice explanation sir

👌👌👌

Nice bro keep it up 👍

Wow itne ache se maths padte hai sir aap

👍👍

Op ~Aura

Nice video