Rising Temperature | Leetcode 197 | Crack SQL Interviews in 50 Qs #mysql #leetcode

Want to crack SQL interviews? Check out our latest video!!!

A 50-questions SQL study plan to ace any interview.
This tutorial will walk you through the solution in easy steps. This is an easy-level question from Leetcode.

Consistency is what transforms average into excellence.
So be consistent & keep Coding💻!!

Timecodes
0:00 - Introduction
0:14 - Question Explanation
0:53 - Understanding Concept with the help of Example
2:56 - Writing SQL Query
5:20 - Explanation of the Query
6:33 - Outro

Connect With Me -

#coding
#leetcode
#mysql
#sql
#interview
#sqlinterview
#sqlinterviewquestionsandanswers
#sql_server
#article
#learnwithchirag
#temperature
#rising

[learnwithchirag]

Hey there! 👋 For more interesting content, tutorials, and updates, Feel free to connect with me on


Instagram Handles :-



Let's stay connected and keep the creativity flowing! 💡

[Still_standing]

Another Great Explanation, keep uploading these kind of videos

[EverydayLifeWithPrachiSameer]

Can you explain why you gave condition w1.temperature > w2.temperature and not vice-versa?

[nimbu_]

Nice Video Sir 🎉 Learned a lot about why we use those date functions and why they are so important!

[Engineeeer_]

I got stuck on this problem and ended up wasting a week because I gave up on the series. Now, I’m seeking help.

[CrazyGadgetss]

Bhai bohot acche se samjhaya ek baar me hi samajh me aagya

[kuldeepdhiman]

Hello Bhai, I have started following you playlist, my question is In first solution why you took
DATEDIFF(w1.recDate, w2.recDate) why w1 part first?and why not w2-w1? like that.

[ritik]

how did it work if we didn't write 'on' after the join? and why are we taking join at first place?i mean there is no use of join

[AsadRehman]

welldon bro
this problem messed up with me but you taught me well

[Domendra_KS]

Why we use inner join ? Can we use another join instead of inner join ?

[darkvoicefromheart]

nice explanation, khi nhi mil rha tha explanation, finally mil gya thank you!

[vaibhav]

what is the intuition behind using inner join in this case. Can we use that intuition for other joins?

[gunajipanchal]

Greate and simple explanation keep it up chirag thank you

[ashutoshgusain]

I'm using sql server.
And in that, datediff requires 3 functions, i.e, ( Interval, day1, day2 ).

Do i have to use lag() here?
Or is there any other way around?

[siddhanttiwari]

Bro how can we do that in postgeSQL, it is not working in pgsql !!

[marshalcode]

Bhai isme hm logo ne on kyu nhi use kia?

[prathamsrivastava]

sir generally inner join me hum on me mention krte h column name..jiske bases pr join hota h...agar hum wo mention nhi krte to join kaise work krega?

[Amazingrock]

your last explaination was wrong, pls correct it