#21daysofsql search results

๐Ÿš€ Day 10 | #21DaysOfSQL by @IndianDataClub x @DPDzero Explored CASE statements for conditional logic Perfect for categorizing data & creating dynamic columns! ๐ŸŽฏChallenge: Build a service report with avg satisfaction โ†’ tag as Excellent, Good, Fair, or Needs Improvement #Data

DhanapuneGagan's tweet image. ๐Ÿš€ Day 10 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored CASE statements for conditional logic Perfect for categorizing data & creating dynamic columns!
๐ŸŽฏChallenge:
Build a service report with avg satisfaction โ†’ tag as Excellent, Good, Fair, or Needs Improvement
#Data
DhanapuneGagan's tweet image. ๐Ÿš€ Day 10 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored CASE statements for conditional logic Perfect for categorizing data & creating dynamic columns!
๐ŸŽฏChallenge:
Build a service report with avg satisfaction โ†’ tag as Excellent, Good, Fair, or Needs Improvement
#Data

7-Day SQL Learning Streak! Proud to stay consistent in the #21DaysOfSQL challenge by @IndianDataClub x @DPDzero ๐Ÿ”ฅ Every single day is helping me sharpen my data mindset and SQL fundamentals. On to Day 8 ๐Ÿš€ #SQLWithIDC #DataAnalytics #LearningJourney #Consistency

DhanapuneGagan's tweet image. 7-Day SQL Learning Streak!
Proud to stay consistent in the #21DaysOfSQL challenge by @IndianDataClub x @DPDzero ๐Ÿ”ฅ
Every single day is helping me sharpen my data mindset and SQL fundamentals.
On to Day 8 ๐Ÿš€
#SQLWithIDC #DataAnalytics #LearningJourney #Consistency

๐Ÿš€ Day 12 | #21DaysOfSQL by @IndianDataClub x @DPDzero Focused on handling NULL values ๐Ÿงฉ Learned IS NULL, IS NOT NULL, and COALESCE to clean & manage missing data. ๐ŸŽฏ Challenge: Compare weeks with vs without events โ†’ avg satisfaction & staff morale #SQL #DataAnalytics #Day12

DhanapuneGagan's tweet image. ๐Ÿš€ Day 12 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on handling NULL values ๐Ÿงฉ
Learned IS NULL, IS NOT NULL, and COALESCE to clean & manage missing data.
๐ŸŽฏ Challenge:
Compare weeks with vs without events โ†’ avg satisfaction & staff morale
#SQL #DataAnalytics #Day12
DhanapuneGagan's tweet image. ๐Ÿš€ Day 12 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on handling NULL values ๐Ÿงฉ
Learned IS NULL, IS NOT NULL, and COALESCE to clean & manage missing data.
๐ŸŽฏ Challenge:
Compare weeks with vs without events โ†’ avg satisfaction & staff morale
#SQL #DataAnalytics #Day12

๐Ÿš€ Day 7 | #21DaysOfSQL by @IndianDataClub x @DPDzero Covered HAVING โ€” used to filter results after GROUP BY ๐Ÿ” Perfect for conditions on aggregates like COUNT & AVG. ๐ŸŽฏ Challenge: Find services with >100 refusals & avg satisfaction < 80. #SQL #DataAnalytics #Day7

DhanapuneGagan's tweet image. ๐Ÿš€ Day 7 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Covered HAVING โ€” used to filter results after GROUP BY ๐Ÿ”
Perfect for conditions on aggregates like COUNT &amp;amp; AVG.

๐ŸŽฏ Challenge:
Find services with &amp;gt;100 refusals &amp;amp; avg satisfaction &amp;lt; 80.
#SQL #DataAnalytics #Day7
DhanapuneGagan's tweet image. ๐Ÿš€ Day 7 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Covered HAVING โ€” used to filter results after GROUP BY ๐Ÿ”
Perfect for conditions on aggregates like COUNT &amp;amp; AVG.

๐ŸŽฏ Challenge:
Find services with &amp;gt;100 refusals &amp;amp; avg satisfaction &amp;lt; 80.
#SQL #DataAnalytics #Day7

๐Ÿš€ Day 4 | #21DaysOfSQL by @IndianDataClub x @DPDzero Explored LIMIT + OFFSET for pagination ๐Ÿ“„ ๐Ÿ”น LIMIT โ†’ restrict rows ๐Ÿ”น OFFSET โ†’ skip rows ๐Ÿ”น Better with ORDER BY ๐ŸŽฏ Challenge: Get 3rdโ€“7th highest satisfaction scores (patient_id, name, service, satisfaction). #SQL #Day4

DhanapuneGagan's tweet image. ๐Ÿš€ Day 4 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored LIMIT + OFFSET for pagination ๐Ÿ“„
๐Ÿ”น LIMIT โ†’ restrict rows
๐Ÿ”น OFFSET โ†’ skip rows
๐Ÿ”น Better with ORDER BY

๐ŸŽฏ Challenge:
Get 3rdโ€“7th highest satisfaction scores (patient_id, name, service, satisfaction).
#SQL #Day4
DhanapuneGagan's tweet image. ๐Ÿš€ Day 4 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored LIMIT + OFFSET for pagination ๐Ÿ“„
๐Ÿ”น LIMIT โ†’ restrict rows
๐Ÿ”น OFFSET โ†’ skip rows
๐Ÿ”น Better with ORDER BY

๐ŸŽฏ Challenge:
Get 3rdโ€“7th highest satisfaction scores (patient_id, name, service, satisfaction).
#SQL #Day4

๐Ÿš€ Day 2 | #21DaysOfSQL by @IndianDataClub x @DPDzero Focused on mastering the WHERE clause ๐Ÿ” ๐Ÿง  Learned filtering with =, !=, AND, OR, IN, BETWEEN, LIKE ๐ŸŽฏChallenge: Find patients in Surgery with satisfaction < 70 ๐Ÿฅ ๐Ÿ”— Repo: github.com/gagan8605/IDC_โ€ฆ #SQL #DataAnalytics #Day2

DhanapuneGagan's tweet image. ๐Ÿš€ Day 2 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on mastering the WHERE clause ๐Ÿ”
๐Ÿง  Learned filtering with =, !=, AND, OR, IN, BETWEEN, LIKE
๐ŸŽฏChallenge: Find patients in Surgery with satisfaction &amp;lt; 70 ๐Ÿฅ
๐Ÿ”— Repo: github.com/gagan8605/IDC_โ€ฆ
#SQL #DataAnalytics #Day2
DhanapuneGagan's tweet image. ๐Ÿš€ Day 2 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on mastering the WHERE clause ๐Ÿ”
๐Ÿง  Learned filtering with =, !=, AND, OR, IN, BETWEEN, LIKE
๐ŸŽฏChallenge: Find patients in Surgery with satisfaction &amp;lt; 70 ๐Ÿฅ
๐Ÿ”— Repo: github.com/gagan8605/IDC_โ€ฆ
#SQL #DataAnalytics #Day2

๐Ÿš€ Day 8 | #21DaysOfSQL by @IndianDataClub x @DPDzero Worked with string functions: UPPER, LOWER, LENGTH, CONCAT, SUBSTRING โœจ Great for cleaning + formatting text data. ๐ŸŽฏ Challenge: Build patient summary (name formatting, age group, length > 10). #SQL #DataAnalytics #Day8

DhanapuneGagan's tweet image. ๐Ÿš€ Day 8 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Worked with string functions: UPPER, LOWER, LENGTH, CONCAT, SUBSTRING โœจ
Great for cleaning + formatting text data.

๐ŸŽฏ Challenge:
Build patient summary (name formatting, age group, length &amp;gt; 10).
#SQL #DataAnalytics #Day8
DhanapuneGagan's tweet image. ๐Ÿš€ Day 8 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Worked with string functions: UPPER, LOWER, LENGTH, CONCAT, SUBSTRING โœจ
Great for cleaning + formatting text data.

๐ŸŽฏ Challenge:
Build patient summary (name formatting, age group, length &amp;gt; 10).
#SQL #DataAnalytics #Day8

๐Ÿš€ Day 9 | #21DaysOfSQL by @IndianDataClub x @DPDzero Explored date functions: extraction, date math & filtering Useful for length-of-stay, month/year grouping, & timelines. ๐ŸŽฏ Challenge: Avg stay (days) per service โ†’ show only >7 days + patient count (DESC). #SQL #Data #day9

DhanapuneGagan's tweet image. ๐Ÿš€ Day 9 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored date functions: extraction, date math &amp;amp; filtering 
Useful for length-of-stay, month/year grouping, &amp;amp; timelines.
๐ŸŽฏ Challenge:
Avg stay (days) per service โ†’ show only &amp;gt;7 days + patient count (DESC).
#SQL #Data #day9
DhanapuneGagan's tweet image. ๐Ÿš€ Day 9 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored date functions: extraction, date math &amp;amp; filtering 
Useful for length-of-stay, month/year grouping, &amp;amp; timelines.
๐ŸŽฏ Challenge:
Avg stay (days) per service โ†’ show only &amp;gt;7 days + patient count (DESC).
#SQL #Data #day9

๐Ÿš€ Day 1 | #21DaysOfSQL by @IndianDataClub x @DPDzero Learned the power of SELECT โ€” the first step in talking to data! ๐Ÿง  SELECT * | Columns | LIMIT | DISTINCT ๐ŸŽฏ Challenge: List unique hospital services ๐Ÿฅ ๐Ÿ“Š Repo Link | ๐Ÿ”— github.com/gagan8605/IDC_โ€ฆ #SQL #DataAnalytics #Day1

DhanapuneGagan's tweet image. ๐Ÿš€ Day 1 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Learned the power of SELECT โ€” the first step in talking to data!
๐Ÿง  SELECT * | Columns | LIMIT | DISTINCT

๐ŸŽฏ Challenge: List unique hospital services ๐Ÿฅ
๐Ÿ“Š  Repo Link  | ๐Ÿ”— github.com/gagan8605/IDC_โ€ฆ
#SQL #DataAnalytics #Day1
DhanapuneGagan's tweet image. ๐Ÿš€ Day 1 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Learned the power of SELECT โ€” the first step in talking to data!
๐Ÿง  SELECT * | Columns | LIMIT | DISTINCT

๐ŸŽฏ Challenge: List unique hospital services ๐Ÿฅ
๐Ÿ“Š  Repo Link  | ๐Ÿ”— github.com/gagan8605/IDC_โ€ฆ
#SQL #DataAnalytics #Day1

๐Ÿš€ Day 3 | #21DaysOfSQL by @IndianDataClub x @DPDzero Focused on ORDER BY for sorting ๐Ÿ“Š ๐Ÿ”น Sort by age (DESC) ๐Ÿ”น Weekly data by week ASC + requests DESC ๐Ÿ”น Staff sorted Aโ†’Z ๐ŸŽฏ Challenge: Top 5 weeks with highest patient refusals ๐Ÿ” #SQL #DataAnalytics #Day3

DhanapuneGagan's tweet image. ๐Ÿš€ Day 3 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on ORDER BY for sorting ๐Ÿ“Š
๐Ÿ”น Sort by age (DESC)
๐Ÿ”น Weekly data by week ASC + requests DESC
๐Ÿ”น Staff sorted Aโ†’Z

๐ŸŽฏ Challenge: Top 5 weeks with highest patient refusals ๐Ÿ”
#SQL #DataAnalytics #Day3
DhanapuneGagan's tweet image. ๐Ÿš€ Day 3 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on ORDER BY for sorting ๐Ÿ“Š
๐Ÿ”น Sort by age (DESC)
๐Ÿ”น Weekly data by week ASC + requests DESC
๐Ÿ”น Staff sorted Aโ†’Z

๐ŸŽฏ Challenge: Top 5 weeks with highest patient refusals ๐Ÿ”
#SQL #DataAnalytics #Day3

๐Ÿš€ Day 5 | #21DaysOfSQL by @IndianDataClub x @DPDzero Focused on aggregates: COUNT, SUM, AVG, MIN, MAX ๐Ÿ“Š Great for totals, averages & minโ€“max insights. ๐ŸŽฏ Challenge: Find total admitted, total refused & avg satisfaction (rounded). #SQL #DataAnalytics #Day5

DhanapuneGagan's tweet image. ๐Ÿš€ Day 5 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on aggregates: COUNT, SUM, AVG, MIN, MAX ๐Ÿ“Š
Great for totals, averages &amp;amp; minโ€“max insights.

๐ŸŽฏ Challenge:
Find total admitted, total refused &amp;amp; avg satisfaction (rounded).
#SQL #DataAnalytics #Day5
DhanapuneGagan's tweet image. ๐Ÿš€ Day 5 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on aggregates: COUNT, SUM, AVG, MIN, MAX ๐Ÿ“Š
Great for totals, averages &amp;amp; minโ€“max insights.

๐ŸŽฏ Challenge:
Find total admitted, total refused &amp;amp; avg satisfaction (rounded).
#SQL #DataAnalytics #Day5

๐Ÿš€ Day 6 | #21DaysOfSQL by @IndianDataClub x @DPDzero Explored GROUP BY to summarize data by category ๐Ÿ“Š Great for counts, averages & service-level insights. ๐ŸŽฏ Challenge: For each service โ†’ total admitted, refused & admission rate (sorted DESC). #SQL #DataAnalytics #Day6

DhanapuneGagan's tweet image. ๐Ÿš€ Day 6 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored GROUP BY to summarize data by category ๐Ÿ“Š
Great for counts, averages &amp;amp; service-level insights.

๐ŸŽฏ Challenge:
For each service โ†’ total admitted, refused &amp;amp; admission rate (sorted DESC).
#SQL #DataAnalytics #Day6
DhanapuneGagan's tweet image. ๐Ÿš€ Day 6 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored GROUP BY to summarize data by category ๐Ÿ“Š
Great for counts, averages &amp;amp; service-level insights.

๐ŸŽฏ Challenge:
For each service โ†’ total admitted, refused &amp;amp; admission rate (sorted DESC).
#SQL #DataAnalytics #Day6

Day 1 โ€“ IDC 21 Days of SQL with #DPDzero Set up hospital DB + explored data โœ… First query ๐Ÿ‘‡ SELECT DISTINCT service FROM hospital.services_weekly; Strong foundations ๐Ÿ’ช On to Day 2 ๐Ÿš€ #21DaysOfSQL #IDCChallenge #SQLLearning #Day1 #MySQLJourney #SQLWithIDC


Day 3 of #21daysofsql Learnt 3rd section basics grouping


From tomorrow (-1 )day ->enrolled a sql course on udemy #21daysofsql


Day 7 of #21daysofsql Completed Unions and subqueries today


Day 2 of #21daysofsql Completed basics filtering section today


Day 8 of #21daysofsql In 8th section solved 5 questions easy and moderate level (16:01:2024)


Day 9 of #21daysofsql Solved 2 questions One was moderate and second was difficult level (2024:01:17)


Started little late Day 1 of #21daysofsql Completed a first section from the course (getting started with sql)


๐Ÿš€ Day 12 | #21DaysOfSQL by @IndianDataClub x @DPDzero Focused on handling NULL values ๐Ÿงฉ Learned IS NULL, IS NOT NULL, and COALESCE to clean & manage missing data. ๐ŸŽฏ Challenge: Compare weeks with vs without events โ†’ avg satisfaction & staff morale #SQL #DataAnalytics #Day12

DhanapuneGagan's tweet image. ๐Ÿš€ Day 12 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on handling NULL values ๐Ÿงฉ
Learned IS NULL, IS NOT NULL, and COALESCE to clean &amp;amp; manage missing data.
๐ŸŽฏ Challenge:
Compare weeks with vs without events โ†’ avg satisfaction &amp;amp; staff morale
#SQL #DataAnalytics #Day12
DhanapuneGagan's tweet image. ๐Ÿš€ Day 12 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on handling NULL values ๐Ÿงฉ
Learned IS NULL, IS NOT NULL, and COALESCE to clean &amp;amp; manage missing data.
๐ŸŽฏ Challenge:
Compare weeks with vs without events โ†’ avg satisfaction &amp;amp; staff morale
#SQL #DataAnalytics #Day12

๐Ÿš€ Day 10 | #21DaysOfSQL by @IndianDataClub x @DPDzero Explored CASE statements for conditional logic Perfect for categorizing data & creating dynamic columns! ๐ŸŽฏChallenge: Build a service report with avg satisfaction โ†’ tag as Excellent, Good, Fair, or Needs Improvement #Data

DhanapuneGagan's tweet image. ๐Ÿš€ Day 10 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored CASE statements for conditional logic Perfect for categorizing data &amp;amp; creating dynamic columns!
๐ŸŽฏChallenge:
Build a service report with avg satisfaction โ†’ tag as Excellent, Good, Fair, or Needs Improvement
#Data
DhanapuneGagan's tweet image. ๐Ÿš€ Day 10 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored CASE statements for conditional logic Perfect for categorizing data &amp;amp; creating dynamic columns!
๐ŸŽฏChallenge:
Build a service report with avg satisfaction โ†’ tag as Excellent, Good, Fair, or Needs Improvement
#Data

๐Ÿš€ Day 9 | #21DaysOfSQL by @IndianDataClub x @DPDzero Explored date functions: extraction, date math & filtering Useful for length-of-stay, month/year grouping, & timelines. ๐ŸŽฏ Challenge: Avg stay (days) per service โ†’ show only >7 days + patient count (DESC). #SQL #Data #day9

DhanapuneGagan's tweet image. ๐Ÿš€ Day 9 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored date functions: extraction, date math &amp;amp; filtering 
Useful for length-of-stay, month/year grouping, &amp;amp; timelines.
๐ŸŽฏ Challenge:
Avg stay (days) per service โ†’ show only &amp;gt;7 days + patient count (DESC).
#SQL #Data #day9
DhanapuneGagan's tweet image. ๐Ÿš€ Day 9 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored date functions: extraction, date math &amp;amp; filtering 
Useful for length-of-stay, month/year grouping, &amp;amp; timelines.
๐ŸŽฏ Challenge:
Avg stay (days) per service โ†’ show only &amp;gt;7 days + patient count (DESC).
#SQL #Data #day9

7-Day SQL Learning Streak! Proud to stay consistent in the #21DaysOfSQL challenge by @IndianDataClub x @DPDzero ๐Ÿ”ฅ Every single day is helping me sharpen my data mindset and SQL fundamentals. On to Day 8 ๐Ÿš€ #SQLWithIDC #DataAnalytics #LearningJourney #Consistency

DhanapuneGagan's tweet image. 7-Day SQL Learning Streak!
Proud to stay consistent in the #21DaysOfSQL challenge by @IndianDataClub x @DPDzero ๐Ÿ”ฅ
Every single day is helping me sharpen my data mindset and SQL fundamentals.
On to Day 8 ๐Ÿš€
#SQLWithIDC #DataAnalytics #LearningJourney #Consistency

๐Ÿš€ Day 8 | #21DaysOfSQL by @IndianDataClub x @DPDzero Worked with string functions: UPPER, LOWER, LENGTH, CONCAT, SUBSTRING โœจ Great for cleaning + formatting text data. ๐ŸŽฏ Challenge: Build patient summary (name formatting, age group, length > 10). #SQL #DataAnalytics #Day8

DhanapuneGagan's tweet image. ๐Ÿš€ Day 8 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Worked with string functions: UPPER, LOWER, LENGTH, CONCAT, SUBSTRING โœจ
Great for cleaning + formatting text data.

๐ŸŽฏ Challenge:
Build patient summary (name formatting, age group, length &amp;gt; 10).
#SQL #DataAnalytics #Day8
DhanapuneGagan's tweet image. ๐Ÿš€ Day 8 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Worked with string functions: UPPER, LOWER, LENGTH, CONCAT, SUBSTRING โœจ
Great for cleaning + formatting text data.

๐ŸŽฏ Challenge:
Build patient summary (name formatting, age group, length &amp;gt; 10).
#SQL #DataAnalytics #Day8

๐Ÿš€ Day 7 | #21DaysOfSQL by @IndianDataClub x @DPDzero Covered HAVING โ€” used to filter results after GROUP BY ๐Ÿ” Perfect for conditions on aggregates like COUNT & AVG. ๐ŸŽฏ Challenge: Find services with >100 refusals & avg satisfaction < 80. #SQL #DataAnalytics #Day7

DhanapuneGagan's tweet image. ๐Ÿš€ Day 7 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Covered HAVING โ€” used to filter results after GROUP BY ๐Ÿ”
Perfect for conditions on aggregates like COUNT &amp;amp; AVG.

๐ŸŽฏ Challenge:
Find services with &amp;gt;100 refusals &amp;amp; avg satisfaction &amp;lt; 80.
#SQL #DataAnalytics #Day7
DhanapuneGagan's tweet image. ๐Ÿš€ Day 7 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Covered HAVING โ€” used to filter results after GROUP BY ๐Ÿ”
Perfect for conditions on aggregates like COUNT &amp;amp; AVG.

๐ŸŽฏ Challenge:
Find services with &amp;gt;100 refusals &amp;amp; avg satisfaction &amp;lt; 80.
#SQL #DataAnalytics #Day7

๐Ÿš€ Day 6 | #21DaysOfSQL by @IndianDataClub x @DPDzero Explored GROUP BY to summarize data by category ๐Ÿ“Š Great for counts, averages & service-level insights. ๐ŸŽฏ Challenge: For each service โ†’ total admitted, refused & admission rate (sorted DESC). #SQL #DataAnalytics #Day6

DhanapuneGagan's tweet image. ๐Ÿš€ Day 6 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored GROUP BY to summarize data by category ๐Ÿ“Š
Great for counts, averages &amp;amp; service-level insights.

๐ŸŽฏ Challenge:
For each service โ†’ total admitted, refused &amp;amp; admission rate (sorted DESC).
#SQL #DataAnalytics #Day6
DhanapuneGagan's tweet image. ๐Ÿš€ Day 6 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored GROUP BY to summarize data by category ๐Ÿ“Š
Great for counts, averages &amp;amp; service-level insights.

๐ŸŽฏ Challenge:
For each service โ†’ total admitted, refused &amp;amp; admission rate (sorted DESC).
#SQL #DataAnalytics #Day6

๐Ÿš€ Day 5 | #21DaysOfSQL by @IndianDataClub x @DPDzero Focused on aggregates: COUNT, SUM, AVG, MIN, MAX ๐Ÿ“Š Great for totals, averages & minโ€“max insights. ๐ŸŽฏ Challenge: Find total admitted, total refused & avg satisfaction (rounded). #SQL #DataAnalytics #Day5

DhanapuneGagan's tweet image. ๐Ÿš€ Day 5 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on aggregates: COUNT, SUM, AVG, MIN, MAX ๐Ÿ“Š
Great for totals, averages &amp;amp; minโ€“max insights.

๐ŸŽฏ Challenge:
Find total admitted, total refused &amp;amp; avg satisfaction (rounded).
#SQL #DataAnalytics #Day5
DhanapuneGagan's tweet image. ๐Ÿš€ Day 5 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on aggregates: COUNT, SUM, AVG, MIN, MAX ๐Ÿ“Š
Great for totals, averages &amp;amp; minโ€“max insights.

๐ŸŽฏ Challenge:
Find total admitted, total refused &amp;amp; avg satisfaction (rounded).
#SQL #DataAnalytics #Day5

๐Ÿš€ Day 4 | #21DaysOfSQL by @IndianDataClub x @DPDzero Explored LIMIT + OFFSET for pagination ๐Ÿ“„ ๐Ÿ”น LIMIT โ†’ restrict rows ๐Ÿ”น OFFSET โ†’ skip rows ๐Ÿ”น Better with ORDER BY ๐ŸŽฏ Challenge: Get 3rdโ€“7th highest satisfaction scores (patient_id, name, service, satisfaction). #SQL #Day4

DhanapuneGagan's tweet image. ๐Ÿš€ Day 4 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored LIMIT + OFFSET for pagination ๐Ÿ“„
๐Ÿ”น LIMIT โ†’ restrict rows
๐Ÿ”น OFFSET โ†’ skip rows
๐Ÿ”น Better with ORDER BY

๐ŸŽฏ Challenge:
Get 3rdโ€“7th highest satisfaction scores (patient_id, name, service, satisfaction).
#SQL #Day4
DhanapuneGagan's tweet image. ๐Ÿš€ Day 4 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored LIMIT + OFFSET for pagination ๐Ÿ“„
๐Ÿ”น LIMIT โ†’ restrict rows
๐Ÿ”น OFFSET โ†’ skip rows
๐Ÿ”น Better with ORDER BY

๐ŸŽฏ Challenge:
Get 3rdโ€“7th highest satisfaction scores (patient_id, name, service, satisfaction).
#SQL #Day4

๐Ÿš€ Day 3 | #21DaysOfSQL by @IndianDataClub x @DPDzero Focused on ORDER BY for sorting ๐Ÿ“Š ๐Ÿ”น Sort by age (DESC) ๐Ÿ”น Weekly data by week ASC + requests DESC ๐Ÿ”น Staff sorted Aโ†’Z ๐ŸŽฏ Challenge: Top 5 weeks with highest patient refusals ๐Ÿ” #SQL #DataAnalytics #Day3

DhanapuneGagan's tweet image. ๐Ÿš€ Day 3 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on ORDER BY for sorting ๐Ÿ“Š
๐Ÿ”น Sort by age (DESC)
๐Ÿ”น Weekly data by week ASC + requests DESC
๐Ÿ”น Staff sorted Aโ†’Z

๐ŸŽฏ Challenge: Top 5 weeks with highest patient refusals ๐Ÿ”
#SQL #DataAnalytics #Day3
DhanapuneGagan's tweet image. ๐Ÿš€ Day 3 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on ORDER BY for sorting ๐Ÿ“Š
๐Ÿ”น Sort by age (DESC)
๐Ÿ”น Weekly data by week ASC + requests DESC
๐Ÿ”น Staff sorted Aโ†’Z

๐ŸŽฏ Challenge: Top 5 weeks with highest patient refusals ๐Ÿ”
#SQL #DataAnalytics #Day3

๐Ÿš€ Day 2 | #21DaysOfSQL by @IndianDataClub x @DPDzero Focused on mastering the WHERE clause ๐Ÿ” ๐Ÿง  Learned filtering with =, !=, AND, OR, IN, BETWEEN, LIKE ๐ŸŽฏChallenge: Find patients in Surgery with satisfaction < 70 ๐Ÿฅ ๐Ÿ”— Repo: github.com/gagan8605/IDC_โ€ฆ #SQL #DataAnalytics #Day2

DhanapuneGagan's tweet image. ๐Ÿš€ Day 2 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on mastering the WHERE clause ๐Ÿ”
๐Ÿง  Learned filtering with =, !=, AND, OR, IN, BETWEEN, LIKE
๐ŸŽฏChallenge: Find patients in Surgery with satisfaction &amp;lt; 70 ๐Ÿฅ
๐Ÿ”— Repo: github.com/gagan8605/IDC_โ€ฆ
#SQL #DataAnalytics #Day2
DhanapuneGagan's tweet image. ๐Ÿš€ Day 2 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on mastering the WHERE clause ๐Ÿ”
๐Ÿง  Learned filtering with =, !=, AND, OR, IN, BETWEEN, LIKE
๐ŸŽฏChallenge: Find patients in Surgery with satisfaction &amp;lt; 70 ๐Ÿฅ
๐Ÿ”— Repo: github.com/gagan8605/IDC_โ€ฆ
#SQL #DataAnalytics #Day2

๐Ÿš€ Day 1 | #21DaysOfSQL by @IndianDataClub x @DPDzero Learned the power of SELECT โ€” the first step in talking to data! ๐Ÿง  SELECT * | Columns | LIMIT | DISTINCT ๐ŸŽฏ Challenge: List unique hospital services ๐Ÿฅ ๐Ÿ“Š Repo Link | ๐Ÿ”— github.com/gagan8605/IDC_โ€ฆ #SQL #DataAnalytics #Day1

DhanapuneGagan's tweet image. ๐Ÿš€ Day 1 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Learned the power of SELECT โ€” the first step in talking to data!
๐Ÿง  SELECT * | Columns | LIMIT | DISTINCT

๐ŸŽฏ Challenge: List unique hospital services ๐Ÿฅ
๐Ÿ“Š  Repo Link  | ๐Ÿ”— github.com/gagan8605/IDC_โ€ฆ
#SQL #DataAnalytics #Day1
DhanapuneGagan's tweet image. ๐Ÿš€ Day 1 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Learned the power of SELECT โ€” the first step in talking to data!
๐Ÿง  SELECT * | Columns | LIMIT | DISTINCT

๐ŸŽฏ Challenge: List unique hospital services ๐Ÿฅ
๐Ÿ“Š  Repo Link  | ๐Ÿ”— github.com/gagan8605/IDC_โ€ฆ
#SQL #DataAnalytics #Day1

Day 9 of #21daysofsql Solved 2 questions One was moderate and second was difficult level (2024:01:17)


Day 8 of #21daysofsql In 8th section solved 5 questions easy and moderate level (16:01:2024)


No results for "#21daysofsql"

๐Ÿš€ Day 10 | #21DaysOfSQL by @IndianDataClub x @DPDzero Explored CASE statements for conditional logic Perfect for categorizing data & creating dynamic columns! ๐ŸŽฏChallenge: Build a service report with avg satisfaction โ†’ tag as Excellent, Good, Fair, or Needs Improvement #Data

DhanapuneGagan's tweet image. ๐Ÿš€ Day 10 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored CASE statements for conditional logic Perfect for categorizing data &amp;amp; creating dynamic columns!
๐ŸŽฏChallenge:
Build a service report with avg satisfaction โ†’ tag as Excellent, Good, Fair, or Needs Improvement
#Data
DhanapuneGagan's tweet image. ๐Ÿš€ Day 10 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored CASE statements for conditional logic Perfect for categorizing data &amp;amp; creating dynamic columns!
๐ŸŽฏChallenge:
Build a service report with avg satisfaction โ†’ tag as Excellent, Good, Fair, or Needs Improvement
#Data

๐Ÿš€ Day 2 | #21DaysOfSQL by @IndianDataClub x @DPDzero Focused on mastering the WHERE clause ๐Ÿ” ๐Ÿง  Learned filtering with =, !=, AND, OR, IN, BETWEEN, LIKE ๐ŸŽฏChallenge: Find patients in Surgery with satisfaction < 70 ๐Ÿฅ ๐Ÿ”— Repo: github.com/gagan8605/IDC_โ€ฆ #SQL #DataAnalytics #Day2

DhanapuneGagan's tweet image. ๐Ÿš€ Day 2 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on mastering the WHERE clause ๐Ÿ”
๐Ÿง  Learned filtering with =, !=, AND, OR, IN, BETWEEN, LIKE
๐ŸŽฏChallenge: Find patients in Surgery with satisfaction &amp;lt; 70 ๐Ÿฅ
๐Ÿ”— Repo: github.com/gagan8605/IDC_โ€ฆ
#SQL #DataAnalytics #Day2
DhanapuneGagan's tweet image. ๐Ÿš€ Day 2 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on mastering the WHERE clause ๐Ÿ”
๐Ÿง  Learned filtering with =, !=, AND, OR, IN, BETWEEN, LIKE
๐ŸŽฏChallenge: Find patients in Surgery with satisfaction &amp;lt; 70 ๐Ÿฅ
๐Ÿ”— Repo: github.com/gagan8605/IDC_โ€ฆ
#SQL #DataAnalytics #Day2

7-Day SQL Learning Streak! Proud to stay consistent in the #21DaysOfSQL challenge by @IndianDataClub x @DPDzero ๐Ÿ”ฅ Every single day is helping me sharpen my data mindset and SQL fundamentals. On to Day 8 ๐Ÿš€ #SQLWithIDC #DataAnalytics #LearningJourney #Consistency

DhanapuneGagan's tweet image. 7-Day SQL Learning Streak!
Proud to stay consistent in the #21DaysOfSQL challenge by @IndianDataClub x @DPDzero ๐Ÿ”ฅ
Every single day is helping me sharpen my data mindset and SQL fundamentals.
On to Day 8 ๐Ÿš€
#SQLWithIDC #DataAnalytics #LearningJourney #Consistency

๐Ÿš€ Day 7 | #21DaysOfSQL by @IndianDataClub x @DPDzero Covered HAVING โ€” used to filter results after GROUP BY ๐Ÿ” Perfect for conditions on aggregates like COUNT & AVG. ๐ŸŽฏ Challenge: Find services with >100 refusals & avg satisfaction < 80. #SQL #DataAnalytics #Day7

DhanapuneGagan's tweet image. ๐Ÿš€ Day 7 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Covered HAVING โ€” used to filter results after GROUP BY ๐Ÿ”
Perfect for conditions on aggregates like COUNT &amp;amp; AVG.

๐ŸŽฏ Challenge:
Find services with &amp;gt;100 refusals &amp;amp; avg satisfaction &amp;lt; 80.
#SQL #DataAnalytics #Day7
DhanapuneGagan's tweet image. ๐Ÿš€ Day 7 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Covered HAVING โ€” used to filter results after GROUP BY ๐Ÿ”
Perfect for conditions on aggregates like COUNT &amp;amp; AVG.

๐ŸŽฏ Challenge:
Find services with &amp;gt;100 refusals &amp;amp; avg satisfaction &amp;lt; 80.
#SQL #DataAnalytics #Day7

๐Ÿš€ Day 12 | #21DaysOfSQL by @IndianDataClub x @DPDzero Focused on handling NULL values ๐Ÿงฉ Learned IS NULL, IS NOT NULL, and COALESCE to clean & manage missing data. ๐ŸŽฏ Challenge: Compare weeks with vs without events โ†’ avg satisfaction & staff morale #SQL #DataAnalytics #Day12

DhanapuneGagan's tweet image. ๐Ÿš€ Day 12 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on handling NULL values ๐Ÿงฉ
Learned IS NULL, IS NOT NULL, and COALESCE to clean &amp;amp; manage missing data.
๐ŸŽฏ Challenge:
Compare weeks with vs without events โ†’ avg satisfaction &amp;amp; staff morale
#SQL #DataAnalytics #Day12
DhanapuneGagan's tweet image. ๐Ÿš€ Day 12 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on handling NULL values ๐Ÿงฉ
Learned IS NULL, IS NOT NULL, and COALESCE to clean &amp;amp; manage missing data.
๐ŸŽฏ Challenge:
Compare weeks with vs without events โ†’ avg satisfaction &amp;amp; staff morale
#SQL #DataAnalytics #Day12

๐Ÿš€ Day 8 | #21DaysOfSQL by @IndianDataClub x @DPDzero Worked with string functions: UPPER, LOWER, LENGTH, CONCAT, SUBSTRING โœจ Great for cleaning + formatting text data. ๐ŸŽฏ Challenge: Build patient summary (name formatting, age group, length > 10). #SQL #DataAnalytics #Day8

DhanapuneGagan's tweet image. ๐Ÿš€ Day 8 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Worked with string functions: UPPER, LOWER, LENGTH, CONCAT, SUBSTRING โœจ
Great for cleaning + formatting text data.

๐ŸŽฏ Challenge:
Build patient summary (name formatting, age group, length &amp;gt; 10).
#SQL #DataAnalytics #Day8
DhanapuneGagan's tweet image. ๐Ÿš€ Day 8 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Worked with string functions: UPPER, LOWER, LENGTH, CONCAT, SUBSTRING โœจ
Great for cleaning + formatting text data.

๐ŸŽฏ Challenge:
Build patient summary (name formatting, age group, length &amp;gt; 10).
#SQL #DataAnalytics #Day8

๐Ÿš€ Day 4 | #21DaysOfSQL by @IndianDataClub x @DPDzero Explored LIMIT + OFFSET for pagination ๐Ÿ“„ ๐Ÿ”น LIMIT โ†’ restrict rows ๐Ÿ”น OFFSET โ†’ skip rows ๐Ÿ”น Better with ORDER BY ๐ŸŽฏ Challenge: Get 3rdโ€“7th highest satisfaction scores (patient_id, name, service, satisfaction). #SQL #Day4

DhanapuneGagan's tweet image. ๐Ÿš€ Day 4 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored LIMIT + OFFSET for pagination ๐Ÿ“„
๐Ÿ”น LIMIT โ†’ restrict rows
๐Ÿ”น OFFSET โ†’ skip rows
๐Ÿ”น Better with ORDER BY

๐ŸŽฏ Challenge:
Get 3rdโ€“7th highest satisfaction scores (patient_id, name, service, satisfaction).
#SQL #Day4
DhanapuneGagan's tweet image. ๐Ÿš€ Day 4 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored LIMIT + OFFSET for pagination ๐Ÿ“„
๐Ÿ”น LIMIT โ†’ restrict rows
๐Ÿ”น OFFSET โ†’ skip rows
๐Ÿ”น Better with ORDER BY

๐ŸŽฏ Challenge:
Get 3rdโ€“7th highest satisfaction scores (patient_id, name, service, satisfaction).
#SQL #Day4

๐Ÿš€ Day 1 | #21DaysOfSQL by @IndianDataClub x @DPDzero Learned the power of SELECT โ€” the first step in talking to data! ๐Ÿง  SELECT * | Columns | LIMIT | DISTINCT ๐ŸŽฏ Challenge: List unique hospital services ๐Ÿฅ ๐Ÿ“Š Repo Link | ๐Ÿ”— github.com/gagan8605/IDC_โ€ฆ #SQL #DataAnalytics #Day1

DhanapuneGagan's tweet image. ๐Ÿš€ Day 1 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Learned the power of SELECT โ€” the first step in talking to data!
๐Ÿง  SELECT * | Columns | LIMIT | DISTINCT

๐ŸŽฏ Challenge: List unique hospital services ๐Ÿฅ
๐Ÿ“Š  Repo Link  | ๐Ÿ”— github.com/gagan8605/IDC_โ€ฆ
#SQL #DataAnalytics #Day1
DhanapuneGagan's tweet image. ๐Ÿš€ Day 1 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Learned the power of SELECT โ€” the first step in talking to data!
๐Ÿง  SELECT * | Columns | LIMIT | DISTINCT

๐ŸŽฏ Challenge: List unique hospital services ๐Ÿฅ
๐Ÿ“Š  Repo Link  | ๐Ÿ”— github.com/gagan8605/IDC_โ€ฆ
#SQL #DataAnalytics #Day1

๐Ÿš€ Day 5 | #21DaysOfSQL by @IndianDataClub x @DPDzero Focused on aggregates: COUNT, SUM, AVG, MIN, MAX ๐Ÿ“Š Great for totals, averages & minโ€“max insights. ๐ŸŽฏ Challenge: Find total admitted, total refused & avg satisfaction (rounded). #SQL #DataAnalytics #Day5

DhanapuneGagan's tweet image. ๐Ÿš€ Day 5 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on aggregates: COUNT, SUM, AVG, MIN, MAX ๐Ÿ“Š
Great for totals, averages &amp;amp; minโ€“max insights.

๐ŸŽฏ Challenge:
Find total admitted, total refused &amp;amp; avg satisfaction (rounded).
#SQL #DataAnalytics #Day5
DhanapuneGagan's tweet image. ๐Ÿš€ Day 5 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on aggregates: COUNT, SUM, AVG, MIN, MAX ๐Ÿ“Š
Great for totals, averages &amp;amp; minโ€“max insights.

๐ŸŽฏ Challenge:
Find total admitted, total refused &amp;amp; avg satisfaction (rounded).
#SQL #DataAnalytics #Day5

๐Ÿš€ Day 3 | #21DaysOfSQL by @IndianDataClub x @DPDzero Focused on ORDER BY for sorting ๐Ÿ“Š ๐Ÿ”น Sort by age (DESC) ๐Ÿ”น Weekly data by week ASC + requests DESC ๐Ÿ”น Staff sorted Aโ†’Z ๐ŸŽฏ Challenge: Top 5 weeks with highest patient refusals ๐Ÿ” #SQL #DataAnalytics #Day3

DhanapuneGagan's tweet image. ๐Ÿš€ Day 3 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on ORDER BY for sorting ๐Ÿ“Š
๐Ÿ”น Sort by age (DESC)
๐Ÿ”น Weekly data by week ASC + requests DESC
๐Ÿ”น Staff sorted Aโ†’Z

๐ŸŽฏ Challenge: Top 5 weeks with highest patient refusals ๐Ÿ”
#SQL #DataAnalytics #Day3
DhanapuneGagan's tweet image. ๐Ÿš€ Day 3 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Focused on ORDER BY for sorting ๐Ÿ“Š
๐Ÿ”น Sort by age (DESC)
๐Ÿ”น Weekly data by week ASC + requests DESC
๐Ÿ”น Staff sorted Aโ†’Z

๐ŸŽฏ Challenge: Top 5 weeks with highest patient refusals ๐Ÿ”
#SQL #DataAnalytics #Day3

๐Ÿš€ Day 6 | #21DaysOfSQL by @IndianDataClub x @DPDzero Explored GROUP BY to summarize data by category ๐Ÿ“Š Great for counts, averages & service-level insights. ๐ŸŽฏ Challenge: For each service โ†’ total admitted, refused & admission rate (sorted DESC). #SQL #DataAnalytics #Day6

DhanapuneGagan's tweet image. ๐Ÿš€ Day 6 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored GROUP BY to summarize data by category ๐Ÿ“Š
Great for counts, averages &amp;amp; service-level insights.

๐ŸŽฏ Challenge:
For each service โ†’ total admitted, refused &amp;amp; admission rate (sorted DESC).
#SQL #DataAnalytics #Day6
DhanapuneGagan's tweet image. ๐Ÿš€ Day 6 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored GROUP BY to summarize data by category ๐Ÿ“Š
Great for counts, averages &amp;amp; service-level insights.

๐ŸŽฏ Challenge:
For each service โ†’ total admitted, refused &amp;amp; admission rate (sorted DESC).
#SQL #DataAnalytics #Day6

๐Ÿš€ Day 9 | #21DaysOfSQL by @IndianDataClub x @DPDzero Explored date functions: extraction, date math & filtering Useful for length-of-stay, month/year grouping, & timelines. ๐ŸŽฏ Challenge: Avg stay (days) per service โ†’ show only >7 days + patient count (DESC). #SQL #Data #day9

DhanapuneGagan's tweet image. ๐Ÿš€ Day 9 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored date functions: extraction, date math &amp;amp; filtering 
Useful for length-of-stay, month/year grouping, &amp;amp; timelines.
๐ŸŽฏ Challenge:
Avg stay (days) per service โ†’ show only &amp;gt;7 days + patient count (DESC).
#SQL #Data #day9
DhanapuneGagan's tweet image. ๐Ÿš€ Day 9 | #21DaysOfSQL by @IndianDataClub x @DPDzero
Explored date functions: extraction, date math &amp;amp; filtering 
Useful for length-of-stay, month/year grouping, &amp;amp; timelines.
๐ŸŽฏ Challenge:
Avg stay (days) per service โ†’ show only &amp;gt;7 days + patient count (DESC).
#SQL #Data #day9

Loading...

Something went wrong.


Something went wrong.


United States Trends