Question: 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

 1. Cash Receipt Table: Remittance Advice# Bank Account# Customer Number Cashier

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!