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
เนเธญเธฒเธเธฑเธเนเธเธซเนเธญเธเธเนเนเธฒ
Seen from Thailand
เธเธฒเธขเนเธเธตเนเธขเธงเธเนเธงเธขเธเธนเนเธชเธนเธเธงเธฑเธข
Seen from Thailand
anxiouspanda()+filter:native_video
Seen from India
minichat
Seen from Indonesia
เธเนเธฒเธซเธกเธฒ
Seen from Thailand
diyarbakฤฑrevlicift
Seen from Turkey
MGAI
Seen from Pakistan
minichatt
Seen from United States
caughtmasturbation
Seen from United States
Delga nsfw
Seen from Turkey
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