Reference no: EM13764664
Instructions: Write the SQL code to perform the tasks requested in each problem. Note that Problem 10 requires you to answer a question.
1) Define a view containing products from supplier number S3399214. Include all product columns in the view.
2) Define a view containing the details of orders placed in January 2010. Include all OrderTbl columns, OrdLine.Qty, and the products name in the view.
3) Define a new containing the product number, name, price, and quantity on hand along with the number of orders in which the product appears.
4) Using the view define in problem 1, write a query to list the products with a price greater than $300. Include all view columns in the result.
5) Using the view defined in problem 2, write a query to list the rows containing the words "Ink Jet" in the product name. Include all view columns in the result.
6) Using the view defined in problem 3, write a query to list the products in which more than five orders have been placed. Include the product name and the number of orders in the result.
7) For the query in problem 4, modify the query so that it uses base tables only.
8) For the query in problem 5, modify the query so that it uses base tables only.
9) For the query in problem 6, modify the query so that it uses base tables only.
10) Is the view in problem 1 updatable? Explain why or why not.
|
Types of securities for its portfolio
: The Fish Corporation has purchased two different types of securities for its portfolio.
|
|
Evaluating a possible investment by the firm
: As the newly hired financial analyst for Rodgers International, you are charged with evaluating a possible investment by the firm in Bolivia. It is the end of 2014 (year 0) and an idle Bolivian facility is available to be purchased at a price of 2..
|
|
Capabilities of wimax
: Using any source of your choosing, research ADO.NET and in your own words, in about one paragraph, describe your understanding of it. Also, list your sources by providing links and/or printed book/article names.
|
|
Performing all the bookkeeping functions for the business
: Develop a hypothetical business you would consider starting with a friend or relative. Imagine also that you will be performing all the bookkeeping functions for the business
|
|
Write the sql code to perform the tasks
: Write the SQL code to perform the tasks requested in each problem. Define a new containing the product number, name, price, and quantity on hand along with the number of orders in which the product appears.
|
|
Growth of hospitals and health care systems
: Predict the type of long-term care needed as the 21st Century America advances in age. Defend or critique the type of care patients obtain in private nursing homes as compared to public institutions or in-home care. Provide a rationale for your re..
|
|
Review reading in qualitative research and evaluation method
: Review the reading in Qualitative Research and Evaluation Methods and the video segment "Doctoral Research: Ensuring Quality in Doctoral Research."
|
|
Write the sql code to perform the tasks
: Write the SQL code to perform the tasks requested in each problem. Define a new containing the product number, name, price, and quantity on hand along with the number of orders in which the product appears.
|
|
Review reading in qualitative research and evaluation method
: Review the reading in Qualitative Research and Evaluation Methods and the video segment "Doctoral Research: Ensuring Quality in Doctoral Research."
|