Hi Prasad, Im getting this error as "Incorrect parameter count in the call to native function 'DATEDIFF'" I gave the exact code like you gave select b.id as id from Weather a inner join Weather b on DATEDIFF(Day, a.recordDate, b.recordDate) = 1 and a.temperature < b.temperature

very helpful video .. i skip this question

select player_id, device_id from Activity where event_date in (select min(event_date) as event_date group by player_id from Activity) is the above query achive the same results i cannot test it bcz the problem is for premium subscribers. pls tell if possible

hi MLV Prasad kaisa hai bhai ?

this ques is should be marked very easy !!

it was helpful

NIce work❤

Please explain more of why you are doing particular thing i started from basics and its really hard to understood

When I run the solution it shows "accepted" with 0.33 as output but when I submit I get wrong answer displayed. WHy like that?Sir please help

Thank you for your video

Good work and clear explanation! Thank you Prasad

Would be better for freshers if more explanation is shown before doing each step

Best Explanation. Thanks

I can’t see these questions now on leet code . Please help

nice explanation

with cte as ( select seat_id, free, lead(free, 1) over( order by seat_id ) as next lag(free, 1) over( order by seat_id ) as prev from cinema ) select seat_id from cte where ( free = next or free = prev) and free = 1

hi MLV Prasad can you please explain this below hierarchy query (or) make a video on it with your own style......... I was unable to crack this need your support thanks in advance......❤❤✌✌ CREATE TABLE company ( employee varchar(10) primary key, manager varchar(10) ); INSERT INTO company values ('Elon', null); INSERT INTO company values ('Ira', 'Elon'); INSERT INTO company values ('Bret', 'Elon'); INSERT INTO company values ('Earl', 'Elon'); INSERT INTO company values ('James', 'Ira'); INSERT INTO company values ('Drew', 'Ira'); INSERT INTO company values ('Mark', 'Bret'); INSERT INTO company values ('Phil', 'Mark'); INSERT INTO company values ('Jon', 'Mark'); INSERT INTO company values ('Omid', 'Earl'); SELECT * FROM company; /* Given graph shows the hierarchy of employees in a company. Write an SQL query to split the hierarchy and show the employees corresponding to their team.*/ WITH RECURSIVE cte_teams AS ( SELECT mng.employee, CONCAT('Team', ROW_NUMBER() OVER (ORDER BY mng.employee)) AS teams FROM company root JOIN company mng ON root.employee = mng.manager WHERE root.manager IS NULL ), cte AS ( SELECT c.employee, c.manager, t.teams FROM company c CROSS JOIN cte_teams t WHERE c.manager IS NULL UNION SELECT c.employee, c.manager, COALESCE(t.teams, cte.teams) AS teams FROM company c JOIN cte ON cte.employee = c.manager LEFT JOIN cte_teams t ON t.employee = c.employee ) SELECT teams, GROUP_CONCAT(employee, ', ') AS members FROM cte GROUP BY teams ORDER BY teams;

how about filtering the salary using desc use distinct select the position 2

[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near ','. (4145) (SQLExecDirectW) getting this following error near where clause can you help.. select * from activity a inner join activity b on dateadd(day,1,a.event_date) = b.event_date and a.player_id = b.player_id where (a.event_date,a.player_id) in (select min(event_date),player_id from activity group by player_id) this is my partial query

You may have to mentioned from where you are taking ex: (p.firstName, p.lastName, a.city, a.state) because sql doesn’t know what to take from where. Its always a good practice to put table name first. In this scenario it was acceptable if not mentioned

in the case stmt why did you use sum and not count, what is affected by using count/sum in that stmt?

I really like your content and the way of explanation by showing schematic way using notepad plz keep it up bro.....my support to u always

i am not able to understand isnull functionality over here

nice explanation prasad

DELETE p1.* FROM Person AS p1 INNER JOIN Person AS p2 WHERE p1.email = p2.email AND p1.id > p2.id

very helpful playlists, thanks!

Hi Prasad , from GitHub not able to download or open the Query , can you pls check once . Thanks for your Explanations and help

How r u thinking..which should we use and which logic should use? Does all comes under practice?

select r.contest_id , Round(((count( r.user_id))/ (SELECT count(*) FROM users)) *100, 2) as percentage from Users u Left Join Register r on u.user_id = r.user_id group by r.contest_id order by percentage desc, contest_id asc; sir i have written like this. getting error in case 2, getting null values with answer...

Hi Prasad a small correction in the final SQL script you have provided. The below code will work correctly SELECT * FROM person_7 WHERE id IN ( SELECT MIN(id) FROM person_7 GROUP BY email );

🚨Doubt : can we solve it using row_number: code : WITH ct AS ( SELECT seat_id, free, ROW_NUMBER() OVER (PARTITION BY seat_id) - free AS rn FROM Cinema ) SELECT ct.seat_id FROM ct GROUP BY ct.seat_id, ct.rn HAVING COUNT(*) > 1 order by seat_id;

Great explanation :) How many SQLquestions u think we need to practice ?

well explained

Nice explanation. Thank you👍👍

Great

i think we need to use recursive cte

Hindi mai he bol la

What about Null condition?

Logic you explained in the video 1 to 10 it is not cleared

Pyspark Step by Step approach and Solutions explanation video : kzbin.info/www/bejne/q4mriYSHe7aJsNUsi=bdOd4JnZz9O-gbJe

Using ur solution only 15 test cases passed out 17 Now they are asking us to handle null avg price May be they updated test cases Thanks you for sharing knowledge I solved it

Really good content.

Hi MLV, Great Video. I had a question why cant we use sumweight>=1000 it gives error I can't think of a case. Can you help? TIA

Thank you for the solution

why are we using sum here ?

good job

good job

good job

good job

good job