Display the list of customers

Assignment Help Macroeconomics
Reference no: EM133218315

This project is continuation of "Project One" that you have completed during this course. "Project One" was an open-topic project (Online sale, Hotel, Hospital, College). So, depending on the topic that you have selected, develop the following queries. In the following questions, "Product" is referred to the service that you provide and "Customer/Client" is referred to the person to whom you are providing service to.

Write the query that displays order id or order no., client_id , and client address.

Write the query that display the product/service id or product number that have been NOT sold to any customer.

Write a query that display product/service information (productid, desc, cost, and another information of your choice) and it is related inventory or store if there is any.

  1. Write the query that display the list of customers/clients who made order and the list of the products/services in each order.
  2. Write the query that display the list of customers/clients who never made order.
  3. Write the query that display the list of products/services that never sold.
  4. Write the query that display the top customers/clients (received most amount of services)
  5. Write the query that display the worst customers/clients (who received lowest service in total or no service at all )

Reference no: EM133218315

Questions Cloud

List the name of the publisher that published most books : Q1 List the first name and the last name of each customer who placed more than the average number of orders. Along with the names, show the total each of the li
Write essay on the importance of being punctual : Description - Write 300 Word Essay on "The importance of Being Punctual". This will be in APA format with cover page, reference page
Admin configured machine : Another admin configured the machine at 31.202.15.9 as a postfix email server, but users are complaining
Discuss some of the advantages of the database approach : Discuss some of the advantages of the database approach. Provide a brief overview of the various components of the database environment
Display the list of customers : This project is continuation of "Project One" that you have completed during this course. "Project One" was an open-topic project (Online sale, Hotel, Hospital,
Change the type of room 301 in building h to office : You need to submit the MongoDB code and the screenshots of the data (result sets) from the collection.
Information about the inventory of books in a bookstore : Q - Consider the following universal relation that holds information about the inventory of books in a bookstore.
Registration information system is software : A Registration Information System is software that is used to enter all the information of the students, that include the enrolled courses, grades,
Describe typical pairs of entities : Describe some typical pairs of entities that you think might be common in business and describe their relationships: many-to-many, one-to-many, many-to-one, or

Reviews

Write a Review

Macroeconomics Questions & Answers

  Actual country data

The life expectancy index for Haiti is:( Show steps please for each question) (See Table 1) The standard of living index for Haiti is:

  Examine our trade policies as they relate to other countries

Examine our trade policies as they relate to other countries that we normally trade with. Do we have a most favored nation status with any of these countries?

  Is guatemala debt makes if the government runs

Is Guatemala debt makes if the government runs a balanced budget in both a and b.

  What are various practical things you could do to raise

As a manager what are various practical things you could do to raise utility for employees that also benefit the firm

  What is the change in the real rate of interest

What is the growth rate of real GDP - what is the change in the real rate of interest and nominal rate of interest?

  Are you a classical or keynesian economist pick a

are you a classical or keynesian economist? pick a perspective and defend. apa style double spaced 12 font times new

  Calculate the long run profit maximizing price

This fee includes reproduction of the music,packaging, customer management, shipping and promotion costs. Big Apple has virtually no on-going fixed costs. Calculate the long run profit maximizing price and quantity sold.

  Analyze the impact of expansionary monetary policies

For this assignment you will write a 500- to 700-word memo evaluating two conflicting consultant reports. Your report should.

  Probability that the stock price

Consider a stock XYZ, whose price either goes up or down by exactly $1 each day. Suppose that XYZ's price goes up $1 with probability p and that XYZ's daily price changes are independent across days. What is value p that makes the probability that..

  Illustrtae what is the growth rate of its real gdp

Assume an economy's real GDP is $30,000 in year 1 and $31,200 in year 2. Illustrtae what is the growth rate of its real GDP.

  Which of the following fiscal policy changes would have a

which of the following fiscal policy changes would have a larger overall negative impact on ad and rgdp? explain your

  Discuss how government policiy can influence economic growth

Prepare a 2,100-word economic outlook forecast that includes the following: Discuss how government policies can influence economic growth.

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