---
title: "Discussion on \"🌡️ Detecting Hotter Days with SQL Window Functions\" | Hashnode"
description: "Discussion on \"🌡️ Detecting Hotter Days with SQL Window Functions\". Analyzing Temperature Rises with SQL: Learn from LeetCode’s 197 Challenge"
url: "https://hashnode.com/posts/detecting-hotter-days-with-sql-window-functions/68aebb6416ffe0a9714004f6"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [🌡️ Detecting Hotter Days with SQL Window Functions](https://advance-sql.hashnode.dev/detecting-hotter-days-with-sql-window-functions?utm_source=hashnode&utm_medium=feed)

Analyzing Temperature Rises with SQL: Learn from LeetCode’s 197 Challenge

Aug 27, 2025 · 2 min read · advance-sql.hashnode.dev  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#data-science](https://hashnode.com/tag/data-science)
-   [#databases](https://hashnode.com/tag/databases)
-   [#leetcode](https://hashnode.com/tag/leetcode)

## Written by

[Ardhendu Ghosh](https://hashnode.com/@ardhendughosh)

@ardhendughosh · India

  
[View profile](https://hashnode.com/@ardhendughosh)

DYNAMIC

🧵 Stitching logic into data, culture into pixels, and clarity into workflows. I’m Ardhendu Ghosh—a systems architect in the making, blending SQL precision, annotation logic, and creative restoration into scalable, story-driven solutions. I build: 🧠 Reusable query modules for streaks, duplicates &amp; classification 🎨 Emotionally attentive image enhancements (yes, even bindis matter) 📊 Dashboard-ready logic for annotation pipelines &amp; public sharing ✍️ SEO-optimized content for Hashnode, LinkedIn &amp; beyond If it’s repeatable, teachable, and culturally meaningful—I’m building it.

## Responses 1

Markdown supported · ⌘↵ to post

[Aet](https://hashnode.com/@dfree)

[Aug 27, 2025](https://hashnode.com/posts/detecting-hotter-days-with-sql-window-functions/68aebb6416ffe0a9714004f6/comment/68aed038521469f7f308219b)

pretty good
