10 Dec 2025
Sharing my 21 Days SQL Challenge Certificate! ๐
Thanks @IndianDataClub & @dpdzero for the learning journey.
#SQLWithIDC #SQL #Analytics
2
17
27 Nov 2025
Day 21 โ #21DaysSQLChallenge (Final Day!) ๐
Wrapped up the challenge by building a full performance dashboard
1๏ธโฃ Patient metrics
2๏ธโฃ Service metrics
3๏ธโฃ Staff metrics
21 days done โ SQL muscles upgraded ๐ช
@dpdzero @indiandataclub
#SQLWithIDC #SQL #DataAnalytics #Day21
1
2
32
25 Nov 2025
Day 19 of my 21 Days SQL Challenge โก
Exploring row level ranking for deeper analytical insights
Topics: ROW_NUMBER(), RANK(), DENSE_RANK(), OVER clause
Challenge by
@indiandataclub & @dpdzero
#21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC
2
12
25 Nov 2025
Day 19/21 days sql challenge
#SQLwithIDC
with @indiandataclub and @dpdzero
SELECT SERVICE,
SUM(PATIENTS_ADMITTED) AS TOTAL_PATIENTS_ADMITTED,
RANK() OVER (ORDER BY SUM(PATIENTS_ADMITTED) DESC) AS ADMISSION_RANK
FROM SERVICES_WEEKLY
GROUP BY SERVICE;
3
27
24 Nov 2025
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
3
20
24 Nov 2025
Day 18 of my 21 Days SQL Challenge โก
Learning how to merge results from multiple queries into one dataset.
Topics: UNION, UNION ALL, combining result sets
Challenge by
@indiandataclub
&
@dpdzero
#21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC
4
18
24 Nov 2025
day -18/21 Days SQl challenge
#SQLwithIDC
Getting back to the Grind of SQL
with @indiandataclub and @dpdzero
4
27
23 Nov 2025
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
1
3
76
21 Nov 2025
๐ Day 15 โ SQL Healthcare Analytics
Todayโs task: Build a service-level performance report for Week 20 combining:
Bringing admissions, satisfaction & staffing into a single view = real insights.
@dpdzero @indiandataclub
#21DaysSQLChallenge #SQLWithIDC #DataAnalytics #Day15
1
3
36
21 Nov 2025
3
23
19 Nov 2025
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
2
18
18 Nov 2025
๐๐ฎ๐ 14 of #21DaysSQLChallenge ๐
Todayโs focus: LEFT & RIGHT JOIN โ include unmatched records for a complete view.
๐ก Key Takeaways:
โ
LEFT JOIN โ all left rows matches
โ
RIGHT JOIN โ all right rows matches
โ
Use COALESCE to handle NULLs
#SQLWithIDC
3
17
18 Nov 2025
Day 14 of my 21 Days SQL Challenge โก
Topics: LEFT JOIN, RIGHT JOIN, including unmatched records
Challenge by
@indiandataclub & @dpdzero
#21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC
2
19
17 Nov 2025
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
2
19
17 Nov 2025
๐๐ฎ๐ 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
2
27
15 Nov 2025
2
22
15 Nov 2025
Hereโs the Day 11 Challenge for 21 Days of SQL.
Letโs do it together!
@dpdzero #SQLWithIDC
2
63
14 Nov 2025
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
1
2
19