a.
Write a query to display the customers who made purchases from M. M.
b.
Write a query to display the individual with the largest credit limit.
c.
Write a query to display the number of sales made in the month of October.
d.
Write a query to display the item numbers, price, and quantity of each item that were sold on invoice number 103.
e.
Write a query to display the volume sold by each salesperson.
f.
Write a query to display the customers who live in Country A.
g.
Write a query to display the amount of credit each customer still have available.
h.
Write a query to display each item that were sold.
i.
Write a query to display the customers who have more than $1,000 in available credit.
j.
Write a query to display the items that are in hand at least by 100 units.
Want to see the full answer?
Check out a sample textbook solution
Chapter 4 Solutions
Accounting Information Systems (14th Edition)
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education