Unformatted text preview: rsement
CheckNo, Amount, CheckDate, AccountNo, EmployeeNo, VendorNo
EmployeeNo, Name, SSN, Position, Address, City, State, Zip, Tel
ServiceNo, ServiceType, Description
AcquisitionNo, AcquisitionDate, AcquisitionCost, ServiceNo, EmployeeNo, VendorNo
VendorNo, VendorName, VendorAddress, VendorCity, VendorState, VendorZip, VendorTel
AcquisitionNo, CheckNo, DiscountReceived 18) Write a SQL query to calculate the total dollar amount and average dollar amount of all cash
disbursement in September 2010. (Note: September has 30 days.) 19) Write a SQL query to show employee name and the total acquisition cost of all services acquired by each
employee from Gilbert, Iowa in August 2010. (Note:August has 31 days.) 20) Write a SQL query to...
View Full Document
This document was uploaded on 03/13/2014.
- Spring '14