Group Sold Products By The Date
Vicky Chhetri
Table Activities: +-------------+---------+ | Column Name | Type | +-------------+---------+ | sell_date | date | | product | varchar | +-------------+---------+ There is no primary key for this table, it…
Competitive programming
Fix Names in a Table
Table: Users +----------------+---------+ | Column Name | Type | +----------------+---------+ | user_id | int | | name | varchar | +----------------+---------+ user_id is the primary key for this table. This…
Add Binary
Given two binary strings a and b, return their sum as a binary string. Example 1: Input: a = "11", b = "1" Output: "100" Example 2: Input: a =…
Remove Element
Given an integer array nums and an integer val, remove all occurrences of val in nums in-place. The relative order of the elements may be changed. Since it is impossible…
Search Insert Position
Given a sorted array of distinct integers and a target value, return the index if the target is found. If not, return the index where it would be if it…
Length of Last Word
Given a string s consisting of words and spaces, return the length of the last word in the string. A word is a maximal substring consisting of non-space characters only.…
Plus One – C#
You are given a large integer represented as an integer array digits, where each digits is the ith digit of the integer. The digits are ordered from most significant to…
Valid Parentheses
Given a string s containing just the characters '(', ')', '{', '}', '', determine if the input string is valid. An input string is valid if: Open brackets must be…
Longest Common Prefix
Write a function to find the longest common prefix string amongst an array of strings. If there is no common prefix, return an empty string Example 1: Input: strs =…
SQL Joins
INNER JOIN: is used when retrieving data from multiple tables and will return only matching data. LEFT OUTER JOIN: is used when retrieving data from multiple tables and will return…