Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q 1 . Create a database with the following Design Specifications Database Name: Company _ DENORMALIZED Q 2 . Create a table in the same
Q Create a database with the following Design Specifications
Database Name: CompanyDENORMALIZED
Q Create a table in the same database you created above with the following design specifications.
Table Name: SalesOrder
Q Load the following data into the table created above use INSERT Statement
Q Retrieve the SalesOrderNo, CustomerName, Description, and Qty for all sales
Q Retrieve the SalesOrderNo, CustomerName, Description, and Qty for CustomerNo
Use the WHERE Clause to filter CustomerNo
Q Retrieve SalesOrderNo, CustomerName for CustomerNo from SalesOrder where ItemNo or
ItemNo
Q Please Sort the SalesOrder table by Item No The report should consider the
The Customer No and customer name 'Janet'
Sorting should be both ascending and descending order.
Write a query that Sort the SalesOrder table by its Customer No The Query should address for both
ascending and descending order
Write a query that returns data that specifies what you do not want returned customer CustomerAdd is MD
and Qty is from salesOrder Table.
Sort descending order of Sales Order table where Qty and Order by Customer No
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started