Category: Coding
-
365 Days of Daily Coding: Day 10
Today’s leetcode challenge was very challenging. It’s frustrating to not be able to answer at the same time not easily be able to understand other sucessful submissions. Given a table, I had to find out the numbers that were repeated three times consecutively. Id Num 1 1 2 1 3 1 4 2 5 1…
-
365 Days of Daily Coding: Day 9
I did 2 easy and 1 medium ranked Leetcode challenges since it’s weekend today. Let’s head straight towards the challenges. Challenge 1: Given the Cinema table with Id, Movie, Description and Rating as column headers, I had to find out movies that have odd numbers as their ID no. and description that does not contain…
-
365 Days of Daily Coding: Day 8
I did a Leetcode challenge today instead of a HackerRank challenge cause I find that the challenges in HackerRank are not easily understandable whereas description of challenges in Leetcode are short and concise. The challenge: Given the ID no. and Salary, I had to find out the nth highest salary. ID Salary 589 100 590…
-
Medium Challenge 4: Using LISTAGG() And LEVEL() Function – Part 2
365 Days of Daily Coding: Day 6 and Day 7 I did not post for Day 6 as I was trying to crack the solution of Day 5 that had been submitted by others and I can finally say that I understand the codes. I was able to break down the query and was able…
-
Medium Challenge 4: Using LISTAGG() And LEVEL() Function – Part 1
365 Days of Daily Coding: Day 5 Today was an extremely awry day as I was not able to crack two HackerRank challenges that were ranked medium. The first one, I could not comprehend the question and so I had to skip. The second one, neither was I able to answer nor was I able…
-
Medium Challenge 3: Difference Between Inner Join and Left Join
Today’s HackerRank challenge although seemed easy was quite tricky for me. There were 5 tables: Company, Lead_Manager, Senior_Manager, Manager and Employee. Using these 5 tables or not, I had to find the name of the founder; total number of lead managers, senior managers, managers and employees working at the company. Sample of the table ‘Company’:…
-
Medium Challenge 2: Tree Binary Data Structure in SQL
365 Days of Daily Coding: Day 3 I solved another SQL HackerRank challenge. With the help of the discussion, I was able to understand and get the solution. Given the numbers in the two columns representing a tree binary data structure, ‘N’ and ‘P’, I had to figure out which of the combinations (N &…
-
Medium Challenge 1: PIVOT() Function in Oracle
365 Days of Daily Coding: Day 2 Months of pondering and I am finally embarking on this journey to solve at least one coding challenge a day. I was reluctant to post about my Day 1 progress but I thought it would be a good idea to document my progress and therefore, somewhere down the…
helokarma.blog 