?Based on the ERD below, create the following query: a . ?Display customer data who have purchased
Fantastic news! We've Found the answer you've been seeking!
Question:
?Based on the ERD below, create the following query:
a ?Display customer data who have purchased products with the name
product must have at least ?words and start with the letter A
b ?Display customer data along with the total number of x transactions they have made
do it sorted by the most transactions
c ?Create a trigger to add new customer data every time there is one
sales transactions from new customers that are not yet in the customer table
d ?Show data on the ?most expensive products ever purchased by customers
Odd customer IDs using NESTED QuerySALES ORDER
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: