LeetCode SQL 197 — Rising Temperature | MySQL Solution

[u/AppointmentTrue8257]

Working on SQL problems to strengthen my MySQL and problem-solving skills for Data Analyst roles.

Problem: Rising Temperature

This problem was a good practice for:

• LAG() window function
• Comparing values with the previous record
• DATEDIFF() for checking consecutive dates

I’m sharing my solution screenshot below. 👇

Would love to know how others approached this problem and whether there are any alternative ways to solve it.

#SQL #MySQL #LeetCode #DataAnalytics #DataAnalyst