Joining Tables
"Find the total number of products ordered for each product"
AskAI
This technical problem deals with finding the total number of products ordered for each product, using two tables (products and orders). An example input and output is given.
SQL query to find customers who have purchased products with a list price...
AskAI
This technical problem deals with finding customers who have purchased products with a list price greater than $100.
SQL: Join Two Tables
AskAI
Write a SQL query to find all the rows from table A that have a matching row in table B.
Finding rows in table A that have corresponding rows in table B
AskAI
Given two tables, A and B, write a query to find all the rows in A that have a corresponding row in B.
Find Customers Who Have Purchased Products from Both Suppliers A and B
AskAI
Write a SQL query to find the names of all customers who have purchased products from both suppliers A and B.
SQL query to find matching pairs of rows in two tables
AskAI
This technical problem deals with finding matching pairs of rows in two tables using SQL. An example is given, along with the expected output.
Get names of products in "Electronics" category
AskAI
Write a SQL query to return the names of all products in the "Electronics" category, given two tables - products and product_categories.
Find names of customers who have purchased products with a price greater than...
AskAI
This technical problem asks the reader to write a SQL query to find the names of all customers who have purchased products with a price greater than $10. The example input provides three tables - customers , products, and purchases - and the expected output is a list of customer names.
