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 solutionChapter 4 Solutions
EBK ACCOUNTING INFORMATION SYSTEMS
- The following data were taken from the records of Splish Brothers Company for the fiscal year ended June 30, 2025. Raw Materials Inventory 7/1/24 $58,100 Accounts Receivable $28,000 Raw Materials Inventory 6/30/25 46,600 Factory Insurance 4,800 Finished Goods Inventory 7/1/24 Finished Goods Inventory 6/30/25 99,700 Factory Machinery Depreciation 17,100 21,900 Factory Utilities 29,400 Work in Process Inventory 7/1/24 21,200 Office Utilities Expense 9,350 Work in Process Inventory 6/30/25 29,400 Sales Revenue 560,500 Direct Labor 147,550 Sales Discounts 4,700 Indirect Labor 25,360 Factory Manager's Salary 63,400 Factory Property Taxes 9,910 Factory Repairs 2,500 Raw Materials Purchases 97,300 Cash 39,200 SPLISH BROTHERS COMPANY Income Statement (Partial) $arrow_forwardNo AIarrow_forwardL.L. Bean operates two factories that produce its popular Bean boots (also known as "duck boots") in its home state of Maine. Since L.L. Bean prides itself on manufacturing its boots in Maine and not outsourcing, backorders for its boots can be high. In 2014, L.L. Bean sold about 450,000 pairs of the boots. At one point during 2014, it had a backorder level of about 100,000 pairs of boots. L.L. Bean can manufacture about 2,200 pairs of its duck boots each day with its factories running 24/7.In 2015, L.L. Bean expects to sell more than 500,000 pairs of its duck boots. As of late November 2015, the backorder quantity for Bean Boots was estimated to be about 50,000 pairs. Question: Assume that a pair of 8" Bean Boots are ordered on December 3, 2015. The order price is $109. The sales tax rate in the state in which the boots are order is 7%. L.L. Bean ships the boots on January 29, 2016. Assume same-day shipping for the sake of simplicity. On what day would L.L. Bean recognize the…arrow_forward
- 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:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education