Category: Blog
-
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…
-
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…
helokarma.blog 