Recent posts
SQL Query to Find Most Common First Name
AskAI
SQL Problems
To find the most common first name in a table of user data, write a SQL query that groups the data by first name and orders the results by the number of occurrences.
Database Backup
AskAI
SQL Problems
This technical problem describes how to create a backup of a database by creating a new database with the same structure and copying the data from the original tables into the new tables. The function should return the name of the new database.
"Finding the Three Most Expensive Products"
AskAI
SQL Problems
This technical problem asks the user to write a SQL query to find the three most expensive products from a given table. The table includes columns for product ID, name, and price. An example input and output is provided.
Finding the Total Amount Spent by Each Customer
AskAI
SQL Problems
Given a list of customer names and their purchase amounts, this SQL query will find the total amount spent by each customer.
Write a stored procedure to calculate the number of days between two dates.
AskAI
SQL Problems
This stored procedure calculates the number of days between two dates.
Sort table by id column in ascending order
AskAI
SQL Problems
The table has two columns, id and data. The query should return the data in ascending order of id.
SQL Query to Find Users with a Valid Email Address
AskAI
SQL Problems
This problem asks for a SQL query to find all users in a table who have a valid email address.
Online product database
AskAI
SQL Problems
The company needs a database to store information about the products, customers, and orders. The database should be able to track the quantity of products in stock and customer information so that the company can email customers updates about their orders.