Find out the total revenue collected by each store

Assignment Help Computer Engineering
Reference no: EM132198152

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.

Reference no: EM132198152

Questions Cloud

Create a doubly linked list whose nodes contain strings : Create a doubly linked list whose nodes contain Strings. Create a main method that thoroughly tests each function you build to show that it works.
Write a find command in a unix shell command : Write a "find" command in a unix shell command that will locate ALL files with their setuid (suid) bit set on your linux OS installation.
Write the following two statements in symbolic form : Write the following two statements in symbolic form and determine whether they are logically equivalent.
Demonstrate your function on various inputs : The function must be written in a functional style and must use only the basic Scheme functions car, cdr, cons, null, atom, the equality functions.
Find out the total revenue collected by each store : 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.
Write definition for a function called that takes arguments : Write the definition for a function called that takes two arguments. The function should returns the larger of the two values.
Write and execute and turn in a program to read angles : Write and execute and turn in (as screen captures) a program to read in the three angles of a triangle and print if the triangle is a valid one or not.
Selects a peanut butter cookie from the bag : Christy reaches in the bag and randomly selects a peanut butter cookie from the bag, eats it, then reaches back in the bag and randomly selects a sugar cookie?
Find the distribution of n : (a) Find ET. (b) Find the distribution of N. (c) Solve (a) and (b) for a general number of batteries.

Reviews

Write a Review

Computer Engineering Questions & Answers

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

  Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

  Security policy document project

Analyze security requirements and develop a security policy

  Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd