Databases

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.

142
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.

151
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.

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

164
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.

157
Mar 09
Find all rows in Table A that have matching values in Table B.
AskAI

Given two tables, Table A and Table B, write a SQL query to find all the rows in Table A that have matching values in Table B. Output should be Table A with only the rows that have matching values in Table B.

155
Mar 09
SQL query to find all rows in A that have a matching row in B
AskAI

Given two tables, A and B, this SQL query will find all the rows in A that have a matching row in B.

152
Mar 09
Joining Tables to Find Fruits Eaten by John or Jane
AskAI

This technical problem involves joining two tables in order to find all of the fruits that have been eaten by either John or Jane.

153
Mar 09