Creating a Calculated Column Using a Function

Create a table from the employee$\_$donations table with a new column that indicates the total

contributions from each employee. Open the employee$\_$donations table.

a$.$ Write a program to create a table named donations.

b$.$ Include the Employee$\_$ID$,$ Recipients, and Paid$\_$By columns in the new table.

c$.$ Create a new column named Total$\_$Donations, which totals the values of the four quarterly

donations. Format the new column to display dollar signs, commas, and two decimal places.

Use a function to calculate the total, thereby ignore any missing values that might be in

the input columns. Hin: the function is sum

d$.$ Run the program.

e$.$ Save the program as Donations, provide the code and the result screenshot.