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

Day 10 ✅ of #21DaysSQLChallenge by @IndianDataClub x @DPDzero Topic: CASE WHEN & Conditional Logic Today I learned to make SQL smarter — adding if-else logic inside queries 💡 Categorized satisfaction, grouped patients, & built performance reports with CASE! #SQLWithIDC

𝗗𝗮𝘆 12 #21DaysSQLChallenge 🚀 Handling NULLs & comparing categories ✅ IS NULL / IS NOT NULL ✅ COALESCE for fallback ✅ COUNT(*) vs COUNT(column) ✅ CTE + CASE for clean summaries ⚠️ Don’t treat NULL as a value Stepwise queries = clear & scalable SQL! 🙌 #SQLWithIDC

𝐃𝐚𝐲 𝟎𝟗– #21DaysSQLChallenge with @indiandataclub Club sponsored by @dpdzero 𝐓𝐨𝐩𝐢𝐜: 𝐃𝐀𝐓𝐄 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬, 𝐃𝐚𝐭𝐞 𝐀𝐫𝐢𝐭𝐡𝐦𝐞𝐭𝐢𝐜, 𝐄𝐗𝐓𝐑𝐀𝐂𝐓

Day 13 – IDC 21 Days of SQL w/ #DPDzero Built a report linking patients + staff availability. included services with >5 staff & sorted by staff count 👇 Cross-table insights = stronger analysis 💪 @dpdzero @indiandataclub #21DaysSQLChallenge #SQLWithIDC #DataAnalytics #Day13

Day 13 of my 21 Days SQL Challenge ⚡ Topics: INNER JOIN, joining two tables, relationship understanding Challenge by @indiandataclub & @dpdzero #21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC

Day 11 ✅ of #21DaysSQLChallenge by @IndianDataClub x @DPDzero Learned how to use DISTINCT to remove duplicates, get unique values, and count unique combos. Challenge: Find unique service + event pairs (excluding null/none) & sort by count. Loving the progress! 🚀 #SQL

Day 11 of my 21 Days SQL Challenge ⚡ DISTINCT and Handling Duplicates Topics: DISTINCT, removing duplicates, unique values Challenge by @indiandataclub & @dpdzero #21DaysSQLChallenge #sqldevelopers #LearnSQL #DataAnalytics #SQLwithIDC

Day 12 of #21DaysSQLChallenge by @indiandataclub! Today’s focus: NULL values — the silent troublemakers in every dataset.😄 In SQL, NULL simply means unknown. Not 0. Not empty. Not missing a value intentionally. To replace NULLs, we can use COALESCE()! #SQLWithIDC #SQL

Day 12 – IDC 21 Days of SQL w/ #DPDzero Analyzed event impact by comparing weeks with events vs no events 👇 Events clearly influence satisfaction & morale 📊 On to Day 13 🚀 @dpdzero @indiandataclub #21DaysSQLChallenge #SQLLearning #DataAnalytics #SQLWithIDC #Day12

Day 12 of #21DaysSQLChallenge Highlights: • = doesn’t work on NULL • COUNT(*) vs COUNT(column) • COALESCE for default values • NULL breaks arithmetic • Handled NULLs properly in ORDER BY #SQLWithIDC @dpdzero @indiandataclub

Day 10 of my 21 Days SQL Challenge ⚡ Topics: CASE WHEN, conditional logic, derived columns Challenge by @indiandataclub & @dpdzero #21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC

Day 9 ✅ of #21DaysSQLChallenge by @IndianDataClub x @DPDzero Topic – Date Functions in SQL ⏰ Today’s challenge focused on: 📅 Working with DATE functions 📊 Calculating avg stay per service (>7 days) 🧠 Key learnings: DATEDIFF, EXTRACT, date formats & filtering #SQL

Day 9 of #21DaysSQLChallenge Date functions Learned how SQL handles time using YEAR(), MONTHNAME(), and DATEDIFF(). Got the order right: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY. Date format matters. Keep it YYYY-MM-DD. #SQLWithIDC @dpdzero @indiandataclub

Excited to keep improving my SQL logic and query efficiency through the 21 Days of SQL Challenge by @indiandataclub Club and @dpdzero ! #SQL #DataAnalytics #IndianDataClub #LearningJourney #IDCWithSQL #21DaysSQLChallenge

Day 10 | #21DaysSQLChallenge with @indiandataclub & @dpdzero Learned conditional logic with CASE WHEN: 🔹 Categorised satisfaction levels 🔹 Grouped staff roles 💡 Challenge: Classify services as Excellent, Good, Fair, or Needs Improvement #SQLWithIDC #SQL #DataAnalytics

Day 11 of #21DaysSQLChallenge by @IndianDataClub & @dpdzero 🔹 Topic: DISTINCT & Removing Duplicates Learned how to fetch unique values, count distinct entries, and handle duplicate records efficiently using DISTINCT and COUNT(DISTINCT). #SQLWithIDC #LearnSQL #IDCChallenge

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 12 of my 21 Days SQL Challenge ⚡ NULL Values and IS NULL / IS NOT NULL Topics: NULL handling, IS NULL, IS NOT NULL, COALESCE Challenge by @indiandataclub & @dpdzero #21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC

Day 9 of #21DaysSQLChallenge by @IndianDataClub & @dpdzero 🔹 Topic: Date Functions Learned to work with dates in SQL — from calculating stay duration to filtering patients by month/year. #SQLWithIDC #LearnSQL #DataAnalytics #SQLDeveloper #IDCChallenge