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
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
2
18
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
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
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
14 Nov 2025
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
2
13
12 Nov 2025
Day 09/21dayssqlchallenge
#SQLwithIDC
SELECTservice,COUNT(patient_id) AS patient_count,
AVG(DATEDIFF(departure_date, arrival_date)) AS avg_length_of_stay
FROM PATIENTS
GROUP BY service
HAVING AVG(DATEDIFF(departure_date, arrival_date)) > 7
ORDER BY avg_length_of_stay DESC;
2
15
11 Nov 2025
Day 8 โ
of #21DaysSQLChallenge by @IndianDataClub x @DPDzero
Topic: String Functions โ UPPER, LOWER, LENGTH, CONCAT, SUBSTRING
๐ง Key takeaways:
โ๏ธ Text formatting & merging
โ๏ธ Age grouping
โ๏ธ String filtering
Challenge: Build a patient summary using these functions.
#SQL
2
21
11 Nov 2025
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
3
32
10 Nov 2025
Day 7 โ
of #21DaysSQLChallenge by @IndianDataClub x @DPDzero
๐ก Topic: HAVING Clause โ filtering aggregated results!
Learned:
โ
WHERE vs HAVING
โ
Filtering groups post-aggregation
โ
Combining multiple conditions
SQL gets logical & fun! ๐
#SQL #SQLWithIDC
2
29
10 Nov 2025
๐๏ธ Day 7 of #21DaysSQLChallenge by @indiandataclub!
Today's focus : HAVING clauseโจ
โก๏ธWHERE:
- Filters rows before grouping
- Cannot use aggregate functions
โก๏ธHAVING:
- Filters groups after grouping
- Can use aggregate functions
#SQLWithIDC #SQL
1
4
26
10 Nov 2025
Day 7 โ IDC 21 Days of SQL w/ #DPDzero
Task: Find services with >100 refusals & avg satisfaction < 80 ๐
Spotting high-friction services = key for patient experience ๐
Day 8 ๐
@dpdzero @indiandataclub
#21DaysSQLChallenge #SQLWithIDC #IndianDataClub #SQLPractice #Day7
2
16
10 Nov 2025
Day 7 of #21DaysSQLChallenge by @indiandataclub & @dpdzero
Topic: HAVING Clause
Learned how HAVING filters aggregated results after grouping โ unlike WHERE, which filters rows before grouping.
#SQL #DataAnalytics #SQLWithIDC #LearningInPublic
2
18