Creating a New Column by Recoding Ranges of Values

Write a program to create a new column that groups salary values into four categories. Name the new

column Salary$\_$Range. Recall that Salary is in table employees$\_$payroll.

a$.$ Create a table named Salary$\_$Range.

b$.$ Include only the Employee$\_$ID$,$ Salary, and Employee$\_$Hire$\_$Date columns. Format

Employee$\_$Hire$\_$Date with the DDMMYY$.$ format so that dates appear as $20/10/2008.($Hint:

format column$\_$name DDMMYY$10.)$

c$.$ Create a new column named Salary$\_$Range based on the values in the Salary column.

a$.$ Run the program. Save the program as SalaryRange. provide the code and the result

screenshot.