Write down a sql statement to show warehouse

Assignment Help Computer Engineering

Reference no: EM1333377

I'm not grasping the full concept of these problems, I've completed most successfully. I've tried to get them, but I am have a hard time reworking these.

(This is the table referenced for the following questions)

INVENTORY (SKU, Description, QuantityOnHand, QuantityOnOrder, Warehouse)

1. Write a SQL statement to display the SKU and Description of all items stored in the Seattle, Chicago or New Jersey warhouse. Do not use IN.

2. Write a SQL statement to show SKU and Description for all products having a description starting with 'Half-Dome'.

3. Write a SQL expression to display the Warehouse and a count of QuantityOnHand, grouped by Warehouse. Name the count TotalItemsOnHand.

4. Write a SQL expression to display the Warehouse and a count of QuantityOnHand, grouped by Warehouse. Omit all items that have a count greater than 2. Name the count TotalItemsOnHand and display the reslults in descending order of TotalItemsOnHand.

The following table is for the next set of questions.

INVENTORY (SKU, Description, QuantityOnHand, QuantityOnOrder, Warehouse)

WAREHOUSE (Warehouse, Manager, SquareFeet)

5. Write a SQL statement to show the SKU ande Description of all items stored in a warehouse managed by 'Smith'. Use a subquery.

6. Write a SQL statement to show the Warehouse and average QuantityOnHand of all items stored in a warehouse managed by 'Smith'. Use subquery.

7. Write a SQL statement to show Warehouse, Manager, and QuantityOnHand of all items stored in a warehouse managed by 'Smith'. Use a join.

Reference no: EM1333377

Questions Cloud

Arbitrage opportunity from spot quotation of currencies : Assume you observe the following direct spot quotations in New York and Toronto, respectively: 0.8000-30 and 1.2500-70. What are arbitrage profits per $1 million?

Manufacturing cost under previous simple job-costing system : Compute the manufacturing cost per unit for each job under the previous simple job-costing system.

Identify key success factors for implementation : Identify key success factors for implementation Critical succes factors.

Comparison between juvenile delinquent punishment past/prese : Discuss what life may have been like for Peter as a young person in America at this time. How were young people treated in everyday life, and how were their criminal actions handled?

Write down a sql statement to show warehouse : Write down a SQL statement to display the SKU and Description of all items stored in the Seattle, Chicago or New Jersey warhouse. Do not use IN.

Risk-free covered interest arbitrage : Critically discuss the transactions you would make to earn the risk-free covered interest arbitrage profits. How much profit would you expect to make?

Developmental theory in action : Using the developmental theory/model as the most effective change theory/model for the home schooling family and life in the large family.

Maintaining an annotated bibliography : Discuss briefly the advantages and disadvantages of maintaining an annotated bibliography of research data.

Alternative to achieve net income objective : Determine which alternative Almo should select to achieve its net income objective. Show your calculations.

User Account

All Pages