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.
- Find the product ID for the LL Road Frame – Black 60.
- Find the listing prices for the LL Road Frame Black 60. Include the ProductID, EndDate, and ListPrice.
- How would you rewrite the query used in question 2 to exclude NULL values?
- How many orders have been placed for LL Road Frame – Black 60?
- Rename the OrderQty to Quantity in your results.