Data
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.
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.
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.
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.
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.
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.
Longest Increasing Subsequence in an Array
AskAI
Given an array of integers, this problem looks for the longest increasing subsequence within that array.
