SQL Practice Problems Intermediate | CTEs Window Functions Subqueries | Interview Prep

Name: SQL Practice Problems Intermediate | CTEs Window Functions Subqueries | Interview Prep
Brand: DataGym
SKU: 4531555168
Price: 7.13 NZD
Availability: InStock

DataGym

You can only make an offer when buying a single item.

Highlights

Designed by DataGym
Digital download
Digital file type(s): 1 ZIP

★ THE SQL SKILLS THAT APPEAR IN EVERY DATA ANALYST INTERVIEW ★

5 intermediate SQL exercises covering CTEs, window functions and subqueries — the exact patterns tested in real job interviews at companies like Google, Amazon and Spotify.

──────────────────────────────
📦 WHAT'S INSIDE
──────────────────────────────
• SQL_Intermediate_Tasks.sql — exercises + full dataset
• SQL_Intermediate_Solutions.sql — solutions with detailed explanations
• README.txt

──────────────────────────────
📋 EXERCISES
──────────────────────────────
1. Subqueries — scalar, IN, NOT IN, correlated subqueries
2. CTEs — WITH clauses, chained CTEs
3. Window Functions — RANK, LAG, SUM OVER, AVG OVER PARTITION
4. CASE expressions — salary bands, shipping speed, margin categories
5. Date Functions & UNION — EXTRACT, DATEDIFF, UNION

⚙️ Requirements: PostgreSQL, MySQL, SQLite or SQL Server
⏱ Estimated time: 90–120 minutes
📁 Instant digital download

Instant Download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see programme terms