QL SERVER (SQL FUNCTION CHAPTER) QUERY help. Please use the data entity and attribute names on the diagram provided. Any help would be greatly appreciated!

1Write a SELECT statement that returns

-The Employee's full name

-Total number of orders assigned

-A column named OrderTotalByEmp that shows the total order amounts for each employee Round the result to 2 decimal places

2Write a SELECT statement that returns

The date of the order

-A column that returns the four-digit year thats stored in the date of order column

-A column that returns only the day of the month thats stored in the date of order column.

-A column that returns the result from adding thirty days to the date of order column.

The database is made with these names. This is the second time I'm posting this, please help, Thank you!

\begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ LOCATION } \\ \hline PK & LocationID \\ \hline & LocStreetNum \\ LocStreetName \\ LocCity \\ LocState \\ LocZip \\ LocEmail \\ LocPhone \\ CreatedDate \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ PROMOTION } \\ \hline PK & PromoCode \\ \hline & PromoDescription \\ StartDate \\ EndDate \\ Status \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ PAYMENT } \\ \hline PK & PaymentID \\ \hline & PaymentType \\ AccountNum \\ RoutingNum \\ CreditCardNum \\ CCExpDate \\ CCSecurityNum \\ Status \\ CreatedDate \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ PROMO_SVC } \\ \hline PK & PromeservID \\ \hline FK & ServicelD \\ FK & PromoCode \\ & CreatedDate \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ INVOICE } \\ \hline PK & InvoicelD \\ \hline FK & CustomerID \\ FK & OrderiD \\ FK & EmployeelD \\ & SubTotal \\ TaxAmount \\ TotalAmount \\ InvoiceDate \\ \hline \end{tabular} CellPhone Title DateOfHire