Category: Coding
-
Advanced SQL Challenge: Finding Basic Stats
365 Days of Daily Coding: Day 91 It’s 11 pm right now and I have spent almost 1.3 hour trying to solve today’s challenge. It was pretty interesting having to come out with a way to find the mode when there are no such functions in Oracle like we have for Mean and Median. I…
-
Advanced SQL Puzzle: Using JOINS
365 Days of Daily Coding Challenge: Day 90 It’s D-90, exactly 3 months since I started my daily coding challenge journey. I feel extremely humbled knowing that I have many more milestones to achieve although I am better than I was in D-1. To embrace my vulnerability when most if not everybody only display their…
-
Easy SQL Challenge: Using NTILE()
365 Days of Daily Challenge: Day 89 I found this very cool web application to take notes. It’s called “Notion”. You can use it to replace OneNote. Some of the benefits over OneNote is that you can create several cool objects in the page like list, boards, timelines and so much more as well as…
-
Easy SQL Challenge: Using NTILE()
3654 Days of Daily Coding: Day 88 I was trying to solve an easy sql challenge but was unable to solve it. It has partly to do with me not understanding what the function is and how it works. I am going to be working on it tomorrow too.
-
Easy SQL Challenge: Using CASE()
365 Days of Daily Coding Challenge: Day 87 This coding challenge has been the only constant fuel in my pandemic life so far. I feel like that energy has sparked various other areas of my life. For instance, 15 minutes exercise in the morning. I hate exercising and like this daily challenge, I strive to…
-
Difficult SQL Challenge: Using Windows Function
365 Days of Daily Coding Challenge: Day 86 Today I made a significant improvement towards my project. I am quite happy with it. I have yet to make progress on a data visualisation project that I announced couple of days ago. Seems like it is around the right time to start working on it. I…
-
Medium SQL Challenge: Using LAG()
365 Days of Daily Coding Challenge: Day 84 Today, I did an activity that was beyond my comfort zone. I am very happy with that. I hope I continue to step out of my comfort zone so that I continue to grow. I solved two medium sql challenge and managed to retain my position in…
-
Easy SQL Challenge: Calculating Cumulative Sum
365 Days of Daily Challenge: Day 84 Today was an ok day. I was I think 65% productive. I could have used my personal time to read instead of using social media. Tiktok, gwad!, they are so addictive. They keep you hooked and you lose your sense of time. An hour or two passes just…
-
Difficult SQL Challenge: Using LAG()
365 Days of Daily Challenge: Day 83 The best thing about today was that I woke up completely refreshed. This, I think has partly due to my pre-bed habits that I have been working on. I try to limit my exposure to smartphones and laptops and instead read. I am quite tired today but I…
-
Mixed SQL Challenge: Using LAG()
365 Days of Daily Coding Challenge: Day 82 I am currently reading Viktor Frankl’s “Man Search For Meaning” and it has sparked a part inside me that I am unable to explain. It’s as though I have doused the little fire that had been building inside me. As I lay awake listening to my favorite…
helokarma.blog 