Reference no: EM13765218
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.
|
Systems administrator of radius implementation
: Suppose you are a Systems Administrator, and you have been tasked with implementing RADIUS to support authentication, authorization, and accounting in your organizations Windows network environment.
|
|
What are the operating breakeven points in units
: Cessalin Company sells artificial flower arrangements for $25.75 per arrangement. The company has fixed operating costs of $38,430 per year. They also have variable cost per arrangement of $10.50. What are the operating breakeven points in units?
|
|
Criticisms and benefits of community policing
: Write a one page essay , where you discuss what are some of the criticisms and benefits of community policing
|
|
What is their sunk cost
: Jenson Computers has 850 computers that are no longer useful. The original cost was $600,000. The computers could be upgraded for $195,000 and sold for $728,000. Or, they could be sold as is for $100,000. What is their sunk cost?
|
|
Define a view containing the details of orders placed
: Define a view containing products from supplier number S3399214. Include all product columns in the view. Define a view containing the details of orders placed in January 2010. Include all OrderTbl columns, OrdLine.Qty, and the products name in the..
|
|
Calculate the dollar price increase and decrease
: Consider a Zerobond (i.e., a bond that pays no coupon payment, meaning that the coupon rate on the bond is 0%) with a par value of $1,000 that will mature exactly 12 years from today. The current YTM of this Zerobond is 5.2%. Two years ago the YTM of..
|
|
Influence of professional codes of conduct and standards
: The accounting profession has been investigated by Congress over a number of years. However, none of the investigations or recommendations for change seems to have made a difference in that fraud cases continued into the early 2000s.
|
|
What laws and services are available for victims
: What laws and services are available for victims of racial profiling? What other actions might be taken on behalf of victims of racial profiling
|
|
Investments are fixed with respect to the rate of return pay
: Which of the following investments are fixed with respect to the rate of return they pay?
|