Data
Find Customers Who Have Placed an Order
AskAI
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.
Find names of customers who have ordered a product over $100
AskAI
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.
SQL query to find customers who have placed orders over $100
AskAI
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.
5 Customers Who Have Made the Most Purchases
AskAI
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.
Find Two Numbers That Sum to a Target in an Array
AskAI
Given an array of integers and a target sum, return the indices of the two numbers that add up to the target sum.
Sum of Values in A for Ids in B
AskAI
Return the sum of the values in table A for all id's that are also present in table B.
Find Customers Who've Purchased Expensive Products
AskAI
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.
Maximum Sum Contiguous Subarray of Length K
AskAI
Given an array of n integers, the problem is to find the contiguous subarray of length k with the maximum sum.
