Q5. Write a query to show the average balance for each customer. Hint: There will be three rows.

Q6. Write a query to show the average balance for each month. Hint: there will be 4 rows.

\begin{tabular}{|l|r|r|} \hline customerid & bankbalance & date \\ \hline c1 & $9,621.86 & 1/1/2018 \\ \hline c1 & $10,132.91 & 2/1/2018 \\ \hline c1 & $25,600.17 & 3/1/2018 \\ \hline c1 & $37,762.52 & 4/1/2018 \\ \hline c2 & $9,577.84 & 1/1/2018 \\ \hline c2 & $7,448.38 & 2/1/2018 \\ \hline c2 & $7,392.74 & 3/1/2018 \\ \hline c2 & $4,010.90 & 4/1/2018 \\ \hline c3 & $3,714.63 & 1/1/2018 \\ \hline c3 & $291.32 & 2/1/2018 \\ \hline c3 & $4,594.63 & 3/1/2018 \\ \hline c3 & $2,411.88 & 4/1/2018 \\ \hline \end{tabular}