Category: Blog
-
Medium SQL Challenge: Using RANK() OR LIMIT
365 Days of Daily Coding: Day 36 I have been reading few pages a day in the morning lately. If you have been following me, I talked about my bad habits especially in the morning. Although I wake up on average at around 7.30 am , I do not wake up immediately. I just lie…
-
Medium SQL Challenge: Using WITH
365 Days of Daily Coding: Day 35 I feel slightly better today. However, I do feel slight intense pressure on my right shoulder. I have been feeling this way since very long. I guess the accupunture was not that helpful to treat my right shoulder. However, it did help me with my intense neck and…
-
Easy SQL Challenge: Using COUNT() and DESC
365 Days of Coding: Day 34 Lately, my health has not been good. I have been feeling severe neck and shoulder pain for the past few days. It might be the result of lack of exercise which I am having a tough time to incorporate into my daily routine. I am not a morning person…
-
Easy SQL Challenge: Filtering rows based on text
365 Days of Daily Coding: Day 32 I tried a difficult question on the SQLpad but it proved to be challenging hence I was unable to solve it. I had to categorise the records, count the number in each categories and display the categories with their counts in columns. I tried to use the PIVOT()…
-
Reflection of K-drama: Reply 1988
There’s probably only handful of movie/drama ever made that has a lasting impression on you even after you have finished watching the movie long ago. At times, when the recommended movies have been exhausted, this is the one movie you go back to so that you could relive the experience and the joy the movie…
-
Medium SQL Challenge: Using CASE logic
365 Days of Daily Coding: Day 32 I had a gairly good start of a weekend. In the morning, I had a very nice chat with my family who are currently living in Kathmandu. It’s been 2 years since I last went back home. As you all may know because of the pandemic traveling is…
-
Easy SQL Challenge: Using LIKE and Wild Card Search Operator (%)
365 Days of Daily Coding: Day 31 I had a good start of the day. I woke up early but ended up not using it productively. That is something I would like to change. I have read a lot of articles publicising about having a proper morning routine. It’s not really easy especially when its…
-
Easy SQL Challenge: Using IN()
365 Days of Daily Coding: Day 30 Wow! It’s day 30 already. I am quite proud of myself for how far I have come. There were hiccups where in I stopped posting for 10 plus days after I took a 1 week hiatus for being sick and stressed. I am feeling quite unwell today but…
-
Medium SQL Challenge: Using MIN() and MAX()
365 Days of Daily Coding: Day 29 I had a good start in the morning today. I posted in my instagram today. It’s called @karmarambles where I share daily doses of positivity, motivation and stories to keep you going. At first, when I started it, I only wanted to fill up my time but as…
-
Medium SQL Challenge: Using Subqueries
365 Days of Coding: Day 28 Today’s medium sql challenge was comparatively challenging. I had fun solving the challenge as it made me go back to some of the materials that I studied especially on the order of operations. If you would like to check out the articles, the link is here. Challenge: Given the…
helokarma.blog 