To put himself through school, Zach operates an ice cream truck that travels through neighborhoods, ringing a bell to attract kids that want a cold ice cream treat. Zach's inventory includes many ice cream products and he tracks which items are sold in each sale. He occasionally adds new items to his list of ice cream products for sale. Zach only accepts cash for each sale. To identify the routes that generate the most sales, Zach summarizes sales by neighborhood but he only tracks neighborhoods with at least one sale. Zach deposits the cash received in his bank account at the end of each day. (Hint: There is only one agent for this diagram - Neighbor) Using the Cash Receipt Table below, write the SQL that show the output of total cash payments from Customer 'C-2' (hint: use the sum () function- Cash Receipt: BA-6 Remittance Advice# RA-1 RA-2 RA-3 RA-4 RA-5 Bank Amount Account# 1,666 10,000 BA-7 72,000 BA-7 32,600 BA-7 1,669 BA-6 Date 25-JUL-2014 26-JUL-2014 15-AUG-2014 15-AUG-2014 25-AUG-2014 Customer Cashier Number Number C-2 E-39 C-2 E-39 C-1 E-39 C-5 E-39 C-2 E-39 To put himself through school, Zach operates an ice cream truck that travels through neighborhoods, ringing a bell to attract kids that want a cold ice cream treat. Zach's inventory includes many ice cream products and he tracks which items are sold in each sale. He occasionally adds new items to his list of ice cream products for sale. Zach only accepts cash for each sale. To identify the routes that generate the most sales, Zach summarizes sales by neighborhood but he only tracks neighborhoods with at least one sale. Zach deposits the cash received in his bank account at the end of each day. (Hint: There is only one agent for this diagram - Neighbor) Using the Cash Receipt Table below, write the SQL that show the output of total cash payments from Customer 'C-2' (hint: use the sum () function- Cash Receipt: BA-6 Remittance Advice# RA-1 RA-2 RA-3 RA-4 RA-5 Bank Amount Account# 1,666 10,000 BA-7 72,000 BA-7 32,600 BA-7 1,669 BA-6 Date 25-JUL-2014 26-JUL-2014 15-AUG-2014 15-AUG-2014 25-AUG-2014 Customer Cashier Number Number C-2 E-39 C-2 E-39 C-1 E-39 C-5 E-39 C-2 E-39