Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Design a query to list each product name, the number of units in stock for the product, and the total number of products that have

Design a query to list each product name, the number of units in stock for the product, and the total number of products that have the same units in stock as the product. The list must be in ascending order of the units in stock values and then in ascending order of the product name (if more than one product has the same units in stock). A sample of the expected result is provided below.
\table[[Product Name,Units In Stock,Products with Similar UnitsinStock],[Alice Mutton,0,5],[Chef Anton's Gumbo Mix,0,5],[Gorgonzola Telino,0,5],[Perth Pasties,0,5],[Thringer Rostbratwurst,0,5],[Sir Rodney's Scones,3,1],[Longlife Tofu,4,2],[Louisiana Hot Spiced Okra,4,2],[Rgede sild,5,1],[Northwoods Cranberry Sauce,6,2],[Scottish Longbreads,6,2],[..,dots.,dots.]]
Design a query that enables the user to enter the name of a country and list the names of products and the total number of times the product has been ordered by customers in that country. Also, display the quantity of the product sold in the country. The products with the highest quantity sold in the country must be listed first. For example, entering Germany may produce the following result:
\table[[Product Name,Times Ordered,Quantity Ordered],[Camembert Pierrot,9,384],[Boston Crab Meat,9,345],[Raclette Courdavault,11,337],[dots,dots,...]]
Design a query to list all employees who earn more salary than their supervisor. Display the following fields
\table[[Employee ID,First Name,Last Name,Employee Salary Supervisor Salary],[dots,dots,dots,dots
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions