Data
Is a given string a permutation of a palindrome?
AskAI
This problem asks whether a given string is a permutation of a palindrome. A palindrome is a word or phrase that is the same forwards and backwards, while a permutation is a rearrangement of letters. The problem can be solved by checking whether the string has an even number of each letter (excluding letters with an even number of occurrences) and at most one letter with an odd number of occurrences.
SQL Query to Find Customers Who Have Placed Orders Totaling More Than $100
AskAI
This problem asks the user to write a SQL query to find the names of customers who have placed orders totaling more than $100. The input is two tables, one for customers and one for orders. The output should be a list of customer names.
Find the sum of the elements in an array of integers.
AskAI
To find the sum of the elements in an array of integers, simply add all the numbers together. In the example given, the sum would be 1 + 2 + 3 + 4, or 10.
Joining Two Tables on the id Column
AskAI
Write a SQL query to join two tables on the id column.
Finding Employees Who Work in the Sales Department
AskAI
Given two tables - "Employees" and "Departments" - write a SQL query to find the names of all employees who work in the "Sales" department.
Is t an anagram of s?
AskAI
This problem asks whether one string (t) is an anagram of another string (s). An anagram is a word, phrase, or name formed by rearranging the letters of another , such as cinema, formed from iceman.
Find the Maximum Sum of a Contiguous Subarray of integers
AskAI
Given an array of n integers, this problem seeks to find the maximum sum of any contiguous subarray within the array. For example, given the array [2, -1, 3, 4, -5], the maximum sum would be 7, since the contiguous subarray [3, 4] has the largest sum.
Find the name and grade of students who are enrolled in at least one course.
AskAI
This technical problem involves writing a SQL query to find the name and grade of students who are enrolled in at least one course. The input is two tables - students and courses - and the output is the id, name, and grade of the students.
