Noteseptemberhas30days 19

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: rsement CheckNo, Amount, CheckDate, AccountNo, EmployeeNo, VendorNo Employee EmployeeNo, Name, SSN, Position, Address, City, State, Zip, Tel Service ServiceNo, ServiceType, Description ServiceAcquisition AcquisitionNo, AcquisitionDate, AcquisitionCost, ServiceNo, EmployeeNo, VendorNo Vendor VendorNo, VendorName, VendorAddress, VendorCity, VendorState, VendorZip, VendorTel ServiceAcquisition_CashDisbursement 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.

Ask a homework question - tutors are online