Im between cherry

Leet Code | MySQL | 197. Rising Temperature 본문

데이터분석/practice_query

Leet Code | MySQL | 197. Rising Temperature

meal 2020. 8. 30. 15:35

197. Rising Temperature

 

https://leetcode.com/problems/rising-temperature/

 

Rising Temperature - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

Write an SQL query to find all dates' id with higher temperature compared to its previous dates (yesterday).

Return the result table in any order.

 

 

SELECT today.id
FROM Weather AS today
    INNER JOIN Weather AS yesterday ON DATE_ADD(yesterday.recordDate, INTERVAL 1 DAY) = today.recordDate
WHERE today.temperature > yesterday.temperature

 

저작자표시

'데이터분석 > practice_query' 카테고리의 다른 글

Leet Code | MySQL | 1179. Reformat Department Table  (0) 2020.08.30
Leet Code | MySQL | 183. Customers Who Never Order  (0) 2020.08.30
Leet Code | MySQL | 185. Department Top Three Salaries  (0) 2020.08.30
Leet Code | MySQL | 184. Department Highest Salary  (0) 2020.08.30
Leet Code | MySQL | 180. Consecutive Numbers  (0) 2020.08.30
'데이터분석/practice_query' Related Articles more
Comments