Databases
Find Customers Who Have Purchased Products from Both Tables
AskAI
Given two tables, this problem finds the names of customers who have purchased products from both table 1 and table 2.
SQL Query to Find Users with a Valid Email Address
AskAI
This problem asks for a SQL query to find all users in a table who have a valid email address.
Online product database
AskAI
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.
Printing employee names and salaries from a table
AskAI
This problem deals with using a cursor to loop through a table of employee data in order to print the employee's name and salary.
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 that occurred on each day.
Find Top 10 Customers by Total Purchase Amount
AskAI
To find the top 10 customers by total purchase amount, write a SQL query that orders the customers by purchase_amount in descending order.
