Search results for #100DaysOfSQL
Solved today in SQL: Sales Analysis III Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Day 44 of #100DaysOfSQL Solved LeetCode #610: Triangle Judgement ✨ Key takeaway: Practiced conditional logic in SQL with CASE WHEN. Verified whether three sides form a valid triangle using the rule a + b > c AND a + c > b AND b + c > a. #DataAnalytics #100DaysOfCode
Day 44 of #100DaysOfSQL Solved LeetCode #610: Triangle Judgement ✨ Key takeaway: Practiced conditional logic in SQL with CASE WHEN. Verified whether three sides form a valid triangle using the rule a + b > c AND a + c > b AND b + c > a. #DataAnalytics #100DaysOfCode https://t.co/iNo7VoHTK7
Solved today in SQL: User Activity for the past 30 Days I Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Solved today in SQL: Project Employees I !!! Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Day 42 of #100DaysOfSQL Solved LeetCode #596: Classes With at Least 5 Students ✨ Key takeaway: Learned to group by class and use HAVING COUNT(*) > 4 to filter only the classes that meet the minimum student threshold. #DataAnalytics #100DaysOfCode
Day 42 of #100DaysOfSQL Solved LeetCode #596: Classes With at Least 5 Students ✨ Key takeaway: Learned to group by class and use HAVING COUNT(*) > 4 to filter only the classes that meet the minimum student threshold. #DataAnalytics #100DaysOfCode https://t.co/G8Kzi0rvuD
Solved today in SQL: Product Sales Analysis !!! Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Day 41 of #100DaysOfSQL Queries Quality and Percentage Key takeaway: Practiced using AVG(rating/position) to measure query quality, and 100 * SUM(CASE WHEN rating < 3 THEN 1 ELSE 0 END)/COUNT(*) for poor query percentage — grouped by query_name. #DataAnalytics #100DaysOfCode
Day 41 of #100DaysOfSQL Queries Quality and Percentage Key takeaway: Practiced using AVG(rating/position) to measure query quality, and 100 * SUM(CASE WHEN rating < 3 THEN 1 ELSE 0 END)/COUNT(*) for poor query percentage — grouped by query_name. #DataAnalytics #100DaysOfCode https://t.co/bgpMasGqg9
Solved today in SQL: Actors and Directors Who Cooperated At Least Three Times !!! Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Day 40 of #100DaysOfSQL LeetCode #1251: Average Selling Price ✨ Key takeaway: Learned how to join Prices with UnitsSold using date ranges, then calculate revenue with SUM(price * units) / SUM(units) for accurate weighted averages. #DataAnalytics #100DaysOfCode
Day 40 of #100DaysOfSQL LeetCode #1251: Average Selling Price ✨ Key takeaway: Learned how to join Prices with UnitsSold using date ranges, then calculate revenue with SUM(price * units) / SUM(units) for accurate weighted averages. #DataAnalytics #100DaysOfCode https://t.co/Ofv7bJojsW
Solved today in SQL: Swap Salary !!! Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Day 39 of #100DaysOfSQL Not Boring Movies ✨ Key takeaway: Practiced filtering rows with WHERE using conditions on id % 2 <> 1 and excluding "boring" movies, plus learned how ORDER BY rating DESC refines results. #DataAnalytics #100DaysOfCode
Day 39 of #100DaysOfSQL Not Boring Movies ✨ Key takeaway: Practiced filtering rows with WHERE using conditions on id % 2 <> 1 and excluding "boring" movies, plus learned how ORDER BY rating DESC refines results. #DataAnalytics #100DaysOfCode https://t.co/xqGqjAHlqH
Solved today in SQL: Not Boring Movies !!! Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Solved today in SQL: Triangle Judgement !!! Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Day 38 of #100DaysOfSQL Confirmation Rate Key takeaway: Learned how to calculate confirmation rates by joining signups with confirmations, handling missing records with LEFT JOIN, and using ROUND() for precise decimals. #DataAnalytics #100DaysOfCode
Day 38 of #100DaysOfSQL Confirmation Rate Key takeaway: Learned how to calculate confirmation rates by joining signups with confirmations, handling missing records with LEFT JOIN, and using ROUND() for precise decimals. #DataAnalytics #100DaysOfCode https://t.co/ry19AZqJ1m
Day 1: SQL Challenge🚀 A retail store tracks all transactions in: Sales(order_id,customer_id,product_id, order_date,amount) -Management asks: Which customers spent more than the avg spend in June 2025, but less than the avg spend in July 2025 #SQL #DataAnalytics #100DaysOfSQL
Solved today in SQL: Biggest Single Number!!! Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Day 37 of #100DaysOfSQL Friend Requests II – Who Has the Most Friends Key takeaway: Learned how to treat friendships as bidirectional by combining sender & receiver IDs with UNION ALL, then grouping to count total friends per user. #DataAnalytics #DataScience #100DaysOfCode
Day 37 of #100DaysOfSQL Friend Requests II – Who Has the Most Friends Key takeaway: Learned how to treat friendships as bidirectional by combining sender & receiver IDs with UNION ALL, then grouping to count total friends per user. #DataAnalytics #DataScience #100DaysOfCode https://t.co/0W2rZb3JUh
Solved today in SQL: Find Customer Referee !!! Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Day 36 of #100DaysOfSQL Employee Bonus Key takeaway: Practiced LEFT JOIN to include all employees, even those without bonuses, and used filtering to return only employees with a bonus or no bonus entry. #DataAnalytics #100DaysOfCode
Day 36 of #100DaysOfSQL Employee Bonus Key takeaway: Practiced LEFT JOIN to include all employees, even those without bonuses, and used filtering to return only employees with a bonus or no bonus entry. #DataAnalytics #100DaysOfCode https://t.co/piZR3tnddh
Solved today in SQL: Classes With at Least 5 Students !!! Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
