Q$1.$ Create a database with the following Design Specifications

Database Name: Company$\_$DENORMALIZED

Q$2.$ Create a table in the same database you created above with the following design specifications.

Table Name: SalesOrder

Q$3.$ Load the following data into the table created above $($use INSERT Statement$)$

Q$4.$ Retrieve the SalesOrderNo, CustomerName, Description, and Qty for all sales

Q$5.$ Retrieve the SalesOrderNo, CustomerName, Description, and Qty for CustomerNo $6229$

$($Use the WHERE Clause to filter CustomerNo $6229)$

Q$\mathrm{.}6.$ Retrieve SalesOrderNo, CustomerName for CustomerNo $6377$ from SalesOrder where ItemNo $>776$ or

ItemNo $<mn\; id="EditorElement\_103303">7</mn><mn\; id="EditorElement\_103304">1</mn><mn\; id="EditorElement\_103305">5</mn>$

Q$.7$ Please Sort the SalesOrder table by Item No$.$ The report should consider the

The Customer No $=6229$ 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 $\text{'}$MD$\text{'}$

and Qty is $2$ from salesOrder Table.

Sort descending order of Sales Order table where Qty $=2$ and Order by Customer No$.$