Practice LAB: Using the VLABS environment, log into SQL SERVER and use the tables in IST210-ONLINE folder with the prefix of MSC, and perform the following queries:

1.Use the NULL keyword to display the order number, line number and product number for records that have no value for the field ship_quantity in the table MSC_ORDER_DETAIL

2.Display empl_first_name, empl_last_name and job_code for employee number 220.

3.Display the product number, vendor number and quantity in stock value for product detail where the quantity in stock is in the 200 to 300 range from the MSC_product_detail table sorted in descending order by quantity in stock value.

4.Display the number (tally) of customers who are located in the state of Florida.

5.Display the minimum, maximum and average commission of all the products.

6.Display employee number, first name and last name when the employees last name contains a letter C (upper or lower case) anywhere in the last name.

Be sure to include the "row(s) affected" messages.