Old MathJax webview

Old MathJax webview

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

CMD COMMANDS SCREEN SHOT

7.1.Practice Task 1 [Expected time = 40mins] Consider the above given schema, and write down the following SQL queries. 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