Category: Coding
-
Advanced SQL: Using JOINS
365 Days of SQL: Day 151 I read the puzzle for today and I was thinking to myself, “Oh my gosh!” This looks really tough. However, as I began solving the question, I realised that the solution was rather smooth. It did not come easy but it helped to play around a bit. Yay for…
-
Advanced SQL: Using IN
365 Days of SQL: Day 150 I have decided to also officially start another challenge i.e for Tableau. I think I am good in Tableau however, since I started right off without basics, I want to work on them. I had started to read the Tableau documentation from their official site. I will be posting…
-
Advanced SQL: Using NOT IN
365 Days of SQL: Day 149 The rain has finally stopped after continuously raining for the past 2 days. There’s been flooding in several places in KL. I was actually invited to a friend’s house but i did not go because it was raining. It was wise decision although I felt a bit bad for…
-
Advanced SQL: Using JOINS
365 Days of Daily Coding: Day 148 It’s been raining heaviliy since yesterday here in KL. There are few places where its flooded. I feel blessed that I am living in a place where I feel safe and I am warm. Such are blessings that is easily missed in our everyday lives. Puzzle #33: Deadlines…
-
Advance SQL: Using Windows function
365 Days of SQL: Day 147 There’s been some construction happening in the floor above and its making our lives very uncomfortable. One of the cons of living in a condo. It’s going to be like this until 31st Dec. Why did they have to select such timing? Ahh geezz! Puzzle #32: First and Last…
-
Advanced SQL: Using multiple methods to gauge the optimum solution
365 Days of Daily Coding: Day 146 Starting fairly late today for today’s blog as lot of things have been going on in my head these days. I don’t know if things will turn out well like I have been thinking but I know that I cannot and should not stay where I am. This…
-
Advance SQL: Computed Column
365 Days of Daily Coding: Day 145 I am starting fairly early today writing this blog. For the past few days, I was working on it during the evening time and gosh! by then I am famished and my brain has very less power to concentrate. I have decided to visit the gym today which…
-
Advance SQL: Complex Puzzle
365 Days of SQL: Day 144 I took a day off today cause I had some personal things to run. I am super happy with my progress today and in general. I spent my day by relaxing and simply enjoying a nice Netflix movie called “Happiness”. I have recently started this challenge to post continuously…
-
Advance SQL: Using Running COUNT()
365 Days of Daily Coding: Day 143 “I am quite tired today. I just arrived home after celebrating my friend’s birthday. We went to a nice restaurant called “Blonde”. They sell fusion foods. I had BBQ lamb kebab that was served with rice. I would say it was ok. The meat was sort of caramelised…
-
Advance SQL: Using DELETE()
365 Days of Daily Coding: Day 142 I do not have oracle database installed in my laptop to truly work on the solution for today’s puzzle. I tried it several times for several hours however, I was not successful. Hence, the solution for today’s challenge is just done out of research. Perhaps, when I have…
helokarma.blog 