Category: Coding
-
Easy SQL Challenge: Using LIKE and Wild Card Search Operator (%)
365 Days of Daily Coding: Day 31 I had a good start of the day. I woke up early but ended up not using it productively. That is something I would like to change. I have read a lot of articles publicising about having a proper morning routine. It’s not really easy especially when its…
-
Easy SQL Challenge: Using IN()
365 Days of Daily Coding: Day 30 Wow! It’s day 30 already. I am quite proud of myself for how far I have come. There were hiccups where in I stopped posting for 10 plus days after I took a 1 week hiatus for being sick and stressed. I am feeling quite unwell today but…
-
Medium SQL Challenge: Using MIN() and MAX()
365 Days of Daily Coding: Day 29 I had a good start in the morning today. I posted in my instagram today. It’s called @karmarambles where I share daily doses of positivity, motivation and stories to keep you going. At first, when I started it, I only wanted to fill up my time but as…
-
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…
-
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…
helokarma.blog 