[Solved]-Q1 Write Sql Code Generate Second Table First Table Remittance Advice Ra 1 Ra 2 Ra 3 Ra 4 Q37225755

Q1. Write the SQL Code that will generate the second table from the first table ( Remittance Advice# RA-1 RA-2 RA-3 RA-4 RA-5 Bank Customer Cashier Number Number Amount Account#Date 1,666 BA-6 25-JUL-2014 C-2 10,000 BA-7 26-JUL-2014C-2 72,000BA-715-AUG-2014 C1 32,600 BA-7 1 E-39 E-39 E-39 E-39 15-AUG-2014 C-5 1.669 BA-6 25-AUG-2014 C2 E39 1,669 Remittance Advice# Bank Customer Cashier N Amount Account# Date 72,000 BA-7 32,600 BA-7 15-AUG-201 umberNumber -3 15-AUG-2014 1 . E-39 4 5 E-39 .4 Show transcribed image text Q1. Write the SQL Code that will generate the second table from the first table ( Remittance Advice# RA-1 RA-2 RA-3 RA-4 RA-5 Bank Customer Cashier Number Number Amount Account#Date 1,666 BA-6 25-JUL-2014 C-2 10,000 BA-7 26-JUL-2014C-2 72,000BA-715-AUG-2014 C1 32,600 BA-7 1 E-39 E-39 E-39 E-39 15-AUG-2014 C-5 1.669 BA-6 25-AUG-2014 C2 E39 1,669
Remittance Advice# Bank Customer Cashier N Amount Account# Date 72,000 BA-7 32,600 BA-7 15-AUG-201 umberNumber -3 15-AUG-2014 1 . E-39 4 5 E-39 .4

Expert Answer

---

Answer to Q1. Write the SQL Code that will generate the second table from the first table ( Remittance Advice# RA-1 RA-2 RA-3 RA-4… . . .