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?