# @aartii.py on Instagram

- **Type:** Video
- **Original URL:** https://www.instagram.com/p/DSsdcCzDe_E
- **Gondola URL:** https://gondola.cc/posts/59916596-aartiipy-instagram
- **Thumbnail:** https://img.gondola.cc/tr:w-,h-,fo-auto/postThumbnails/fd58820d99.jpg
- **Posted:** 2025-12-25T17:26:59.000+00:00
- **Account Owner:** Aarti Sinha (@aartii.py) — https://gondola.cc/aartii.py

## Caption

Day 7/7 – SQL Challenge FINALE 🎯

This query was slow on 10M+ rows 👇
Execution time: 8.4s ❌

SELECT *
FROM Orders
WHERE customer_id IN (
 SELECT id FROM Customers WHERE country=‘USA’
)
AND YEAR(order_date)=2024;

Optimized version — 2.1s ✅ (4x faster):

SELECT o.order_id, o.customer_id, o.amount, o.order_date
FROM Orders o
JOIN Customers c ON o.customer_id = c.id
WHERE c.country=‘USA’
AND o.order_date >= ‘2024-01-01’
AND o.order_date < ‘2025-01-01’;

What changed:
✔ Selected only needed columns
✔ JOIN instead of IN
✔ Date range instead of YEAR()
✔ Index-friendly filters

Optimization tips:
🔹 Avoid functions on indexed columns
🔹 Use EXPLAIN ANALYZE
🔹 Index filter + join columns
🔹 Avoid SELECT *

🔥 7 Days Complete!
Drop “COMPLETED” if you finished the SQL Challenge!

#SQLChallenge #Day7 #QueryOptimization #DataScience #SQL FAANG 7DaysComplete SQLMastery

## Stats

- **Views:** 5,349
- **Likes:** 386
- **Shares:** 0
- **Comments:** 13

## Tags

sqlchallenge, queryoptimization, sql, day7, datascience

---
Copyright (c) Gondola