Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the Cash Receipt Table below to answer the following questions: Cash Receipt: Remittance Bank Customer Cashier Advice# Amount Account# Date Number Number RA-1 1,666

image text in transcribed
image text in transcribed
Use the Cash Receipt Table below to answer the following questions: Cash Receipt: Remittance Bank Customer Cashier Advice# Amount Account# Date Number Number RA-1 1,666 BA-6 25-May- C-2 EN-39 2020 RA-2 10,000 BA-7 C-3 EN-39 26-May- 2020 C-1 RA-3 72,000 BA-7 EN-39 15-JUNE- 2020 RA-4 32,600 BA-7 C-5 EN-39 16-JUNE- 2020 RA-5 1,669 BA-6 C-3 EN-39 25-JUNE- 2020 Requirements: First: show the output if the following SQL command is given: (5 marks) SELECT SUM (Amount) FROM [cash receipt) Where [Bank Account#] ='BA-7' Second: show the SQL command which will return the result table below. (6 marks) Remittance Bank Customer Cashier Advice# Amount Account# Date Number Number RA-3 72,000 BA-7 C-1 EN-39 15-JUNE- 2020 RA-4 32,600 BA-7 C-5 EN-39 16-JUNE- 2020 Third: show the SQL command required to query the total amount that occurred in June 2020. (7 marks) Fourth: show the SQL command required to query the total cash receipt amount from each customer. (7 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Business Reporting For Decision Making

Authors: Jacqueline Birt, Keryn Chalmers, Suzanne Maloney, Albie Brooks, Judy Oliver, David Bond

7th Edition

0730369323, 9780730369325

More Books

Students also viewed these Accounting questions