Transactions

Customers who have made a purchase in the last 30 days

AskAI

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.

164

AI Databases / SQL

Nov 27

Finding the Total Value of Transactions by Day

AskAI

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

136

AI Databases / SQL

Nov 25

Find the Second Highest Salary in a SQL Database

AskAI

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.

126

AI Databases / SQL

Nov 19

Find the total value of all transactions for each day.

AskAI

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

152

AI Databases / SQL

Nov 18

"Count the number of occurrences of a character in a string"

AskAI

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.

161

AI Databases / SQL

Nov 11

SQL Query for Average Transaction Value by Day

AskAI

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.

223

AI Databases / SQL

Nov 10