To find all the rows in table A that are also in table B, write a SQL query that uses a JOIN clause.

214

Mar 13
This technical problem deals with finding pairs of rows from two tables, such that the values in column a of table A are less than the values in column b of table B, and the values in column b of table A are greater than the values in column a of table B.

212

Mar 12
Write a function that returns the length of the longest palindromic substring in a given string of characters.

221

Mar 12
Given an array of integers, this problem asks you to find the length of the longest increasing subsequence in the array. For example, given the array [10,9,2,5 ,3,7,101,18], the longest increasing subsequence is [2,3,7,101], so the answer would be 4.

209

Mar 12
Given an array of integers, the maximum sum of any contiguous subarray of the array can be found by summing the subarray. In the example given, the maximum sum is 137, obtained by summing the subarray [42, 14, -5, 86].

208

Mar 12
This technical problem involves writing a SQL query to find the names of customers who have purchased products with a price greater than $100.

208

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

228

Mar 12
Given an array of integers, this function will return the sum of the elements in the array.

205

Mar 12