Category: Coding
-
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…
-
Medium SQL Challenge: Using JOINS
365 Days of Coding Challenge: Day 75 I went out with my friends today. I had a really good time despite all the waitings. It’s good to go outside when you have been couped up at home really long. Some people be like “Covid cases are increasing. Do your part by staying at home.” That…
-
Medium SQL Challenge: Using JOINS for 5 tables
365 Days of Gratitude: Day 74 Gosh I am soo tired today. I was trying to solve a difficult challenge that I had skipped in the past. I would say I almost got the answer because it nearly solves the challenge. I will try again some day. Meanwhile, the medium challenge that I solved today…
-
Easy SQL Challenge: Using Windows Function to Find Cumulative Sum
365 Days of Daily Coding: Day 72 My lazy a$$ did it again. I couldn’t be bothered to solve past challenges that I was unable to solve. Since I wanted to save myself, I solved an easy challenge again which was pretty similar to yesterday’s challenge. Tomorrow I am going to make it for sure.…
-
Easy SQL Challenge: Using Windows Function
365 Days of Coding Challenge: Day 72 In order to save my lazy ass, I solved an easy challenge instead of the medium challenge that I was supposed to continue from yesterday. I solved an easy sql challenge but to me it seemed as though it was a medium challenge cause I have never done…
helokarma.blog 