Data
Find all rows in A that are also in B
AskAI
To find all the rows in table A that are also in table B, write a SQL query that uses a JOIN clause.
SQL Query to Find Pairs of Rows from Two Tables
AskAI
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.
Longest Palindromic Substring
AskAI
Write a function that returns the length of the longest palindromic substring in a given string of characters.
Find the Length of the Longest Increasing Subsequence in an Array
AskAI
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.
Maximum Sum of Contiguous Subarray
AskAI
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].
Customers Who Have Purchased Products With a Price Greater Than $100
AskAI
This technical problem involves writing a SQL query to find the names of customers who have purchased products with a price greater than $100.
Find all rows from table A that have a matching row in table B
AskAI
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.
Sum of Array Elements
AskAI
Given an array of integers, this function will return the sum of the elements in the array.
