#SQLwithIDC

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

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

Here’s the Day 7 challenge for 21 Days of SQL. Let’s do it together! @dpdzero #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

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

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

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 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 07/21: Back to the SQL grind Query: SELECT service, SUM(patients_refused) AS total_refused, AVG(patient_satisfaction) AS avg_satisfaction FROM SERVICES_WEEKLY GROUP BY service HAVING SUM(patients_refused) > 100 AND AVG(patient_satisfaction) < 80; #SQLwithIDC

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

Day 11 of #21DaysSQLChallenge with @indiandataclub! Today's topic: DISTINCT keyword — the simplest way to handle duplicates✨ ✅ COUNT(DISTINCT col) for unique counts ✅ GROUP BY for aggregates, DISTINCT for quick de-duplication ✅ NULL values count as one #SQLWithIDC #SQL

🗓️ Day 3 of #21DaysSQLChallenge by @indiandataclub! Today’s focus: ORDER BY 🎯 It helps you sort query results — alphabetically, numerically, or by date. Use ASC (default) or DESC for descending order. #SQLWithIDC #SQL

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

🚀 Kicking off the 21 Days SQL Challenge with @indiandataclub! Daily learning, practicing & implementing SQL to grow step by step. Starts today & registrations close at 9 PM ⏰ Consistency > Complexity. Let’s level up together! 💪 #SQLWithIDC

Day 1/21 – #SQLwithIDC Challenge Getting back to SQL feels refreshing! Task: List unique services available in hospitals. Query: SELECT DISTINCT service FROM services_weekly;Output: emergency, general_medicine, ICU, surgery .Glad to be part of this challenge with @indiandataclub

𝗗𝗮𝘆 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

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 :)

Day 4/21 – #SQLwithIDC Challenge 💪 Getting back to the SQL grind! 🧠 Find the 3rd to 7th highest patient satisfaction scores from the patients table SELECT patient_id, name, service, satisfaction FROM patients ORDER BY satisfaction DESC LIMIT 5 OFFSET 2;

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