## Joining Tables

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

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.

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

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.

214
Mar 11
##### Finding all matching pairs of rows from two tables

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.

185
Mar 11
##### Find all employees who live in the same city as their manager.

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.

207
Mar 11
##### Find All Rows in A with a Matching Row in B

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

156
Mar 10
##### Find all rows in Table A that have no matching row in Table B

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

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

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.

202
Mar 10
##### Find Customers Who Have Placed an Order

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.

200
Mar 10