Display Work orders with stocked quantity less than . Then another query to display work orders with stock quantity between 10 and 15
Part I
Draw Entity Relationship diagram for Adventure Works database.
Part II
Write SELECT statements for the following questions:
For each of these statements, include a screenshot of the SQL statements and results. Make sure to include the statement execution, including the resulting data.
• Display all columns and all rows from the Customer table under Sales.
• Display the ProductID, ProductNumber and ListPrice for all rows in the Product table.
• Modify query 2 so that the column headings are as follows:
• “ID,” “Number,” and “List Price”
• Display the full customer name for all customers in the Customer table.
• Display information about the Sales store with meaningful headers
• Display Work orders with stocked quantity less than 5. Then another query to display work orders with stock quantity between 10 and 15
• Display all the shipping method that has rate of more than $1.0 per Oz
Combine all of the screenshots into a single Word document, and submit this for grading.
