5 problems, 120 minutes

Problem 1 - Find mismatched prices:
You have an old grocery shop that instead of scanning their sold proudcts once sold, they type in the prices, which leaves room for mistyping sold prices. Given 4 lists: soldItems = ['eggs', 'milk', 'apple'], soldPrices = [1.00, 2.50, 2.1], productsAvailable = ['eggs', 'lemons', 'milk', 'apple'], productPrices = [1.01, 0.5, 2.50, 2.1], Find the number of items with mistyped prices

Problem 2 - Team Formation (already available on Leetcode discuss)

Problem 3 - OOP
[As you long as you know how to define classes, private methods, should be good-to-go]

Problem 4 - Find owners with $100M houses

Solution: SELECT house.BUYER_ID , SUM(price.PRICE) AS TOTAL_WORTH FROM house JOIN price USING(HOUSE_ID) GROUP BY house.BUYER_ID HAVING SUM(price.PRICE) > 100 AND COUNT(house.BUYER_ID) > 1;

Problem 5 - K-diff pairs in an array
Leetcode problem link