Answered step by step
Verified Expert Solution
Question
1 Approved Answer
WRITE THE SQL FOR THE FOLLOWING: 1.List the customers (customer id, last name, first name) who have more than 1 order. 2.List the customers (customer
WRITE THE SQL FOR THE FOLLOWING:
1.List the customers (customer id, last name, first name) who have more than 1 order.
2.List the customers (customer id, last name, first name) who have ordered at least one computer book.
3.List the publishing years (from BOOKS) and the number of books published in each year.
4.Calculate the total revenue from all ordered books.
Note: ORDERITEMS table holds data about each Order Item (book ISBN), quantity, and the price paid for each book.
5.How many different books have not been ordered?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started