Databases

Find the name and grade of students who are enrolled in at least one course.
AskAI

This technical problem involves writing a SQL query to find the name and grade of students who are enrolled in at least one course. The input is two tables - students and courses - and the output is the id, name, and grade of the students.

119
Mar 11
Get customer info for those living in the same city as customer id 3.
AskAI

Write a SQL query that returns the name, age, and city of residence for all customers who live in the same city as customer id 3.

151
Mar 11
Finding all matching pairs of rows from two tables
AskAI

Given two tables, A and B, write a SQL query to find all pairs of rows, one from each table, such that the values in the columns match.

123
Mar 11
Find all employees who live in the same city as their manager.
AskAI

This technical problem involves writing a SQL query to find all employees who live in the same city as their manager. Given a table of employee data, the query should return all employees who share a city with their manager. As seen in the example input/output, this should include employees who have a manager in a different city.

127
Mar 11
Find All Rows in A with a Matching Row in B
AskAI

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

95
Mar 10
Find all rows in Table A that have no matching row in Table B
AskAI

Write a SQL query to find all the rows in Table A that have no matching row in Table B.

111
Mar 10
Find the names of all customers who have purchased products with a price...
AskAI

This technical problem involves writing a SQL query to find the names of customers who have purchased products with a price greater than $10. The example input and output are provided.

120
Mar 10
Find Customers Who Have Placed an Order
AskAI

This technical problem asks the reader to write a SQL query to find customers who have placed at least one order, by joining the customers and orders tables. The expected output is a list of customer ids and names.

135
Mar 10