Sql

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.

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

137
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.

161
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.

162
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.

158
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.

175
Oct 10