1. Write a SELECT statement that returns these columns from the Instructors table: a. The monthly salary (the AnnualSalary column divided by 12) b. A column that uses the CAST function to return the monthly salary with 1 digit to the right of the decimal point c. A column that uses the CONVERT function to return the monthly salary as an integer d. A column that uses the CAST function to return the monthly salary as an integer 2. Write a SELECT statement that returns these columns from the Students table: a. The EnrollmentDate column A column that uses the CAST function to return the EnrollmentDate column with its date only (year, month, and day) b. A column that uses the CAST function to return the EnrollmentDate column with its full time only (hour, minutes, seconds, and milliseconds) c. A column that uses the CAST function to return the EnrollmentDate column with just the year and month 3. Write a SELECT statement that returns these columns from the Instructors table: a. The AnnualSalary column b. A column named MonthlySalary that is the result of dividing the AnnualSalary column by 12 c. A column named MonthlySalary Rounded that calculates the monthly salary and then uses the ROUND function to round the result to 2 decimal places 4. Write a SELECT statement that returns these columns from the Students table: a. The EnrollmentDate column A column that returns the four-digit year that's stored in the EnrollmentDate column b. A column that returns only the day of the month that's stored in the EnrollmentDate column c. A column that returns the result from adding four years to the EnrollmentDate column; use the CAST function so only the year is returned 5. Write a SELECT statement that returns these columns: a. The DepartmentName column from the Departments table b. The CourseNumber column from the Courses table c. The FirstName column from the Instructors table d. The Last Name column from the Instructors table e. Add a column that includes the first three characters from the DepartmentName column in uppercase, concatenated with the CourseNumber column, the first character of the FirstName column if this column isn't null or an empty string otherwise, and the LastName column. For this to work, you will need to cast the Course Number column to a character column.