#sqlwithidc risultati di ricerca
𝗗𝗮𝘆 𝟭𝟴 #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 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
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 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 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 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
Sharing my 21 Days SQL Challenge Certificate! 🙌 Thanks @IndianDataClub & @dpdzero for the learning journey. #SQLWithIDC #SQL #Analytics
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 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/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
𝐃𝐚𝐲 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
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
𝗗𝗮𝘆 𝟭𝟳 𝗼𝗳 #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! 🔥
Something went wrong.
Something went wrong.
United States Trends
- 1. Colts 48.8K posts
- 2. Rivers 61.2K posts
- 3. gaten 5,985 posts
- 4. Brock Purdy 17.8K posts
- 5. Niners 8,887 posts
- 6. #FTTB 6,829 posts
- 7. Adam the Woo 2,981 posts
- 8. Kittle 8,963 posts
- 9. Ballard 3,027 posts
- 10. DEE WINTERS 2,520 posts
- 11. #WWERaw 23.2K posts
- 12. Tonges 1,411 posts
- 13. #SFvsIND 2,266 posts
- 14. #ForTheShoe 2,498 posts
- 15. Dray 1,292 posts
- 16. Alec Pierce 3,639 posts
- 17. Jennings 15.8K posts
- 18. Greenland 78.2K posts
- 19. #LADS2ndAnniversary 7,343 posts
- 20. Ivey 1,138 posts