Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Cash Receipt Table: Remittance Advice# Bank Account# Customer Number Cashier Number Amount Date RA-1 1,666 BA-6 25-JUL-2014 IC-2 E-39 RA-2 10,000 BA-7 26-JUL-2014 C-2

image text in transcribed
1. Cash Receipt Table: Remittance Advice# Bank Account# Customer Number Cashier Number Amount Date RA-1 1,666 BA-6 25-JUL-2014 IC-2 E-39 RA-2 10,000 BA-7 26-JUL-2014 C-2 E-39 RA-3 72,000 BA-7 15-AUG-2014 IC-1 E-39 RA-4 32,600 BA-7 15-AUG-2014 C-5 E-39 RA-5 1,669 BA-6 25-AUG-2014 C-2 E-39 Using the Cash Receipt Table above, show the output if the following SQL command is given: SELECT SUM (Amount) FROM [Cash Receipt] Where (Customer Number] ='C-2'; Answer: 2. Using the Cash Receipt Table in the previous question, show the SQL command which will return the result table below. Remittance Bank Amount Advice# "Account Date Customer Cashier Number Number RA-3 72,000 BA-7 15-AUG-2014 C-1 E-39 RA-4 32,600 BA-7 15-AUG-2014 C-5 E-39

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_2

Step: 3

blur-text-image_3

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

Auditing A Risk Based-Approach

Authors: Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg

11th Edition

1337619455, 1337619450, 9781337670203 , 978-1337619455

More Books

Students also viewed these Accounting questions

Question

3 When is it a good idea to use the internal supply of labour?

Answered: 1 week ago

Question

5 What are the main aims of talent management?

Answered: 1 week ago