SQL Question

1.Your accounting department needs to know the total amount ordered for each product in the Guitar Shop. They want a report with the products name and the total dollar amount for each product.

2. During a meeting you are asked to find out which customers have ordered more than one product. Create a query that returns the email address and the number of distinct products from the customers orders.

Vendors VendorlD VendorAddress1 VendorAddress2 VendorCity VendorZipCode DefaultTermsID GLAccounts AccountNo Invoices ! InvoiceID VendorID Terms 9 TermslD InvoiceTotal PaymentTotal CreditTotal TermsID InvoiceLineltems Te InvoicelD InvoiceSequence InvoiceLineltemAmount