Homework: LL Road Frame
For this homework, continue to operate in the role of data analyst at Adventure Works Cycles company. Based on the "LL Road Frame-Black 60" scenario and questions formulated for the Topic 3 homework, write queries for the AdventureWorks database using Microsoft SQL Server.
Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy.
Create a Microsoft Word document that includes the SQL queries used to explore the database tables, and answer the following questions.
A. Find the product ID for the LL Road Frame - Black 60.
B. Find the listing prices for the LL Road Frame Black 60. Include the ProductID, EndDate, and ListPrice.
C. How would you rewrite the query used in question B to exclude NULL values?
D. How many orders have been placed for LL Road Frame - Black 60?
Format your homework according to the give formatting requirements:
1. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.