Corrections in Question:4 from todays practice queries...

[Swapnil Shah]

 

4.       Create a view called SalesView that will contain the facility name, product name, facilityProductID, bill number, line item number, sale price, units sold, date of sale, customer name, type of sale,  Payment method and shipping charge and ship date.

Thanks,

 

Swapnil Shah

California Creative Solutions, Inc.
13475 Danielson Street Suite 220 | Poway CA 92064
phone: 858-208-4131 ext 4535 | fax: 858-683-2427

 ss...@ccsglobaltech.com| www.ccsglobaltech.com

Certified Minority Business Enterprise (MBE)