# @aartii.py on Instagram

- **Type:** Video
- **Original URL:** https://www.instagram.com/p/Da-eCGdvu1H
- **Gondola URL:** https://gondola.cc/posts/68064506-aartiipy-instagram
- **Thumbnail:** https://img.gondola.cc/tr:w-,h-,fo-auto/postThumbnails/6f9a82c193.jpg
- **Posted:** 2026-07-19T13:30:15.000+00:00
- **Account Owner:** Aarti Sinha (@aartii.py) — https://gondola.cc/aartii.py

## Caption

“I know SQL” — okay, solve this assessment question: top 3 products by revenue, PER region. Yeah. That feeling. 😅

Your SQL ends at SELECT and WHERE. The recruiter’s SQL screen STARTS there. Real data analyst interviews test three things: JOINs across 3 tables, window functions (RANK, ROW_NUMBER), and CTEs. And here’s the truth — all three are just TWO WEEKS beyond basic SQL. Two weeks that 90% of your batch will never give.

I solved one live in today’s video — including the thinking pauses, because that’s what they actually grade: process, not perfection.

📌 HOMEWORK: Comment “SQL” — my 10 window-function problems with a ready schema, free, in your DMs.
📤 Share with your placement prep group
💾 Save — you’ll need this before every SQL screen

Follow @aartii.py — tomorrow: Power BI vs Tableau, settled with data.#SQLInterview #SQLforDataAnalyst #PlacementPreparation #DataAnalystInterview #LearnSQL

SQL interview questions, SQL for data analyst, window functions SQL, SQL joins explained, CTE in SQL, SQL assessment test, SQL practice problems, data analyst interview prep, SQL for freshers, RANK vs DENSE_RANK

## Stats

- **Views:** 3,784
- **Likes:** 3
- **Shares:** 0
- **Comments:** 26

## Tags

dataanalystinterview, placementpreparation, sqlfordataanalyst, learnsql, sqlinterview

---
Copyright (c) Gondola