This technical problem involves writing a SQL query to return all customers who have made a purchase in the last 30 days, as well as the total amount they have spent.

81

Nov 27
Given a table of transactions, this SQL query will find the total value of all transactions that occurred on each day.

74

Nov 25
To find the second highest salary from a SQL database, you can use a subquery. This subquery will return the salary of the employee with the second highest salary.

65

Nov 19
Given a table of transactions, this SQL query will find the total value of all transactions for each day.

71

Nov 18
This technical problem involves writing a function that takes a string and a character as arguments, and returns the number of times the character appears in the string.

83

Nov 11
This problem asks for a SQL query that returns the average transaction value for each day. The example input table has three days, with transaction values of 10, 20, and 30 respectively. The expected output table would have the same three days, with average values of 10, 15, and 20.

144

Nov 10
Write a SQL query to find all products in a table that cost more than $10.

104

Nov 10
Write a SQL query to find the 10 most popular articles on a blog, based on the number of likes.

102

Nov 09