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
vocparkandzoo
Seen from United States
unforgettablebook
Seen from United States
omg4eva
Seen from United States
aydinpasif
Seen from Turkey
DiscoveringAI
Seen from United States
trumpVsCongress
Seen from Turkey
Teenage() +filter:native_video
Seen from Dominican Republic
blowjob #hijab
Seen from Turkey
hijo #incest
Seen from Peru
FCใปใซใใข็บ็ฐ
Seen from United States
Most Popular Users
Elon Musk 
@elonmusk
240.9M followers
Barack Obama
@barackobama
119.2M followers
Donald J. Trump
@realdonaldtrump
111.8M followers
Cristiano Ronaldo
@cristiano
111.4M followers
Narendra Modi
@narendramodi
107M followers
Rihanna
@rihanna
97.9M followers
NASA
@nasa
92.2M followers
Justin Bieber
@justinbieber
91.1M followers
KATY PERRY
@katyperry
88.1M followers
Taylor Swift
@taylorswift13
82M followers
Lady Gaga
@ladygaga
73.5M followers
Virat Kohli
@imvkohli
70.6M followers
Kim Kardashian
@kimkardashian
70M followers
YouTube
@youtube
68.7M followers
Bill Gates
@billgates
64.1M followers
Neymar Jr
@neymarjr
63.4M followers
The Ellen Show
@theellenshow
62.4M followers
CNN
@cnn
61.9M followers
Selena Gomez
@selenagomez
61.2M followers
X
@x
60.8M followers