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.

139
Mar 10
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.

122
Mar 10
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.

131
Mar 10
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.

128
Mar 10
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.

144
Mar 09
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.

136
Mar 09
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.