Assignment: 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:

Use the NULL keyword to display the cust_number, cust_name and cust_city for records that have no value for the field cust_street in the table MSC_CUSTOMER.

Display empl_first_name, empl_last_name and job_code for employee number 228.

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

Display the number (tally) of customers who are located in the state of North Carolina.

Display the minimum, maximum and average ship quantities for all order details. Note: only include entries if the order has been shipped.

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