Category: Blog
-
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…
-
Namaste
नमस्ते! (Namaste!) It’s a form of hand-gesture by pressing your two hands together commonly used to greet another person. NAMASTE! It’s been widely publicised to use this as a common way of greeting during this COVID pandemic rather than the normal handshake we are used to. Ever wondered what it means. Namaste is a word…
-
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…
-
Killing your inner demons – The Ninja Style
How often do you talk to yourself? Yes, I mean with yourself. If you do, you are not mentally deluded. Researchers have found that talking with yourself increases one’s well-being. On that note, self-talk can not always be beneficial. While you may find that talking with yourself to boost your confidence or to take that…
-
Designing Products for the Poor: The Unilever Way
If you have travelled to developing countries like Nepal, you will come across or see a series of colourful samples of sachets suspended in mini stores. If you haven’t, these sachets are mini shampoos, mini detergents and mini stuffs that are cheaper and affordable for the majority of the population in Nepal. In Nepal, according…
helokarma.blog 