Reference no: EM131587558

Create and run the following queries:

1. Select all rows and all columns from the Departments table.
2. Select all rows and only the FirstName, MiddleName, and LastName columns from the Employees table. Your columns are to be ordered FirstName, MiddleName, and LastName.
3. Select all rows and only the FirstName and LastName from the Employees table. Use column aliases to have the resulting column headings as First Name, Middle Name, and Last Name.
4. Select all columns from the Employees table and only the rows where the StartDate is since 1/1/2000.
5. Select all columns from the Employees table and only the rows where the StartDate is since 1/1/2000 and the annual salary is less than $75,000.
6. Select all columns and all rows from the Employees table, but display an additional column called 'Raise to' which will be the current salary multiplied by 1.0267. Do not modify the table data.
7. Modify the previous query to order by Salary in descending order.
8. Modify the previous query to order by Salary in ascending order.