Write a select statement that returns these columns - write


Question 1: Write a SELECT statement that returns these columns;

The counts of the number of orders in the Orders table

The sum of the TaxAmount columns in the Ordeers table.

Question 2: Write a SELECT statement that returns one row for each customer that has orders with these columns.

The EmailAddress column from the customer table.

The sum of the item price in the OrderItems table multiplied by the quantity in the OrderItems table

The sum of the discount amount column in the OrderItem table multipled by the quantity in the OrderItems Table

Question 3: Write a SELECT statement that answers this question: Which customers have ordered more that one product? Return columns:

The email address from customers table

The count of distinct products d from the customer's orders

I cannot seem to get this to work for some reason could somebody provide me a code to compare and test?

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Write a select statement that returns these columns - write
Reference No:- TGS0952709

Expected delivery within 24 Hours