Category: Blog
-
Medium SQL Challenge: Using JOINS
365 Days of Coding Challenge: Day 75 I went out with my friends today. I had a really good time despite all the waitings. It’s good to go outside when you have been couped up at home really long. Some people be like “Covid cases are increasing. Do your part by staying at home.” That…
-
Medium SQL Challenge: Using JOINS for 5 tables
365 Days of Gratitude: Day 74 Gosh I am soo tired today. I was trying to solve a difficult challenge that I had skipped in the past. I would say I almost got the answer because it nearly solves the challenge. I will try again some day. Meanwhile, the medium challenge that I solved today…
-
Easy SQL Challenge: Using Windows Function to Find Cumulative Sum
365 Days of Daily Coding: Day 72 My lazy a$$ did it again. I couldn’t be bothered to solve past challenges that I was unable to solve. Since I wanted to save myself, I solved an easy challenge again which was pretty similar to yesterday’s challenge. Tomorrow I am going to make it for sure.…
-
Easy SQL Challenge: Using Windows Function
365 Days of Coding Challenge: Day 72 In order to save my lazy ass, I solved an easy challenge instead of the medium challenge that I was supposed to continue from yesterday. I solved an easy sql challenge but to me it seemed as though it was a medium challenge cause I have never done…
-
Medium SQL Challenge: Using JOINS
365 Days of Daily Challenge: Day 71 I am quite tired today. I guess I am overworking. I can’t wait to enjoy my day off on Thursday and Friday so it’s going to be long weekend for me. I have tons of personal work that I need to finish though. I am going to enjoy…
-
Diffcult SQL Challenge: Using NOT IN
365 Days of Daily Coding: Day 70 Happy International Women’s Day to all the wonderful and godgeous women out there. Know that you are beautiful, you are a star and you are needed. The universe sends its love to you if you are reading this. All you need to do is claim it. Say yes…
-
Medium SQL Day: Using JOINS
365 Days of Daily Coding: Day 69 Today was a lazy day. I slept a lot throughout the day. Prev, I used to feel a lot guilty when I did not do anything productive. Nowadays, my stance has changed. I feel like I work so hard throughout the week and I deserve the rest on…
-
Medium SQL Challenge: Using JOINS
365 Days of Daily Coding: Day 68 It was a great day today. I managed to solve two sql challenges today and watched a fantastic movie called ‘Lion’ for a change. I have been watching Naruto, one of my favorite anime and the only anime that I watch. I solved one medium challenge and one…
-
Easy SQL Challenge: Using UNION
365 Days of Daily Coding: Day 67 I met my friends after a long time and had good chat with them. Basically ranting about our work life and also so called ‘quarter life crisis’. My group of friends are literally the best way to release all my stresses and have a good laugh at the…
-
Easy SQL Challenge: Using FULL OUTER JOIN
365 Days of Daily Coding: Day 66 Today was a fairly productive day as in I did things that I intended to do. I solved an easy sql challenge. Unlike other challenges, I had to use FULL OUTER JOIN and a function called COALESCE. The function helps to concatenate strings from different cells and return…
helokarma.blog 