Databases

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.

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

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

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

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

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

179
Mar 12
Joining Two Tables on the id Column
AskAI

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

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

194
Mar 11