I am trying to figure this stuff out can someone help? I am using SQL Server Management Studio and the AdeventureWorks2017 database thank you!

1. Display the JobTitle from the schema HumanResources table Employee table. Sort by JobTitle. (Do not allow duplicate job titles to display)

2. (Using INNER JOIN) Display FirstName, LastName, and JobTitle of every employee from the schema HumanResources table Employee table Joined with schema Person table Person. Sort by LastName. (Hint: Both tables use BusinessEntityID)

3. Modify the above query to only include employees with a JobTitle of Buyer.

4. Modify the above query to only include employees with a JobTitle of Account. (Hint: Youll need to use LIKE for comparison with a wildcard)

5. (Using LEFT OUTER JOIN) Modify the query you wrote in #4 to use a LEFT OUTER JOIN.

6. (Using RIGHT OUTER JOIN) Modify the query above to instead use a RIGHT OUTER JOIN.