Search results for #50DaysofSQL
Day 17 of #SQL 🎯 Today I calculated the percentage of users that registered for each contest. Then sorted by: ✅ Highest percentage ✅ Lowest contest ID (tie-breaker) 📊 Small ordering logic, big clarity. #DataScience #SQLTips #50DaysOfSQL #ALXAfrica #LearningInPublic
Day R4 of SQL Revision Sprint! (Reviewing Days 13–16 of #50DaysOfSQL) • Set operations: UNION, INTERSECT, EXCEPT • Non-Equi Joins • Window Functions: RANK(), ROW_NUMBER() One more revision day to go before jumping back in full swing! #LearnInPublic #SQLChallenge #DataSkills
Day R3 of SQL Revision Sprint! (Reviewing Days 9–12 of #50DaysOfSQL) • Nested Subqueries • Mastered Joins: INNER, LEFT, RIGHT, FULL OUTER • Self-Joins & Cross-DB joins • Revisited Mini-Project 2: Sales & Shipping Insights One JOIN at a time! #SQL #LearnInPublic #DataSkills
Day R2 of SQL Revision Sprint! (Reviewing Days 5–8 of #50DaysOfSQL) • Revisited my 1st mini-project: Invoicing system analysis • Refreshed string/date/numeric functions • Grouped & aggregated data • GROUP BY, HAVING, nested CONCAT #LearnInPublic #DataSkills #DataAnalytics
Restarting my #50DaysOfSQL journey with a 5-day revision sprint! Day R1: • SQL Basics • Filtering with WHERE, IN, LIKE • Sorting + DISTINCT • Practice queries to warm up 🔥 Back in query mode after a 4-month break 😅 Let’s go! 🚀 #LearningInPublic #SQLChallenge #DataSkills
Day 20 of #50DaysOfSQL ✅ Mastered Recursive Queries for: • Organizational hierarchies 🔗 • Summing numbers ➕ • Directory trees 🗂️ Recursive queries make hierarchical data analysis a breeze! Solved 6 questions on HackerRank today 🚀 #LearningInPublic #SQL #DataSkills
Day 19 of #50DaysOfSQL Explored the magic of 𝗦𝘂𝗯𝗾𝘂𝗲𝗿𝗶𝗲𝘀: • WHERE: Dynamic filtering • FROM: Derived tables • SELECT: Calculated metrics • Correlated Subqueries: Row-by-row comparisons #LearnInPublic #SQL #DataSkills
Day 18 of #50DaysOfSQL After a break, I'm restarting the series! 🚀 Spent today revising everything I’ve covered so far, from basic queries to window functions. Feeling ready to dive back into learning new concepts tomorrow! #SQL #LearnInPublic #DataSkills #SQLChallenge
Day 1 /50 (SQL CHALLENGE) Problem: identify hospital records where patients were admitted and discharged on the same day. SOLUTION: SELECT * FROM admissions WHERE admission_date = discharge_date; #sql #data #sql #50DaysOfSQL #dataJourney
✅ Day 5 of #50DaysOfSQL: Solved a problem where I removed employees with non-unique IDs and replaced them with NULL. 🛠️ Great practice with SQL queries like JOIN, GROUP BY, and HAVING! On to the next challenge! 🚀 #SQL #LeetCode #DataScience #CodingJourney
Day 3/50: Solved "Big Countries" on LeetCode! 🌍✨ 📝 Find countries with: ✅ Population ≥ 25M ✅ Area ≥ 3M km² #50DaysOfSQL #LeetCode #DataSkills #SQL
💻 Day 2/50: LeetCode SQL Challenge Solved 584: Find Customer Referee today! 🎯 ✅ Learned to filter data using WHERE + IS NOT NULL. ✅ Focused on retrieving non-NULL referee_id values. Key takeaway: Precision in filtering makes all the difference! 🚀 #50DaysOfSQL #LeetCode
Day 17 of #50DaysOfSQL ✅ Mastered 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗪𝗶𝗻𝗱𝗼𝘄 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀: • Running Totals 📊 • Percentiles (PERCENT_RANK(), CUME_DIST()) 🏅 • Moving Averages 📈 • First & Last Values 🔍 Solved 1 questions on @hackerrank just keeps getting better! 🚀
Day 16 of #50DaysOfSQL ✅ Revision day! Spent time reviewing everything from basic queries to window functions. Feels great to solidify the foundation before diving deeper. 🚀 #LearningInPublic #SQL #DataSkill
Day 15 of #50DaysOfSQL ✅ Learned the magic of 𝗪𝗶𝗻𝗱𝗼𝘄 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀: • Ranked rows using ROW_NUMBER() & RANK() • Calculated running totals with SUM() • Used LAG() & LEAD() to compare rows • Applied moving averages for trends Solved 1 question on HackerRank
Day 14 of #50DaysOfSQL Mastered 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗝𝗼𝗶𝗻𝘀: • Self-Joins: Compare rows within the same table • Cross-DB Joins: Combine multiple databases • Non-Equi Joins: Map ranges with BETWEEN Solved 1 question on @hackerrank just keeps getting better!
