Problem $02$: Profitability based Views

$(10$ points$)$

Create queries to create views capturing the given scenarios.

a$.$ Top account from each branch based on volume of transactions for the month.

Fields required:

i$.$ Branch

ii$.$ Account Number

iii. Client Name who owns the account

iv$.$ Type of Account

v$.$ Number of transactions $($volume$)$

vi$.$ Value of transactions.

b$.$ Total weekly transactions on each channel for the month for both debit and credit transactions.

Fields required:

i$.$ Week Number

ii$.$ Channel

iii. No$.$ of Debit Transactions

iv$.$ No$.$ of Credit Transactions