Question
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
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 order number, line number and product number for records that have no value for the field ship_quantity in the table MSC_ORDER_DETAIL
Display empl_first_name, empl_last_name and job_code for employee number 220.
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.
Display the number (tally) of customers who are located in the state of Florida.
Display the minimum, maximum and average commission of all the products.
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.
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