Question: Write a query that display order id or order no., customer_id , and customer address 2. Write a query that display the product id or

Write a query that display order id or order no., customer_id , and customer address

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

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

4. Write a query that display the list of customers/clients who made order and the list of the products in each order.

5. Write a query that display the list of customers/ clients who never made order.

6. Write a query that display the list of products that never sold.

7. Write a query that display the top customers (who made high purchase in total)
8. Write a query that display the worst customers (who made low purchase in total or no purchase at all )

Step by Step Solution

★★★★★

3.51 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Here are SQL queries for each of your requirements 1 Display Order Information with Customer Address This query displays the order ID or order number ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...

1. How strong are the competitive forces confronting J. Crew in the market for specialty retail? Do a [Michael Porter] five-forces analysis to support your answer. (see chapter 3 in the textfor...

The structure and contents of the Ch07_LargeCo database are shown in Figure P7.27 . Use this database to answer the following problems. 27. Write a query to display the eight departments in the...

SQL CODE: 30. Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title "CLERK I." Sort the output by...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql 30. Write a query to display the first name, last...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql OR...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Please solve this Excel spreadsheet using the directions! Thank you so much! Directions: Excel Spreadsheet: The manager of Paco's Dog Treats, Inc. imported inventory data. This data must be cleansed....

1)Find an equation of the line tangent to the graph of f(x) = \f4 y = g(X) 3 -+ 2 1 0 2 3 4

Scenario (Part 1) You are working at a busy nightclub and have been monitoring a patron for the last hour. The patron has not ordered a single drink, but you have noticed significant changes in their...

describe a healthcare quality improvement that occurred within an organization. In this discussion, you will Examine the quality improvement that occurred, including the background and the process...

You're starting a small photography business. You need an inexpensive but powerful photo editing program to touch up your Images. Compare two photo editing programs in the $75-$200 range. Evaluate...

Jonathan Lark's lifelong dream is to own a restaurant. He owns a premium site for a restaurant across the street from the local university. Now he needs to decide what kind of restaurant to open....

What is the shift capacity of a machine with the following characteristics? ---Part processing time = 70 seconds ---cutting tool has to be replace every 35 pieces and it takes 30 seconds to replace...

Brief Exercise 16-4 The cost of the trading securities of Munoz Company at December 31, 2017, is $56,500. At December 31, 2017, the fair value of the securities is $53,850. Prepare the adjusting...

Organizations are increasing their use of personality tests to screen job applicants. What are some of the advantages and disadvantages of this approach? What can managers do to avoid some of the...

Yolanda earns $112,000 in 2012. Calculate the FICA tax that must be paid by: Yolanda:.....................Soc.Sec..................$__________...

Fisafolia Corporation has gross income from operations of $220,000 and operating expenses of $160,000 for 2012. The corporation also has $20,000 in dividends from publicly traded domestic...

Mary paid $2,000 of state income taxes in 2012. The total sales tax she paid during 2012 was $5,500, which included $3,000 for the cost of a new car. How should Mary treat the taxes paid on her 2012...

Identify the best methods for taking notes and listening in class.

Describe some strategies for time management.

30. Who would be likely to drink more alcoholsomeone who metabolizes acetaldehyde to acetic acid rapidly or one who metabolizes it slowly?