Complete to following in Microsoft SQL:

NOTE: The other answers to this same question are wrong, please provide a new, correct answer! Thank You! I will be sure to upvote if correct!

1. Alter your student table adding a new column called enroll_date using the datetime data type. 2. Populate the new column (enroll_date) with the current date and time. 3. Using your student table return the student first and last names concatenated with a space and then the enroll_date minus one month. Here is an example of the output: 1. Using your student table return the month name for the enroll_date column. For example, if the enroll_date was 11-6-2019 then the month name would be June