Back to Browse

Subquery and RANK() Window Function in SQL or merge() and groupby() in Python Pandas? Leetcode 184

12 views
Apr 24, 2026
6:52

Which tool should you use in your next technical interview: SQL or Pandas? We're solving LeetCode Problem #184, "Department Highest Salary," to see how both stack up. We cover: ✅ Subquery in SQL ✅ The RANK() window function in SQL ✅ Pandas .groupby() and .merge() operations ⏱️ Timestamps: 0:00 - Intro 0:44 - SQL Solution 3:40 - Python Pandas Solution Check out my Playlist: https://www.youtube.com/playlist?list=PLGT-z9cVth9mua-HvnqhN2FQTisyZjQ4B 💡 Subscribe for more LeetCode deep dives and FAANG prep! www.youtube.com/@datahead_girl #leetcode #sql #python #pandas #dataanalytics #interviewprep #datascience #coding

Download

1 formats

Video Formats

360pmp45.0 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Subquery and RANK() Window Function in SQL or merge() and groupby() in Python Pandas? Leetcode 184 | NatokHD