Jun 28, 2021How I solved LeetCode Challenge, Rank Scores!Hi Everyone, Today I will be reviewing how I solved LeetCode challenge, Rank Scores, using SQL. Objective: Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ranking number should be the…Software Engineering2 min readSoftware Engineering2 min read
Jun 20, 2021How I solved LeetCode Challenge, Richest Customer Wealth!Hi Everyone, Today I will be breaking down how I solved challenge, Richest Customer Wealth, using JavaScript. Objective: You are given an m x n integer grid accounts where accounts[i][j] is the amount of money the ith customer has in the jth bank. …Software Engineering2 min readSoftware Engineering2 min read
Jun 16, 2021How I solved LeetCode Challenge, Shuffle the Array!Hi Everyone, Today I will be going over how I solved LeetCode Challenge, Shuffle the Array, using JavaScript. Objective: Given the array nums consisting of 2n elements in the form [x1,x2,...,xn,y1,y2,...,yn]. Return the array in the form [x1,y1,x2,y2,...,xn,yn]. Example 1: Input: nums = [2,5,1,3,4,7], n = 3 Output: [2,3,5,4,1,7] Explanation: Since…Software Development2 min readSoftware Development2 min read
Jun 13, 2021How I solved, Defanging an IP Address, on LeetCodeHi Everyone, Today I will be going over how I solved, Defanging an IP Address, on LeetCode. Objective: Given a valid (IPv4) IP address, return a defanged version of that IP address. A defanged IP address replaces every period "." with "[.]". Level: Easy Example 1: Input: address = "1.1.1.1" Output…Software Development1 min readSoftware Development1 min read
Jun 7, 2021How I solved LeetCode Challenge, All People Report to the Given ManagerHello Everyone, Today I will be going over how I solved LeetCode Challenge, All People Report to the Given Manager, in SQL. Objective: Write an SQL query to find employee_id of all employees that directly or indirectly report their work to the head of the company. The indirect relation between…Software Engineering3 min readSoftware Engineering3 min read
May 30, 2021How I Solved LeetCode Challenge, Calculate SalaryHello Everyone, Today I will be reviewing how I solved LeetCode Challenge, Calculate Salary, using SQL. Objective: Write an SQL query to find the salaries of the employees after applying taxes. The tax rate is calculated for each company based on the following criteria: 0% If the max salary of…Software Engineering2 min readSoftware Engineering2 min read
May 24, 2021How I solved Leetcode Challenge, Remove Vowels from a String!Hello Everyone, Today I will be reviewing how I solved Leetcode Challenge, Remove Vowels from String. Objective: Given a string s, remove the vowels ‘a’, ‘e’, ‘i’, ‘o’, and ‘u’ from it, return the new string. First I began by console logging the string to see what my output looked…Leetcode2 min readLeetcode2 min read
May 17, 2021How I solved Leetcode Challenge, Employee Bonus!Hello Everyone, Today I solved Leetcode challenge, Employee Bonus, using SQL. Easy challenge, but fun none the less. Objective: Select all employee’s name and bonus whose bonus is < 1000. Expected Output: Tables Provided:Software Development2 min readSoftware Development2 min read
May 9, 2021How I solved Hacker Rank Challenge, Migratory BirdsHello Everyone, Today I will be going over how I solved Hacker Rank Challenge, Migratory Birds, using JavaScript. Objective: Given an array of bird sighting where every element represents a bird type id, determine the id of the most frequently sighted type. …Software Engineering3 min readSoftware Engineering3 min read
May 3, 2021How I Solved Hacker Rank Challenge, ‘Electronics Shop’Hi Everyone, Today I will be going over how I solved Hacker Rank Challenge, Electronic Shop, using JavaScript. The Objective: A person wants to determine the most expensive computer keyboard and USB drive that can be purchased with a give budget. Given price lists for keyboards and USB drives and…Software Development2 min readSoftware Development2 min read
