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

NOTE : PROPER CMD SCREEN SHOTS

REGIONS REGION ID REGION_NAME DEPARTMENTS DEPARTMENT_ID DEPARTMENT NAME MANAGER_ID LOCATION_ID COUNTRIES COUNTRY ID COUNTRY_NAME REGION_ID JOBS 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 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