Q$.$Write a SQL query to select information from the Sales table. Sales table has following attributes:

$($Sales$\_$No$,$ Product$\_$name, Branch, Sales$\_$ amount,salesperson$\_$name, DOB$)$

Calculate total sales amount in each branch.

Calculate the average sales amount in each branch.

Display all the salesmen, DOB who are born in the month of December as day in character format i$.$e$.$ YYYY$-$MM$-$DD$.$

Display the name and DOB of salesman in alphabetical order of the month

Instruction

$\mathrm{.}1.$Write a SQL query to calculate the total sales amount for each branch $.$ The query should;

Sum the sales amount from the sales table.

Group the results by branch id and branch to get the total$\_$sales for each branch.

The output should include the branch$\_$id and branch and the corresponding total$\_$sales

$2.$ Write a SQL query to calculate the average sales amount for each branch. The query should:

Calculate the average of the sales$\_$amount from the sales table.

Group the results by branch$\_$id and Branch to get the average$\_$sales for each branch.

The output should include the branch$\_$Id and Branch and the corresponding average$\_$sales$\mathrm{.}3.$ Witte a SQL query to retrieve the name and date$\_$of$\_$birth of all salesmen born in December. The query should :

Select the name and date of birth columns from the salesmen table.

Filter the results to Include only those salesmen whose date$\_$of$\_$birth falls in the month of December.