Відео

select s1.submission_date, count(distinct s1.hacker_id), (select hacker_id from submissions s3 where s3.submission_date=s1.submission_date group by hacker_id order by count(submission_id)desc, min(hacker_id)asc limit 1) as h_id, (select h.name from hackers h where h.hacker_id = h_id) from submissions s1 where DATEDIFF(s1.submission_date, '2016-03-01')+1 = (select count(distinct s2.submission_date) from submissions s2 where s2.submission_date <= s1.submission_date and s2.hacker_id = s1.hacker_id) group by s1.submission_date;

Thanks for the help!

4 is not the end of the list. 5 is the end of the list. this makes no sense. Either removed the Nth node from the list, or remove the node at the end of the list. "Nth node" & "end of list" both specify positions, that are different from each other.

Jolly buoy vs ross & north bay?? Which one's must

Im getting error invalid use of group function

Thank you

How to take pre permit for jolly buoy island... details please

We need explanation not code

tumhare mic quality ne gand fad di meri

awesome code writing sir..but,explain more abt it while writing the code in step by step process Do more vedioes..tnqq

nice bro

❤❤

each player would like to make the height 1, i dont think an interviewer would accept this without justification

Wow, nice

❤❤

Please could you explain why you summed the various totals in the subqueries and summed them again in the main query I don't know why the summation should be two for each totals Thank you.

✨🤘

❤❤

❤❤❤ bujhi bujhi

Good going

Hi bro from wheredid you learn python dsa ? (suggest some platform) or yt

bro LINE number 22 explain krde...comment me bhi explain krne se chalega

i think this may fail because once see for given test case there are 2 senior manager ids for c1 but this code gives 1 if possible check for tc given

Bro, How the where condition is working in the 1st sub query

Hello, I didn't understand this solution, Can you please explain it?

samjhaega kon😑😑

nice typing

Thank you.

Thanks🎉

Thanks dude!

your code does'nt work all the time. once try for this test case == 1 1

PLEASE EXPLAIN

please provide explanation for this

still error

Sorry The Input Format like this n = 10, k = 3 arr => 0 1 0 0 0 1 1 1 1 1 Why the answer is 3? I can find arr[1] to serve arr[0]~arr[3] and arr[5] to serve arr[4]. Am I misunderstanding? Thanks for reply.

Very helpful. Thank you for the helpful observations

unable to understand when height of a tower is 6, then how 5 is a standard move?? coz 5 doesn't equally divides 6 :/

samzayega kon bhai? google se ham bhi chap sakte hai..

Try him famz ⬆️⬆️⬆️ he's real and legit vendors he got pmo he can also pyo he go all sauce, cc, apple pay method, BTC, PayPal cash app

Isn't 2 also a valid move in the first exercise example, since 2 divides 6 evenly?

whats the point of just writing the code and not explaining anything at all .

int towerBreakers(int n, int m) { if(m == 1 || n % 2 == 0){ return 2; } return 1; }

you should explain it man