Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For each sale with non-zero tax, list the saleID and saledate, tax, and shipping, as well as the total of the sale. This sale total

image text in transcribedFor each sale with non-zero tax, list the saleID and saledate, tax, and shipping, as well as the total of the sale. This sale total includes the quantity * saleprice of all the sale items on the sale plus the tax and shipping. Do this with a correlated subquery in the SELECT clause. Show data for February 2015. Name the new column "TotalSale".

Customer Sale Saleltem Product Manufacturer CustomerID SaleID OT SaleID ProductID ManufacturerlDO 0 FirstName SaleDate ProductD 01 ProductName ManufacturerName LastName CustomerID Item Size 0 ManufacturerID Address 1 Tax Quantity Composition Address2 StreetAddress City Shipping Sale Price ListPrice City State Gender State PostalCode PostalCode Category Country Employee Employeeld FirstName Phone O Color Phone Fax Description LastName Contact Address SalaryEmployee Employeeld Salary 0 URL City State ZIP Phone WageEmployee Employeeld 0 ManagerID Wage SSN MaxHours EmailAddress

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Dividend Investing

Authors: John Swing

1st Edition

1700003968, 978-1700003966

More Books

Students also viewed these Finance questions