Databases
Find Customers Who Have Purchased Products Over $100
AskAI
This technical problem involves writing a SQL query to find the names of all customers who have purchased products with a price greater than $100. The example input and output are provided.
Finding the number of rows in T1 that have a matching row in T2
AskAI
This technical problem involves writing a SQL query to find the number of rows in one table (T1) that have a corresponding row in another table (T2). An example input and output are provided.
Find all employees who work in the "Sales" department.
AskAI
This technical problem involves writing a SQL query to find the names of all employees who work in the "Sales" department. The query must be able to join the "Employees" and " Departments" tables in order to produce the desired output.
Finding all pairs of records with the same value for attribute A
AskAI
To find all pairs of records with the same value for attribute A, you can use a SQL query. Simply specify the relations R and S, and the query will return all pairs (r ,s) such that r is in R, s is in S, and r and s have the same value for the attribute A.
Find all employees who work in the "Sales" department.
AskAI
This technical problem involves writing a SQL query to find the names of all employees who work in the "Sales" department, given two tables: "Employees" and "Departments".
SQL query to find average salary of all employees in a company
AskAI
This technical problem asks the reader to write a SQL query to find the average salary of all employees in a company. The input is a table of employees with their id, name, and salary . The output should be the average salary.
Joining two tables on the id column
AskAI
To join two tables on the id column, write a SQL query that returns the id and name columns from each table.
Pairs of Rows in Order
AskAI
Given two tables, A and B, this SQL query finds all pairs of rows such that the rows in table A are in order (a1 < a2 < ... < an) and the rows in table B are in order (b1 < b2 < ... < bn).
