(SQL Coding)
Create a READ ONLY view called: VIEW_EMP_SAL_INFO
Calculate the following: The minimum,average, maximum, and sum of all salaries, and a count to show therecords used. Have the calculations grouped by department name.(You will need to join with the departments table.) Round thefunctions to two decimal points. Give the read only constraint thename of vw_emp_sal_info_readonly.
Expert Answer
Answer to (SQL Coding) Create a READ ONLY view called: VIEW_EMP_SAL_INFO Calculate the following: The minimum, average, maximum, a…