#sqlwithidc 검색 결과
Day 10/21 days sql challenge #SQLwithIDC SELECT SERVICE,COUNT(*) AS total_patients_admitted,AVG(SATISFACTION) AS avg_satisfactionCASE AVG(SATISFACTION) >= 85 'Excellent' AVG(SATISFACTION) >= 75 'Good' AVG(SATISFACTION) >= 65 'Fair' ELSE 'Needs Improvement'END AS pc FROM patients
𝗗𝗮𝘆 𝟭𝟴 #SQLWithIDC🚀 Today I explored UNION & UNION ALL — combining multiple queries into one dataset! ✨ 💡Quick Tips: • UNION = no duplicates✅ • UNION ALL = keeps all✅ • Match columns & types • Order only after final result Combine smartly, analyze faster! 🙌
day -18/21 Days SQl challenge #SQLwithIDC Getting back to the Grind of SQL with @indiandataclub and @dpdzero
Completed 7 days of the 21 Days SQL Challenge. Staying consistent has helped me strengthen my foundation and approach problems with clarity. Looking forward to learning more and progressing further in the upcoming days. Tagging @dpdzero and @indiandataclub #SQLWithIDC
Day 18 #SQLWithIDC 🔶UNION removes duplicates, slower but unique results. 🔷UNION ALL keeps all rows, faster performance. 🔶Same columns + compatible types. Use ORDER BY last. Pro tip: Use UNION ALL when duplicates aren't an issue! @indiandataclub @dpdzero
Day 10 of #SQLWithIDC 🚀— CASE statements 💡 Key takeaways: • Use CASE to categorize or create conditional metrics • Always include ELSE (avoid NULLs) • Works in SELECT, ORDER BY, and GROUP BY • First match wins — order matters!
Day 14/21 dayssqlchallenge #SQLwithIDC Excited to share that as part of the #SQLwithIDC challenge, I completed over 400 lines of SQL within just 14 days. Grateful to be part of this learning journey! @indiandataclub @dpdzero
𝗗𝗮𝘆 12 #21DaysSQLChallenge 🚀 Handling NULLs & comparing categories ✅ IS NULL / IS NOT NULL ✅ COALESCE for fallback ✅ COUNT(*) vs COUNT(column) ✅ CTE + CASE for clean summaries ⚠️ Don’t treat NULL as a value Stepwise queries = clear & scalable SQL! 🙌 #SQLWithIDC
Day 21 #SQLWithIDC CTEs transform tangled logic into elegant, reusable steps, turning complexity into insight. From simple stats to multi-step analysis, CTEs are a game-changer for query organization. @indiandataclub @dpdzero
Day 20 #SQLWithIDC Window functions like SUM() OVER and AVG() OVER unlock running totals, moving averages, and cumulative stats no GROUP BY needed. Track trends, smooth data, and compare values in a single query. Power up your analytics! @indiandataclub @dpdzero
Day 15 #SQLWithIDC🚀 Today’s focus: joining 3+ tables — the real power move in SQL! 💡 Key Learnings: 🔗 Join tables left → right 🎯 Mix INNER + LEFT wisely 🧩 Use DISTINCT / GROUP BY to remove duplicates ⚠️ Avoid missing join conditions & WHERE filters that break LEFT JOINs
Day 15/21 SQL Challenge I have some commitments tomorrow, so I’m submitting the challenge a day early. I don’t want to break my streak — losing it would hurt more than a breakup! 😄 #SQLwithIDC with @indiandataclub and @dpdzero
Day 15 #SQLWithIDC I explored the art of joining tables, untangling complex relationships,and turning raw data into meaningful insights.This journey isn’t just about queriesit’s about seeing patterns, solving problems, and mastering the language of data @indiandataclub @dpdzero
🗓️ Day 21 of #21DaysSQLChallenge by @indiandataclub! Today's topic: CTEs🎯 Using the WITH clause, you can create a temporary named result set & build your query step by step! Key takeaways💡 • Break complex queries into simple steps • Reuse logic • Easy to debug #SQLWithIDC
𝗗𝗮𝘆 𝟭𝟳 𝗼𝗳 #SQLWithIDC 🚀 Today’s focus: Subqueries in SELECT & FROM 💡 • SELECT → calculate per row • FROM → organize complex logic • Always alias derived tables • Correlated subqueries = slower ⚠ 🎯Takeaway: Subqueries make SQL cleaner and smarter! 🔥
Day 1/21 ✅ — #SQLWithIDC Starting my SQL journey with SELECT, DISTINCT & FROM Learning how to ask data questions with SQL. Query: SELECT DISTINCT service_name FROM services_weekly; #SQL #DataAnalytics #21DaysOfSQLChallenge
Day 9 of #21DaysSQLChallenge 🚀 Today’s focus: Date Functions ⏰ 💡 Key takeaways: • DATEDIFF() to calculate durations • YEAR(), MONTH(), DAY() to extract parts • Use ISO format (YYYY-MM-DD) for consistency • Avoid functions in WHERE on large tables #SQLWithIDC
Day 10 ✅ of #21DaysSQLChallenge by @IndianDataClub x @DPDzero Topic: CASE WHEN & Conditional Logic Today I learned to make SQL smarter — adding if-else logic inside queries 💡 Categorized satisfaction, grouped patients, & built performance reports with CASE! #SQLWithIDC
Sharing my 21 Days SQL Challenge Certificate! 🙌 Thanks @IndianDataClub & @dpdzero for the learning journey. #SQLWithIDC #SQL #Analytics
#SQLWithIDC #portfolioshowcase #portfolio #presentation #businesspresentation #storytelling #DataAnalytics #21DayChallenge #learnsql @indiandataclub @dpdzero
I did it! 21 Days of SQL. 21 Days of learning. 21 Days of consistency. Thanks @DPDzero and @IndianDataClub for making the journey so engaging. #SQLWithIDC #SQL #TechCommunity
The perfect end to the 21-day journey. SQL isn’t just about queries — it’s problem-solving, storytelling & logic. Proud to have completed this challenge! 🚀 @indiandataclub @dpdzero #SQLWithIDC #SQLMystery #21DaysSQLChallenge #DataAnalytics
🕵️♂️ Capstone Completed! | SQL Murder Mystery- “Who Killed the CEO?” Wrapped up the 21-Day SQL Challenge by @indiandataclub with a final investigation project where I solved a murder case using SQL, not fingerprints. @dpdzero #21DaysSQLChallenge #SQLWithIDC
🌟 21 Days. 21 Chances to Grow. I just earned my 21-Day SQL Challenge Badge with #SQLWithIDC! 🚀 It’s not just a badge — it’s proof of showing up every day, learning, practicing, and building consistency. 💫 💭 Lesson: Progress > Perfection. Keep going, every day counts!
🕵️♀️ SQL Murder Mystery — Solved! ➡️All clues point to David Kumar - the only one in the CEO office during the crime, a false alibi, a suspicious call at 8:55 PM, and matching fingerprints. Sponsored by @DPDzero | Organized by @IndianDataClub #SQLWithIDC #21DaysSQLChallenge
Capstone project done!🕵️♀️ Final task of the #21DaysSQLChallenge: solve a CEO murder case using only SQL. From keycard logs to alibis to suspicious calls, every clue came from a query. Huge thanks to @IndianDataClub & @DPDzero for an amazing journey. #SQLWithIDC #SQL
CapStone:I uncovered the killer behind TechNova Inc.’s CEO murder. 🔍 Killer Identified: David Kumar 📊 Skills Used: JOINs, time filtering, CTEs, pattern tracing SQL isn’t just queries — it’s detective work. Linkedin:linkedin.com/feed/update/ur… #SQLWithIDC @indiandataclub @dpdzero
✅Day 21 of #SQLWithIDC Challenge Complted! sponsored by @dpdzero & organized by @indiandataclub. 💡Today’s concept: CTEs — the best way to simplify complex SQL into clean, readable steps. 🎯 Challenge: Build a hospital performance dashboard using 3 CTEs + final performance.
🗓️ Day 21 of #21DaysSQLChallenge by @indiandataclub! Today's topic: CTEs🎯 Using the WITH clause, you can create a temporary named result set & build your query step by step! Key takeaways💡 • Break complex queries into simple steps • Reuse logic • Easy to debug #SQLWithIDC
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 21. Final day of the 21 Days of SQL Challenge. I built a dashboard with CTEs combining service metrics, staff metrics, and patient demographics, then computed a weighted performance score. @indiandataclub @dpdzero #SQL #SQLWithIDC
Day 21 #SQLWithIDC CTEs transform tangled logic into elegant, reusable steps, turning complexity into insight. From simple stats to multi-step analysis, CTEs are a game-changer for query organization. @indiandataclub @dpdzero
𝐃𝐚𝐲 21/21 – 𝐒𝐐𝐋 𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞🚀 🔸Learned CTEs today — clean, readable queries with step-by-step logic. 🔸Perfect for breaking down complex reports easily. 🔥 🔸CTEs > nested subqueries any day! ⚡ #SQLWithIDC #CTE #IndianDataClub #DPDzero
✅ Completed Day 20 - Window Functions Sponsored by @dpdzero & Organized by @indiandataclub. - Worked with running totals, moving averages, and trend analysis using SUM() OVER & AVG() OVER. - Analyzed weeks 10–20 for admissions + satisfaction trends. 🔍 #SQLWithIDC
Today’s Learning : SQL window functions. SUM() OVER for running totals, AVG() OVER for moving averages, and ROWS BETWEEN to control the window. Helps analyze trends without losing rows. #sqlwithidc #sqllearning #indiandataclub
Something went wrong.
Something went wrong.
United States Trends
- 1. #doordashfairy 1,135 posts
- 2. Vanity Fair 65.4K posts
- 3. Susie Wiles 130K posts
- 4. Mustapha Kharbouch 27.5K posts
- 5. Mick Foley 34.1K posts
- 6. Olive Garden 1,264 posts
- 7. Larian 11.7K posts
- 8. Mary and Joseph 1,818 posts
- 9. Brookline 10.2K posts
- 10. Snowslingers N/A
- 11. Christensen 5,291 posts
- 12. Michelea Ponce 35.1K posts
- 13. Penguins Christmas Party Time N/A
- 14. $TSLA 50.3K posts
- 15. Firefox 5,648 posts
- 16. Cardiff 28.2K posts
- 17. Brand New Day 10.1K posts
- 18. Kay Flock 1,312 posts
- 19. Carville 3,573 posts
- 20. Gittens 7,807 posts