How many customers are from cities

Assignment Help Database Management System

Reference no: EM132412297

Question 1. Write a query that outputs our ordered by city

Question 2. Who are the managers (names) and in what city and state do they work?

Question 3. How many customers are from cities where offices are located?

Question 4. How many orders from May 2005 have already been shipped?

Question 5. What are the companys total sales

Question 6. On how many items is the companys marked over 200%(meaning how many products are there that the company sells more for more than twice what they paid for the item?

Question 7. If the company sold everything that is in its inventory today, how much profit would they make?

Question 8. How many customers have ordered items from our "planes" product line of products?

Question 9. How much money have customers paid for orders by state? Order our output by state

Question 10. How many items have been sold from each product line?

Question 11. How many sales does each office account for? List our total sales by city.

Question 12. Same query for #10, but this time, break the sales down by employee. Show the city, employee name (one column last, first) and their sales

Attachment:- exam.rar

Reference no: EM132412297

Questions Cloud

Computing the weighted average cost of capital : If Worldwide Widget Manufacturing has a marginal tax rate of 32 percent, what weighted average cost of capital (WACC) should it use as it evaluates this project

What evidence is the ceo using to suggest : What evidence is the CEO using to suggest that Genex is not using technology competitively? Did Devlin need to hire Sandy, a "high-priced technology consultant.

Calculate the nal for acme : (a) Calculate the NAL for Acme (the lessee). (b) Calculate the NAL (NPV of investment) of the lease for QLC (the lessor). (c) Given your results for part b

Discussing the use of encryption to protect data in motion : Write an essay of at least five hundred words discussing the use of encryption to protect data at rest, in motion, and in use. Use the five paragraph format.

How many customers are from cities : How many customers are from cities where offices are located and How much money have customers paid for orders by state? Order our output by state

Examine the changes that have been made to the system : Use the lesson from last week to create a new virtual machine on your computer with a Windows operating system. Apply all operating system updates.

Describing what data remains on a computer hard drive : After reading Chapter 5 of the textbook, write a short paper describing what data remains on a computer hard drive after a user accesses the Google Drive.

Calculate the expected roe-standard deviation : Calculate the expected ROE, standard deviation, and coefficient of variation for each of the following debt-to-capital ratios.

List the organization sensitive data that must be protected : List the organization's sensitive data that must be protected. Complete a matrix that compares the asymmetric and symmetric encryption methodologies.

User Account

All Pages