## Data

##### Find Customers Who Have Placed an Order

This technical problem asks the reader to write a SQL query to find customers who have placed at least one order, by joining the customers and orders tables. The expected output is a list of customer ids and names.

200
Mar 10
##### Find names of customers who have ordered a product over \$100

Write a SQL query to find the names of all customers who have placed an order for a product with a price greater than \$100.

191
Mar 10
##### SQL query to find customers who have placed orders over \$100

This technical problem deals with writing a SQL query that returns the names of customers who have placed an order with a total value of more than \$100.

194
Mar 10
##### 5 Customers Who Have Made the Most Purchases

This technical problem involves writing a SQL query to find the first five customers who have made the most purchases from the store. The example input and output are provided.

202
Mar 10
##### Find Two Numbers That Sum to a Target in an Array

Given an array of integers and a target sum, return the indices of the two numbers that add up to the target sum.

192
Mar 09
##### Sum of Values in A for Ids in B

Return the sum of the values in table A for all id's that are also present in table B.

204
Mar 09
##### Find Customers Who've Purchased Expensive Products

This technical problem involves finding customers who have purchased products with a price greater than \$100. The input is a customers table and a products table. The output is the names of the customers who have purchased products with a price greater than \$100.

193
Mar 09
##### Maximum Sum Contiguous Subarray of Length K

Given an array of n integers, the problem is to find the contiguous subarray of length k with the maximum sum.

195
Mar 09