Data
Maximum sum contiguous subarray of length k
AskAI
This problem asks you to find the contiguous subarray of length k that has the maximum sum. You are given an array of n integers, and your goal is to find the subarray that maximizes the sum.
Find Customers Who Have Placed Orders Worth More Than $100
AskAI
SQL query to find customers who have placed orders worth more than $100.
Check if Two Strings are Permutations
AskAI
This problem is about determining whether two strings are permutations of each other. A permutation is a rearrangement of the letters in a string. So, if string1 is "abc " and string2 is "bac", then string2 is a permutation of string1.
Group Anagrams
AskAI
Given an array of strings, the goal is to group together all the strings that are anagrams of each other. For example, the input array ["eat", "tea", " tan", "ate", "nat", "bat"] would return [["ate", "eat", "tea"], ["nat", "tan"], ["bat"]].
SQL: Finding Rows in Table A with Corresponding Rows in Table B
AskAI
Write a SQL query to find all the rows from Table A that have a corresponding row in Table B.
SQL query to find customers who have placed orders over $100
AskAI
This technical problem involves writing a SQL query to find the names of customers who have placed orders with a total value greater than $100.
Return all rows from A and B where the value in column A is greater than the...
AskAI
This technical problem deals with returning all rows from two tables, A and B, where the value in column A is greater than the value in column B. An example input and output is given .
Finding Students Who Take At Least One Course
AskAI
This technical problem involves using SQL to find the names of students who are taking at least one course. The input consists of two tables, students and courses, and the output is a list of the names of the students who are taking at least one course.
