Databases

Finding matching rows in two tables
AskAI

Given two tables, A and B, this SQL query will find all pairs of rows where the values in the columns match.

156
Mar 06
Customers with orders over $1000
AskAI

This technical problem involves writing a SQL query to find the names of customers who have placed orders with a value greater than $1000.

153
Mar 06
SQL Query to Find Customers with Orders Greater than $1000
AskAI

This technical problem deals with writing a SQL query to find customers who have placed orders with a total value greater than $1000.

148
Mar 06
Find customers who have placed orders with a total value greater than $100.
AskAI

Write a SQL query to find the names of all customers who have placed an order with a total value greater than $100.

173
Mar 06
SQL query to find all rows in A that have a corresponding row in B
AskAI

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

154
Mar 06
Find Names of Employees in Sales Department
AskAI

This problem involves joining two tables, "Employees" and "Departments", to find the names of employees who work in the Sales department.

110
Mar 05
Join Two Tables on id Column
AskAI

Use a SQL query to join two tables on the id column and return all columns from both tables.

156
Mar 05
Write a SQL query to find the total number of purchases made by each user.
AskAI

This technical problem involves writing a SQL query to find the total number of purchases made by each user, given two tables: "users" and "purchases".

162
Mar 05