Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. 1. cash receipt table: remittance advice# bank acc

1. Cash Receipt Table: Remittance Advice# Bank Account# Customer Number Cashier Number Amount Date RA-1...

90.2K

Verified Solution

Question

Accounting

image
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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students