(ordr_date, cust_id, product_id, prc_per_unit, unit) ('2020-10-01', '1', 'AA', 10.5, 2), ('2020-11-01', '1', 'BB', 1.5, 3), ('2020-01-01', '1', 'CC', 3.5, 8), ('2020-01-01', '2', 'CC', 4.5, 3), ('2020-01-01', '2', 'BB', 1.5, 3); 1. List the top 20 customers who have the highest spending 2. Find the highest spent product for each customer
Implement a reverse hash table
Implement integer division
Given the upper left and lower right coordinates of two rectangles, determine if they overlap
Print the number of occurrences of a number in a sorted array of numbers. Input: 1 2 3 4 4 4 4 4 5 6 7 | 4 Ouput: 5
Give a 2D rectangular array represented as a 1D arrary in row-major form, rotate the array by 90 degrees
How will you check to see if two integer arrays have any common elements?
How would you find a duplicate number in a very large unsorted array of ints.
You have a list of sentences/words. How to find out the sub list that consists of a specific prefix? Ex: input: prefix="he", list = ["hello", "world", "hello world", "hey dude", "galaxy"....] output: ["hello", "hello world", "hey dude"]
Viewing 1651 - 1660 interview questions