Given two tables, Table A and Table B, write a SQL query to find all the rows in Table A that have matching values in Table B. Output should be Table A with only the rows that have matching values in Table B.

202

Mar 09
Given an array of n integers, find the contiguous subarray of given length k that has the maximum average value. Output the maximum average value.

231

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

198

Mar 09
This technical problem involves joining two tables in order to find all of the fruits that have been eaten by either John or Jane.

215

Mar 09
To find the minimum value in an array of integers, we can simply compare each value in the array to the others and keep track of the smallest value we've seen so far.

220

Mar 08
To find all employees who work in the Sales department, we can join the Employees and Departments tables on the department_id column.

201

Mar 08
This technical problem involves using SQL to find the intersection of two tables. In other words, the goal is to find all rows from both tables that have matching values in the specified columns.

214

Mar 08
Given two tables, write a SQL query to find all the rows in the first table that have a corresponding row in the second table.

191

Mar 08