Consider the above given schema,and write down the following SQL queries.

proper queries note proper screen shots clear

REGIONS DEPARTMENTS REGION ID REGION_NAME DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID COUNTRIES COUNTRY_ID COUNTRY_NAME REGION ID JOBS JODID 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_D 1. Show all the employees information ordered by first name (Ascending order). 2. Show all the employees information ordered by last name whose salary is in the range of 10,000 to 50,000. 3. What is the minimum salary given by department whose id is 90? 4. Which departments have location id greater than 1,000? 5. List the countriesname located in Europe and concatenation with country id. 6. List all the street addresses of Italy. 7. Display the highest, lowest, sum and average salary of all employees. Label the columns Maximum, Minimum, Sum and Average respectively. 8. Write a query that displays the difference between the highest and lowest salaries. Label the column difference. 9. Show all jobs title whose difference between minimum and maximum salaries is greater than average salary of all jobs. 10. Show name, and job title of all employees who reports directly to Steven