Question 6: In this exercise VCC payments funded to 3rd party who then processes those payments. The funding happens via an Outgoing Wire transaction from the same account as the SourceAccount for each payment on dbo.Payments. The Outgoing Wire in dbo.DailyBankData will be an aggregated amount of the PaymentAmount by SourceAccount and PaymentDate. How many payments from dbo.Payments were included in each Outgoing Wire, and how many unique OriginatingPaymentNumber records were included in each Outgoing Wire? Please include the following fields: BankDate, TransactionId, Account (DailyBankData), Amount (DailyBankData), Payments (number of payments), OriginatingPayments (number of unique Originating Payment Numbers Question 7: Using your query from Question 6, please build upon it to answer the following question. What are the PaymentNumbers and PaymentAmounts for the Outgoing Wire that cleared the bank on 3/5/2025? Please include the following fields: BankDate, TransactionId, Account (DailyBankData), Amount (DailyBankData), PaymentNumber, PaymentAmount
