1. Write a SELECT statement that returns these columns from the Instructors table: The monthly salary (the AnnualSalary

[answerhappygod]

1. Write a SELECT statement that returns these columns from the
Instructors table: The monthly
salary (the AnnualSalary column divided by 12)
A column that uses the CAST function to return the monthly salary
with 1 digit to the right of the
decimal point
A column that uses the CONVERT function to return the monthly
salary as an integer
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: The
EnrollmentDate column
A column that uses the CAST function to return the EnrollmentDate
column with its date only
(year, month, and day)
A column that uses the CAST function to return the EnrollmentDate
column with its full time
only (hour, minutes, seconds, and milliseconds)
A column that uses the CAST function to return the EnrollmentDate
column with just the year
and month