Category: Blog
-
Medium SQL Challenge: Using SUM(), COUNT() and DISTINCT() To Find The Average Value
365 Days of Daily Coding: Day 27 I am quite not feeling well today. I think I might have a stiff neck. I am planning to see a acupuncturist that my friend has been seeing for a while. The clinic is called Xing Lin Tcm Centre. I hope there isn’t much issue with my body.…
-
Easy SQL Challenge: Using COUNT() With DISTINCT()
365 Days of Coding: Day 26 In my opinion, out of the three challenge sites I have tried, leetcode and sqlpad comes close to close. The only difference between them being that leetcode offers challenges for multiple languages and has an active user base that frequently shares their insights in the forums. Since, I have…
-
Easy SQL Challenge: Filtering Rows Using DATE()
365 Days of Coding: Day 25 Another successful sql challenge today. Handling dates are rather very important topics in SQL. Today’s challenge: Given a table called “payment”, I had to find the total daily revenue for the period of June, 2020. Table payment: col_name col_type payment_id integer customer_id smallint staff_id smallint rental_id integer amount numeric…
-
Easy SQL Challenge: Using Aggregate Function and GROUPBY()
365 Days of Coding: Day 23 I solved a sqlpad questions today. Somehow, I was only able to do 1 challenge and that seems to be the limit for a free account. I am actually conflicted as to whether to buy their subscription. It is because compared to leetcode they seem to be pricier. Todays’…
-
Easy SQL Challenge: Using SELECT()
365 Days of Coding: Day 23 I found another sql challenge site like Leetcode and HackerRank. It’s called sqlpad. I am loving the sleek and neat interface. They only have SQL challenges at the moment. Besides challenges, they also offer SQL tutorial classes and resume reviews. I solved four easy questions. Solving SQL challenges is…
-
The meaning of New Year 2021…
Photo by Nagatoshi Shimamura on Unsplash. I was engrossed into watching a Neflix K-drama specifically ‘Start Up’ which I have just finished watching. I heard few people screaming count downs. “Wait, is it close to 12pm already.” Checks the time to find it has just struck 12 and I hear fireworks. I quickly climb my…
-
Order of Operations in SQL
365 Days of Daily Coding: Day 22 Order of operation in SQL is one of the topics that is often not covered in many of the Introductory SQL online courses out there in the market but in my opinion is an equally important concept to know as a beginner. I was intrigued by the variance…
-
Easy SQL Challenge : Using FLOOR()
365 Days of Daily Coding: Day 21 I have finished all the free leetcode challenges except for 1 hard challenge which I am saving it for much later to try when I can solve it without looking for any solution in the forums. I did a hacker rank challenge today, an easier one. I got…
-
Weekend Escape: Onsen at Urban Retreat
Photo by Tore F on Unsplash I have a group of BFFs and we often do something special on each other’s birthday. What we normally do is buy/treat the friend with gift based on their interest and we all join along. This time for one of our friends birthday, we decided to gift her an…
-
Oracle SQL JOIN Types – Part 3
365 Days Of Daily Coding: Day 20 I took a break for few days as I felt sick and exhausted with having to work on a daily post and also working full time. I hope if someone out there is following my daily posts and inspires to also do a daily 365 coding challenge, I…
helokarma.blog 