Category: Blog
-
Medium SQL Challenge: Failed Attempt

365 Days of Daily Coding: Day 55 I have been fairly busy with work these days and so I am much occupied with troubleshooting issues and coming up with a solution. Therefore, I haven’t had enough time to look into other personal areas of my life. I hope there’s going to be some brakes. Today,…
-
Medium SQL Challenge: Using UNION

365 Days of Daily Coding: Day 55 I worked quite late yesterday and as a result, I was not feeling fresh today. I felt tired the entire day and wasn’t able to achieve much. Never going to work this late again. Although I am feeling sleepy and my mind is not functioning at its optimum…
-
Advance SQL Challenge 3

365 Days of Daily Coding: Day 54 I feel back ache once again. I was advised by the doctor that I was seeing to exercise regularly. I do tell myself to move around once after every 45 minutes. The first few rounds I am onto it but as the day progresses, I am completely attuned…
-
Advanced SQL Puzzle 2

365 Days of Daily Coding: Day 53 Today, I managed to solve a couple of advanced SQL puzzle. I wish to finish all the SQL puzzles in the advanced sql site as well as the SQLpad. Then perhaps, move on to creating a real projects by creating several tables. I hope there’s free version of…
-
Easy SQL Challenge: Using Subquery

365 Days of Daily Coding: Day 52 Today went by pretty fast. I think that means I had a good day although I did not do much of the things I would have wanted. I have got to work tomorrow which is a killer. I solved an easy challenge today.
-
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…