Retrieving Information From Adventure Works Use your AdventureWorks database to complete these exercises. 19. List the JobTitles for all supervisors. Include each title only once. Answer #20 Paste your entire query into Word. Be sure to keep the color-coding. Use the Snipping Tool to capture the Results area of your query. Paste it into your Word document. 20. List the BusinessEntityID, Person Type, FirstName, MiddleName, and LastName of all the people (Person.Person) whose last name starts with an X and whose first name starts with an E or an I or a N and contains exactly 5 characters. Do not include the people who have a NULL for the MiddleName. Answer #21 Paste your entire query into Word. Be sure to keep the color-coding. Use the Snipping Tool to capture the Results area of your query. Paste it into your Word document. 21. List the ProductID and Name of all the products (Production. Product) that are blue bicycle frames. Answer #22 Paste your entire query into Word. Be sure to keep the color-coding. Use the Snipping Tool to capture the Results area of your query. Paste it into your Word document. 22. List the SalesOrderID, OrderDate, customerID, SubTotal, TotalDue from the Sales.SalesOrderHeader table for the following orders: 63408, 63451, 63520, 63599,63655, 637210 Answer #23 Paste your entire query into Word. Be sure to keep the color-coding. Use the Snipping Tool to capture the Results area of your query. Paste it into your Word document.