Category: Coding
-
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…
-
Medium SQL Challenge: USING JOINS

365 Days of Daily Coding: Day 66 Today went by very fast. Is that a good thing? Although interms of productivity, I would say I was on average scale. I did manage to cross out one and half task out of the 4 task that I wanted to complete. The third task could not be…
-
Medium SQL Challenge: USING Subquery

365 Days of Daily Coding: Day 64 Today, I woke up extremely late which I am not quite happy about but I did manage to complete some work that I intended to do today. I also have been reading information on a cryptocurrency and especially Cardano. I am excited to see how the team unfolds…
-
Easy SQL Challenge: Using JOINS again!

365 Days of Daily Challenge: Day 63 I like to sleep late cause I like working at night. However, working late has a disadvantage when you have a meeting in the morning next day. I was quite tired the whole day and was not able to be as much productive as I would like to…
-
Medium SQL Challenge: Using JOINS

365 Days of Daily Challenge: Day 62 Lately, Bit coins and cryptocurrency are in hype and their prices have been climbing massively. I have been tempted to invest some of my hard earned money but I dont know much about this industry and I don’t want to invest in something that I am not familiar…