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.

187
Oct 17
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.

165
Oct 16
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.

196
Oct 16
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.

190
Oct 14
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.

186
Oct 11
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.

199
Oct 10