Joining Tables

Find the names of all customers who have placed an order for at least one...
AskAI

This technical problem involves writing a SQL query to find the names of customers who have placed an order for at least one product in either category 1 or category 2. The example output shows the expected result of the query.

155
Mar 13
Find all rows in A that are also in B
AskAI

To find all the rows in table A that are also in table B, write a SQL query that uses a JOIN clause.

143
Mar 13
SQL Query to Find Pairs of Rows from Two Tables
AskAI

This technical problem deals with finding pairs of rows from two tables, such that the values in column a of table A are less than the values in column b of table B, and the values in column b of table A are greater than the values in column a of table B.

127
Mar 12
Customers Who Have Purchased Products With a Price Greater Than $100
AskAI

This technical problem involves writing a SQL query to find the names of customers who have purchased products with a price greater than $100.

141
Mar 12
Find all rows from table A that have a matching row in table B
AskAI

Given two tables, A and B, write a SQL query to find all the rows from table A that have a matching row in table B.

143
Mar 12
SQL Query to Find Customers Who Have Placed Orders Totaling More Than $100
AskAI

This problem asks the user to write a SQL query to find the names of customers who have placed orders totaling more than $100. The input is two tables, one for customers and one for orders. The output should be a list of customer names.

135
Mar 12
Joining Two Tables on the id Column
AskAI

Write a SQL query to join two tables on the id column.

133
Mar 11
Finding Employees Who Work in the Sales Department
AskAI

Given two tables - "Employees" and "Departments" - write a SQL query to find the names of all employees who work in the "Sales" department.

156
Mar 11