Joining Tables
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.
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.
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.
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.
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.
