#SQLWithIDC

Day 10 of #SQLWithIDC 🚀— CASE statements 💡 Key takeaways: • Use CASE to categorize or create conditional metrics • Always include ELSE (avoid NULLs) • Works in SELECT, ORDER BY, and GROUP BY • First match wins — order matters!

Day 6 of #SQLWithIDC 🚀 Today’s focus: GROUP BY — the magic that turns raw data into insights! 📊 💡 Key learnings: • One row per group • Combine with COUNT, SUM, AVG for summaries • Use WHERE before, HAVING after GROUP BY • Order by aggregates for ranked insights

Day 18 — #21DaysSQL Challenge with #SQLWithIDC Today’s task: 🔗 Combine patients + staff from critical departments (Surgery & Emergency) @dpdzero @indiandataclub unified healthcare insights On to Day 19! 🚀 #SQL #DataAnalytics #IndianDataClub #DPDzero #AnalyticsJourney

Good morning everyone! Here’s the Day 1 challenge for 21 Days of SQL. Let’s do it together! @dpdzero #SQLWithIDC

𝗗𝗮𝘆 13 of #21DaysSQLChallenge 🚀 INNER JOIN — connect tables, get only matching rows. 💡 Tips: ✅ Use aliases & qualify columns ✅ Chain joins for insights ✅ Filter with WHERE after join #SQLWithIDC

Here’s the Day 7 challenge for 21 Days of SQL. Let’s do it together! @dpdzero #SQLWithIDC

This time we are Coming with 21 Days SQL Challenge For More information visit our LinkedIn Page - #SQLwithIDC Stay tuned 😁

Here’s the Day 9 Challenge for 21 Days of SQL. Let’s do it together! @dpdzero #SQLWithIDC

Here’s the Day 6 challenge for 21 Days of SQL. Let’s do it together! @dpdzero #SQLWithIDC

Up for this challenge starting from tomorrow. Today's Induction call was insightful. Thanks a ton, Indian Data Club | @indiandataclub and @dpdzero for #SQLWithIDC challenge. Looking forward to sharing what and how I learned with the data world, here! Stay tuned :)

Registration is live for the 21 Days of SQL Challenge! 👉 *Post link (Read it carefully)* : 👉 *Registration form* (feel free to share this with your friends): 📅 Challenge starts on 3rd November. #SQLWithIDC

🗓️ Day 2 of the 21 Days SQL Challenge by @indiandataclub! Yesterday was all about the SELECT statement — the base of every query. Today, it was about filtering data with the WHERE clause.🎯 It’s how you tell your database: “I want this, but not that.” #SQLWithIDC #SQL

Day 1 of the IDC 21 Days of SQL Challenge organized by @indiandataclub @dpdzero #SQLWithIDC Brushed up the SQL - SELECT , filtering , distinct #SQL #sqlbasics

Here’s the Day 2 challenge for 21 Days of SQL. Let’s do it together! @dpdzero #SQLWithIDC

Day 14 ✅ of #21DaysSQLChallenge by @IndianDataClub x @DPDzero Explored LEFT & RIGHT JOIN to handle unmatched records. Built a staff utilization report showing all staff + their weeks present. Takeaway: JOINs + COALESCE = clean, complete insights. #SQLWithIDC #SQL

Day 8 of #21DaysSQLChallenge 🚀 Today’s focus: String Functions ✨ 💡 Key takeaways: • UPPER() / LOWER() – change text case • CONCAT() – join strings • SUBSTRING() – extract parts • LENGTH() – count chars • REPLACE() / TRIM() – clean text #SQLWithIDC

📌 21 Day SQL Challenge | Day 18 | IDC | DPDzero Blending patient and staff data gives a clearer picture of how services operate. Today, I combined both groups into one unified view across two high-demand services: surgery and emergency.

Time to reflect: Sometimes the simplest queries give the strongest operational insights. A clean list can reveal a great deal about workload, coverage, and patient flow.

#SQLWithIDC #DataAnalytics #21DayChallenge #learnsql @indiandataclub @dpdzero

Day 17 — #21DaysSQLChallenge (IDC) Task: Compare each hospital service’s admissions against the overall average. 🔍 What we reported: 🧠 identify services & areas needing support. @dpdzero @indiandataclub On to Day 18 🚀 #SQLWithIDC #DataAnalytics #DPDzero #IndianDataClub

Day 4 ✅ of #21DaysSQLChallenge by @IndianDataClub x @DPDzero 🧩 Topic: LIMIT and OFFSET 💻 Challenge: Fetch 3rd–7th highest patient satisfaction scores 👇 SELECT patient_id, name, service, satisfaction FROM patients ORDER BY satisfaction DESC LIMIT 5 OFFSET 2; #SQLWithIDC

Day 3 of #21DaysSQLChallenge by @indiandataclub & @dpdzero Topic : Sorting Data with ORDER BY Focused on sorting data using the ORDER BY clause. Learned how to sort in ascending/descending order and use multiple column sorting. #indiandataclub #SQLWithIDC #21DaysSQLChallenge