Category: Coding
-
Easy SQL Challenge: Using Subqueries
365 Days of Daily Coding: Day 41 I have to say I was flustered the entire day because of an unexpected event. Therefore, this led me into the recognition of how our minds play the role of our wellbeing. It is not that which could be immediately cured. Emotional resiliency comes with a lot of…
-
SQL Challenge: Using Windows Functions RANK()
365 Days of Daily Coding: Day 40 It’s going to be almost 1 year since I have been working from home this coming Feb. As many of you, I struggled with adjusting WFH practice because I did not have a proper office set up. I was using a portable table and a duvet as my…
-
Easy SQL Challenge: Using RANK() or LIMIT
365 Days of Daily Coding: Day 39 I would say that I had quite a productive day. I ended up doing all of the things that I had in my mind except cooking for lunch (hehe!). I have been trying to save some money that is I why I am quite strict with my expenses.…
-
SQL Challenge: Using Functions Like AVG(), COUNT() and JOIN
365 Days of Daily Coding: Day 38 Today was a lazy day. I watched few episodes of a K-drama in Netflix, got bored and then continued the challenge for the day. Since I was feeling extra today, I solved 4 challenges: 2 easy, 1 medium and 1 difficult. The last challenge was the same challenge…
-
Medium SQL Challenge: Using RANK()
365 Days of Daily Coding: Day 37 I finished a chapter from the book that I am currently reading. The chapter was about predictions and our biases that influences predctions. A key point in the chapter was the idea of “Regression to the mean”. In simple words, it means that if a footballer played the…
-
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()…
-
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…
helokarma.blog 