Category: Blog
-
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…
-
Easy SQL Challenge: Finding PERCENTILE distribution
365 Days of Daily Coding: Day 81 I had a migraine at the right side of brain yesterday and was unable to post. I was reflecting back at the number of times I couldn’t post although it’s meant to be a daily challenge. The past me would have nagged myself to death. Now, as I…
-
Difficult SQL Challenge: Using COALESCE()
365 Days of Daily Challenge: Day 80 Today, I solved a difficult SQL challenge that I had been unable to solve previously. It took a good amount of time to debug what was not working. I finally managed to figure out that the NULL records when using GROUP BY are treated as a separate groups.…
-
Difficult SQL Challenge: Using WINDOWS Function
365 Days of Daily Coding Challenge: Day 79 I am pleased with my performance today. I am becoming pro in solving challenges involving Windows function. I also tried solving another difficult challenge to get into the Top 10 leaderboard but unfortunately I was not able to solve it and I am bit tired to think…
-
Medium SQL Challenge: Using Windows Function
365 Days of Daily Challenge: Day 78 My first project failed today. It was disheartening considering I had put effort for its success. However, I believe that there’s going to be many such failures along the way. And one day, I will finally see the daylight. What’s more they keep me grounded and stay humble.…
-
Easy SQL Challenge: Using WINDOWS Function
365 Days of Daily Challenge: Day 77 I am very happy with a progress that I made for one of my internal projects. I have been wanting to make good progress for a very long time and I was finally able to do so this time around. I hope it yearns good result. Super duper…
-
Difficult SQL Challenge: Using Joins
365 Days of Daily Coding: Day 76 Today was another lazy day. I think I ought to do this challenge for python too cause I have not been making any significant progress as much as I would like to. I solved a difficult challenge today. I was tempted to solve an easy one just because…
helokarma.blog 