6. Write a query to display product_id, product_desc, product_quantity_avail, quantity sold, quantity available and show inventory...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
6. Write a query to display product_id, product_desc, product_quantity_avail, quantity sold, quantity available and show inventory Status of products as below as per below condition: a. For Electronics and Computer categories, if sales till date is Zero then show 'No Sales in past, give discount to reduce inventory', if inventory quantity is less than 10% of quantity sold, show 'Low inventory, need to add inventory', if inventory quantity is less than 50% of quantity sold, show 'Medium inventory, need to add some inventory', if inventory quantity is more or equal to 50% of quantity sold, show 'Sufficient inventory' b. For Mobiles and Watches categories, if sales till date is Zero then show 'No Sales in past, give discount to reduce inventory, if inventory quantity is less than 20% of quantity sold, show 'Low inventory, need to add inventory, if inventory quantity is less than 60% of quantity sold, show 'Medium inventory, need to add some inventory, if inventory quantity is more or equal to 60% of quantity sold, show 'Sufficient inventory c. Rest of the categories, if sales till date is Zero then show 'No Sales in past, give discount to reduce inventory', if inventory quantity is less than 30% of quantity sold, show 'Low inventory, need to add inventory, if inventory quantity is less than 70% of quantity sold, show 'Medium inventory, need to add some inventory', if inventory quantity is more or equal to 70% of quantity sold, show 'Sufficient inventory' -- (USE SUB-QUERY) - [NOTE: TABLES to be used - PRODUCT, PRODUCT_CLASS, ORDER_HEADER] 6. Write a query to display product_id, product_desc, product_quantity_avail, quantity sold, quantity available and show inventory Status of products as below as per below condition: a. For Electronics and Computer categories, if sales till date is Zero then show 'No Sales in past, give discount to reduce inventory', if inventory quantity is less than 10% of quantity sold, show 'Low inventory, need to add inventory', if inventory quantity is less than 50% of quantity sold, show 'Medium inventory, need to add some inventory', if inventory quantity is more or equal to 50% of quantity sold, show 'Sufficient inventory' b. For Mobiles and Watches categories, if sales till date is Zero then show 'No Sales in past, give discount to reduce inventory, if inventory quantity is less than 20% of quantity sold, show 'Low inventory, need to add inventory, if inventory quantity is less than 60% of quantity sold, show 'Medium inventory, need to add some inventory, if inventory quantity is more or equal to 60% of quantity sold, show 'Sufficient inventory c. Rest of the categories, if sales till date is Zero then show 'No Sales in past, give discount to reduce inventory', if inventory quantity is less than 30% of quantity sold, show 'Low inventory, need to add inventory, if inventory quantity is less than 70% of quantity sold, show 'Medium inventory, need to add some inventory', if inventory quantity is more or equal to 70% of quantity sold, show 'Sufficient inventory' -- (USE SUB-QUERY) - [NOTE: TABLES to be used - PRODUCT, PRODUCT_CLASS, ORDER_HEADER]
Expert Answer:
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1285196145
11th edition
Authors: Carlos Coronel, Steven Morris
Posted Date:
Students also viewed these marketing questions
-
12. A Eurodollar loan is a(n): a. ECU-denominated loan issued by a U.S. bank. b. dollar-denominated loan payable to a European bank. c. ECU-denominated loan that is subject to banking regulations in...
-
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...
-
ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...
-
Data obtained from asking the wrong questions at the wrong time or in the wrong place can lead to misleading summary statistics. Explain why the following collection procedures are likely to produce...
-
The information listed below refers to the employees of Lemonica Company for the year ended December 31, 2016. The wages are separated into the quarters in which they were paid to the individual...
-
Suppose you face the following situation. You have saved $20,000 for next years tuition ($14,000) and expenses ($6,000) in a bank account earning 5%. But you now see an opportunity to do more with...
-
Using the above data, calculate the operatingcash-flow-to-capital-expenditures ratio for Evans \& Sons. The following information for Evans \& Sons relates Cash flow from operating activities......
-
Lenny Worthington is general manager of Crossroad Tanning Salons. During 2012, Worthington worked for the company all year at a $6,100 monthly salary. He also earned a year-end bonus equal to 5% of...
-
What are the pilot project results? And how to use the results of a pilot project to revise the final study.
-
What if you decide to hold the stock for two years? - D = $2.00 CF - D = $2.10 - P = $14.70 - = $2.00 } CF2 = $2.10 + $14.70 = $16.80 Now how much would you be willing to pay?
-
Gaming entertainment is comprised of many different revenue centers. Today's casino resort is much like a "hospitality buffet" luxurious lodging, world class dining, Broadway quality shows, rock star...
-
You are an audit senior at a reputable audit firm, and you have been assigned to plan the audit engagement for "RetailSmart Ltd.," a mid-sized retail company with multiple locations. RetailSmart Ltd....
-
Assume that your company is planning to implement a new information system to improve its operations. For this purpose, the company top management is evaluating two information systems project...
-
In March, 2024, a mining company purchased a coal mine for $8,000,000. Removable coal is estimated at 1,500,000 tons. The company is required to restore the land at an estimated cost of $960,000;...
-
Mateo's disposable after-tax income is $65,100. He has always saved $500/month for his annual vacation. Everything else goes towards covering his expenses. Recently, however, Mateo was injured and...
-
An investment portfolio of 1,200,000 mirrors the DAX Index. It is estimated that there will be a large decline in the market prices of the investment portfolio over the next 3 months. The trading...
-
Some people argue that the internal control requirements of the Sarbanes-Oxley Act (SOX) put U.S. companies at a competitive disadvantage to companies outside the United States. Discuss the...
-
List the balance characteristics of the customers who have made purchases during the current invoice cyclethat is, for the customers who appear in the INVOICE table. The results of this query are...
-
Create the table that would result from applying the SELECT and PROJECT relational operators to the CHARTER table to return only the CHAR_TRIP, CHAR_PILOT, and CHAR_COPILOT attributes for charters...
-
In Chapter 4, you saw the creation of the Tiny College database design. That design reflected such business rules as a professor may advise many students and a professor may chair one department....
-
Burger King announced it would phase abused chicken out of its supply chain by 2024. The new standards include the requiring of higher-welfare strains of chickens, a reduction in the stocking density...
-
Ilectronics Inc. makes high-quality speakers for a variety of applications. Electronics Inc. is a St. Louis-based company but has significant manufacturing operations in China. When manufacturing...
-
Sony ('orp). launched its PlayStation 4 in late 2013. It was introduced at a price point of \(\$ 399\). At the time of introduction, a technology firm performed a tear-down of the PlayStation and...
Study smarter with the SolutionInn App