Top Tweets for #SQLWithIDC
Sharing my 21 Days SQL Challenge Certificate! ๐
Thanks @IndianDataClub & @dpdzero for the learning journey.
#SQLWithIDC #SQL #Analytics
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
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
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;
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 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
day -18/21 Days SQl challenge
#SQLwithIDC
Getting back to the Grind of SQL
with @indiandataclub and @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 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
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
๐๐ฎ๐ 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
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
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
๐๐ฎ๐ 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 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
Last Seen Hashtags on Sotwe
Most Popular Users
Elon Musk 
@elonmusk
241.5M followers
Barack Obama
@barackobama
118.8M followers
Cristiano Ronaldo
@cristiano
114.5M followers
Donald J. Trump
@realdonaldtrump
111.8M followers
Narendra Modi
@narendramodi
107.1M followers
Rihanna
@rihanna
98.7M followers
NASA
@nasa
92.3M followers
Justin Bieber
@justinbieber
91.8M followers
KATY PERRY
@katyperry
90M followers
Taylor Swift
@taylorswift13
84M followers
Lady Gaga
@ladygaga
75.5M followers
Virat Kohli
@imvkohli
73.5M followers
Kim Kardashian
@kimkardashian
70.9M followers
YouTube
@youtube
68.8M followers
Neymar Jr
@neymarjr
66.5M followers
Bill Gates
@billgates
65.3M followers
Selena Gomez
@selenagomez
63.1M followers
The Ellen Show
@theellenshow
62.2M followers
CNN
@cnn
61.7M followers
X
@x
60.7M followers