Question $2$

A client requested a query for a dashboard in their online banking web service. It should ret the count and the sum of transaction amounts for each customer in the current month.

The result should have the following columns: iban $/$ transactions $/$ total.

iban$-$account IBAN

transactions $-$ total number of transactions

total$-$ the sum of the transaction amounts

The result should be sorted in descending order by total.

Note: