Category: Blog
-
Codility Test: Challenge 1
365 Days of Daily Coding: Day 95 It’s been quite sometime since I last posted. I’ve been occupied with lot of things and I am gaining back my normalcy and routine. It’s as though I am waking up from my long dreamlike state and truly becoming aware of my self and my reality. I did…
-
Advanced SQL Challenge: Using Windows Function
365 Days of Daily Challenge: Day 94 I went to work in the office today after almost like 1 year. It felt strange but it was nice meeting some of my colleagues in the office. I feel lucky since I can decide whether I want to work from home or work from office. I solved…
-
Advanced SQL Challenge: Using LAG() and FLOOR()
365 Days of Daily Coding: Day 93 Lately, I have been thinking a lot about the purpose of my life. Perhaps, as I reach near my thirties, I am being given a chance to reassess my life. Perhaps, this self-awareness is asking me to rethink my chase for material and superficial possessions. As a Buddhist,…
-
Advance SQL Challenge: Permutation
365 Days of Daily Coding: Day 92 I went to watch an independent movie with my friend. It was about a teenager whose mother was suffering from pancreatic cancer and she wanted to find a way to have her mother near her even after she passed way. For this, she explored life after death beliefs…
-
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…
helokarma.blog 