SQL queries needed in MS_SQL 2012

Use the AdventureWorks2012 database. Please remember saving all your scripts in a Word or Notepad file and save the file in your MyFiles folder when using your virtual machine in Toolwire. Include in your document a well-formatted screen of each query displaying the Object Explorer, the T-SQL code inside the query editor window, the Results pane, the number of rows returned, and the actual T-SQL code at the top of the display. See example below. . Display all those employees holding a Manager’s job title and their hire dates. Include the First and Last Name, the job title, and the hire date. 2. How many hours of vacation has all non-managers employees accrued? Display the column as Accumulated Vacation Hours by non-managers. 3. As of this date, what is the name of the oldest person? Include his or her age, person name, phone number, and title. NOTE: Just display the name of the oldest person. Unit 9 [IT234: Database Foundations] 3 NOTE: Use The AdventureWorks2012 database and the SalesPerson(Sales)- Employee(HumanResources) schema located in Doc Sharing for answering questions 4 and 5: 4. Create a new table named demoSalesPerson that copies all the records from the SalesPerson(Sales) table. Include in your screenshot the code that you used for creating the table, the new table in Object Explorer (may need to Refresh the database), and a select statement showing (at least partially) all columns and some of the rows, AND the number of records. 5. Update the Commission percentage to two percent in demoSalesPerson in TerritoryID 6. Display the new commission and the territory. Include the T-SQL that you used for updating the commission in the demoSalesPerson table. 6. Choose two tables from the AdventureWorks2012 database and create a meaningful OUTER JOIN (RIGHT or LEFT). Include in your result the columns, the T-SQL statement, Object Explorer, number of returned rows, and the rationale you had about the usefulness of the OUTER JOIN for a business. Remember to always include the T-SQL statements at the top outside each screenshot.