This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 27 points total) Inventory
ItemNo, Description, UnitCost, UnitPrice, QuantityOnHand, QuantityOrdered
PurchaseNo, PurchaseDate, PurchaseAmount, VendorNo, EmployeeNo
AccountNo, AccountType, Bank, Balance
CheckNo, PaymentAmount, PaymentDate, VendorNo, AccountNo, PurchaseNo, EmployeeNo
EmployeeNo, EmployeeName, Street, City, State, ZipCode, Telephone, HireDate Vendor
VendorNo, VendorName, VendorStreetAddress, VendorCity, VendorState, VendorZipCode
ItemNo, PurchaseNo, Quantity 18) Write a SQL query to find the average dollar value of all purchases made in January 2013.
(Note: January has 31 days.) (7 points)
Answer: SELECT AVG(PurchaseAmount)
WHERE PurchaseDate BETWEEN #1/1/2013# AND #1/31/2013#;
19) Write a SQL query to find the total dollar value of all payments made to each vendor in January 2013.
Also, include each vendor number, name, and city in the query results and show the query results with
the vendor cities listed in reverse alphabet...
View Full Document
This document was uploaded on 03/13/2014.
- Spring '14