Consider the above given schema and writedown following SQL queries.

Consider the above given schema and writedown following SQL queries. 7.Display the manager idand the salary of the lowest and highestpaid employee for that manager. 1.Display the highest, lowest, sum and average salary of all employees. Label the columns 3.Modify the first query to display the highest, lowest, sum and average salaryagainsteach 6.Write a query to display the number of employeeswith the same job. 8.Display country idof countries inwhich total number of cities are 5or more. 2.Modify the first query to display the highest, lowest, sum and average salaryfor each job. 4.Showalldepartment Idwhose average salary exceeds 5000. Maximum, Minimum, Sum and Average respectively. department. 9.Display all job_id and job_titleof all those jobswhose minimum salary is same. 5.Display all department Idwhose total salary is in the range of 5000 to 50,000 10.Display region _id inwhich the total number of counties is greater than 5. (NOTE PROPER SCREEN SHOT CLEAR)

REGIONS REGION ID REGION_NAME DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID JOBS COUNTRIES COUNTRY_ID COUNTRY_NAME REGION_ID JOB ID JOB_TITLE MIN SALARY MAX_SALARY EMPLOYEES EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID -DEPARTMENT_ID LOCATIONS LOCATION ID STREET_ADDRESS POSTAL CODE CITY STATE_PROVINCE COUNTRY_ID JOB_HISTORY EMPLOYEE_ID START-DATE END_DATE -JOB_ID DEPARTMENT_ID