Category: Coding
-
8 Weeks of SQL Challenge: Week 2

365 Days of Daily Coding: Day 101 Hello readers! I hope you had a good day. We are having lock down here in Kuala Lumpur. We are only allowed to travel a distance of 10km from our home for necessities and emergencies. I also hope that you all have either been vaccinated or waiting to…
-
8 Weeks of SQL Challenge: Week 1

365 Days of Daily Coding: Day 100 Wohooo! It’s Day 100. I am really happy with my progress. It’s been an amazing ride I must say. To continue off with yesterday’s challenge, I looked into implementing the last question in excel and I am extremely elated to announce that the results match perfectly. That means…
-
8 Weeks of SQL Challenge: Week 1

365 Days of Daily Coding: Day 99 I am pretty tired today. It’s kind of late too but I had wanted to finish checking if my queries from the Week 1 challenge that I completed yesterday were spitting the same results as in excel. In the process, it has also helped me to refresh memories…
-
8 Weeks of SQL Challenge: Week 1

365 Days of Daily Coding: Day 98 I have been working on this SQL challenge for a few days. The challenges here are like real case based scenarios which were totally fun to work on. At first, I wanted to be a serious SQL student and therefore, run the queries for the challenges in Oracle…
-
Advent of Code Day 1

365 Days of Daily Coding: Day 97 This blog has been posted after quite sometime. It’s not that I haven’t been working on coding. I just didn’t bother to post about what I had been learning. Since I have completed most of the questions in SQL pad (just have 1 question to solve there) and…
-
Codility Test: Challenge 2

365 Days of Daily Coding: Day 96 I was quite occupied with work today nontheless, I managed my productivity although I would have liked it to be much better. I am resuming my Korean classes from June which I am quite excited about. But first, I must recap everything I learned from the beginner and…
-
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…