Which department is associated with the lowest revenue

Assignment Help Computer Engineering

Reference no: EM132198868

Write the following sql queries using the Cape Codd DB.

1. Write a SQL statement to show sku and Description for all products having a SKU description that includes the word ‘foot'.

2. Write a SQL statement to display the warehouse and a count of QuantityOnHand grouped by warehouse.

3. Write a SQL statement to show the SKU and SKU_Description for all items stored in a warehouse managed by each manager.

4. Find out the total revenue collected by each store.

5. Which department is associated with the highest revenue?

6. Which department is associated with the lowest revenue?

7. Find out the storenumber and zipcode of the store that sold the maximum number of products.

8. Find out other warehouses whose average quantity on hand is not smaller than That of Atlanta warehouse.

9. List sku's and descriptions for all products whose sku starts with a "2". Use the BETWEEN operator. You may assume all sku's have 6 digits.

10. List the warehouses that currently have on average less than 225 items in stock of the products they carry. Use the HAVING operator.

11. List all order items for products currently out of stock in Atlanta. Use a subquery.

12. Get a list of buyers and their departments for any products out of stock (at any warehouse, not all warehouses). Use a join.

13. Get a list of departments and the total items on order for each department, sorted from largest to smallest quantity.

Use a join. Use the PC Manufacturer sample DB to write these additional queries as well as relational algebra expression.

1. Find the model number and price of all products (of any type) made by maker B.

2. Find those makers that sell laptops, not PCs.

3. Find those makers of at least two different computers. All queries should be contained in a single plain text file with a sql extension. Queries must be in the order above. Don't forget to separate each query with a semi-colon. Write the following sql queries using the Cape Codd DB.

1. Write a SQL statement to show sku and Description for all products having a SKU description that includes the word ‘foot'.

2. Write a SQL statement to display the warehouse and a count of QuantityOnHand grouped by warehouse.

3. Write a SQL statement to show the SKU and SKU_Description for all items stored in a warehouse managed by each manager.

4. Find out the total revenue collected by each store.

5. Which department is associated with the highest revenue?

6. Which department is associated with the lowest revenue?

7. Find out the storenumber and zipcode of the store that sold the maximum number of products.

8. Find out other warehouses whose average quantity on hand is not smaller than That of Atlanta warehouse.

9. List sku's and descriptions for all products whose sku starts with a "2". Use the BETWEEN operator. You may assume all sku's have 6 digits.

10. List the warehouses that currently have on average less than 225 items in stock of the products they carry. Use the HAVING operator.

11. List all order items for products currently out of stock in Atlanta. Use a subquery.

12. Get a list of buyers and their departments for any products out of stock (at any warehouse, not all warehouses). Use a join.

13. Get a list of departments and the total items on order for each department, sorted from largest to smallest quantity. Use a join. Use the PC Manufacturer sample DB to write these additional queries as well as relational algebra expression.

1. Find the model number and price of all products (of any type) made by maker B.

2. Find those makers that sell laptops, not PCs.

Reference no: EM132198868

Questions Cloud

Find all pairs of students taking the same courses : Find the major in which the most students have more than one class with a given professor. Find all pairs of students taking the same courses.

Propose a form of command and control intervention : Propose a form of command and control intervention to correct this externalityor explain one that already exists.

A function that removes all occurrences of the integer : A function (myRemove num list) that removes all occurrences of the integer num from a simple list of integers, returning list with num removed.

Write code to demonstrate your function on various inputs : A function (addBinary binaryList) that takes a list of binary numbers and returns their decimal sum. (addBinary '(1101 111 10 101)) returns 27.

Which department is associated with the lowest revenue : Find out other warehouses whose average quantity on hand is not smaller than That of Atlanta warehouse.

Plot the year-over-year growth rate : In a seperate graph, plot the Year-Over-Year growth rate of M2, M2++ and the Year-Over-Year Growth Rate of CPI. for the period of 2008 to 2018.

Definition of the keynesian multiplier : According to the definition of the Keynesian multiplier, an economy with $10 in investment

A constructor that has an const unsigned int parameter : A constructor that has an const unsigned int parameter. This constructor needs to dynamically allocate an array of the size passed into the parameter.

How the strings are stored in a byte-addressable memory : Show how the strings are stored in a byte-addressable memory on a little-endian machine starting at memory address 0x00001050C.

User Account

All Pages