Category: Coding
-
Medium SQL Challenge: Using LEFT JOIN
365 Days of Daily Coding: Day 51 I think I might need a break from work considering my demotivation these days. It’s not easy to sustain the working mood everyday. I enjoy being indoors but this lockdowns have really gotten the best of me. Today I solved a medium challenge. At first I wasn’t able…
-
Medium SQL Challenge: Using LIMIT()
365 Days of Daily Coding: Day 50 I did another sqlpad challenge. For one reason or the other I just wasn’t able to get the pass the challenge. I think I have gotten the right answer but it says that is not the correct answer. I will find another way to solve this in my…
-
Easy SQL Challenge: Using INNER JOIN
365 Days of Daily Coding: Day 49 I had a fantastic day. I am outright lying. It was a terrible day. Nothing specific happened but I just don’t feel right. It’s one of those days where you think your having your period soon but the guest has already arrived and is atleast overdue for the…
-
SQL Reddit Question
365 Days of Daily Coding: Day Day 48 Today was a day when I was supposed to wake up at 7 am and I woke up at 9 am. I have been wanting to wake up early but I can’t really seem to. I work late and as a result, I wake up late. I…
-
Mixed SQL Challenge: Using INNER JOIN and NOT IN
365 Days of Daily Coding: Day 47 Today was public holiday which I had totally forgotten about so I logged in for my work at around 12 pm and noticed that none of my colleagues were online which was quite strange. I figured out that it might be a glitch or a network lag. I…
-
Advanced SQL Challenge: Using Constraints
365 Days of Daily Coding: Day 46 Today was learning even more about the havoc created by the wallstreet bets redditors. I think I have learned a lot from the past 3 days of scouring the forums and the articles than I have learnt from my finance degree. I see that few redditors commenting on…
-
Easy SQL Challenge: Using INNER JOIN
365 Days of Daily Coding: Day 45 I woke up extremely late today and I didn’t have much planned for the entire day. I was pretty much occupied reading posts and comments on the reddit group “wallstreetbets” and perhaps understand where this all is heading. Although that I wish those redditors hold until the “moon”…
-
Easy SQL Challenge: Joining 3 Tables
365 Days of Daily Coding: Day 44 It has been a historic week with the massive surge in the share price of GME (Gamestop). This week will be remembered for years to come. For one, I am with the movement. On the other hand, I fear for those people that might have hopped in the…
-
Advanced SQL Puzzle 1
365 Days of Daily Coding: Day 43 I didn’t have quite a productive day today. It’s a public holiday so I was basically lazying around and web surfing. I read Bill and Melinda Gates foundation annual letter in the morning. Their letter moved me and made me hopeful of the future that lies ahead for…
-
Medium SQL Challenge: Using IN()
365 Days of Daily Coding: Day 42 Learning a new skill is similar to learning a new sport where you are trying everything for the first time. It’s frustrating when you are unable to deliver the results smoothly. There’s obstacles particularly in the early phases that makes you question yourself and your intelligence. I have…
helokarma.blog 