Q6) From the product_t table, return the number of rows of products with a natural ash...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Q6) From the product_t table, return the number of rows of products with a natural ash finish OR a cherry finish Q7) From the customer_t table, return all entries with a postal code beginning with 9, except those from California. Sort the results by the customer state. Q8) From the orderline_t table, list the total "Ordered Quantity" (label (alias) as "Total") for a total greater than 5. Q9) For every product that has been ordered, display the product ID and the total quantity ordered (label this result as "Popular_item ). List the most popular product first. Hint: Use the OrderLine_T table. ProductID Popular Item 00 m t 8 3 4 15 11 7 Q10) Show product description and product finish from the product table for furniture that isn't made of "Cherry" or "White Ash," and its price is greater than $500. OrderLine_T > Order_T > > > > ProducedIn_T ProductLine_T Product T Columns Indexes Foreign Keys > > Triggers RawMaterial T Salesperson T Skill T Supplies T 100% Result Grid 1 ProductID ProductLineID 2 13 14 5 16 7 8 1:1 NULL 1 2 2 3 1 2 2 3 Filter Rows: NULL Search Product Description End Table Coffee Table Computer Desk Entertainment Center Writers Desk 8-Drawer Desk Dining Table Computer Desk NULL Edit: ProductFinish Cherry Natural Ash Natural Ash Natural Maple Cherry White Ash Natural Ash Walnut NULL Export/Import: Product Standard Pri... 175.00 200.00 375.00 650.00 325.00 750.00 800.00 250.00 NULL > > Tables Customer_T Columns Indexes Foreign Keys Triggers Does BusinessIn_T EmployeeSkills_T Employee_T OrderLine_T Order_T ProducedIn_T ProductLine_T Product T RawMaterial_T Salesperson_T Skill_T Supplies_T Territory_T Uses_T Vendor T 100% Result Grid Search Edit: CustomerID Custor Refresh data re-executing the original query merCity CustomerState Contemporary Casuals Value Furniture Home Furnishings Eastern Furniture Impressions Furniture Gallery Period Furniture California Classics M and H Casual Furniture Seminole Interiors American Euro Lifestyles Battle Creek Furniture Heritage Furnishings Kaneohe Homes Mountain Scenes 1355 S Hines Blvd 15145 S.W. 17th St. 1900 Allard Ave. 1925 Beltline Rd. 5585 Westcott Ct. 325 Flatiron Dr. 394 Rainbow Dr. 816 Peach Rd. 3709 First Street 2400 Rocky Point Dr. 2424 Missouri Ave N. 345 Capitol Ave. SW 66789 College Ave. 112 Kiowai St. 4132 Main Street NULL NULL 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1:1 NULL Filter Rows: Gainesville FL Plano TX NY Albany Carteret Sacramento Boulder Seattle Santa Clara Clearwater Seminole Prospect Park NJ Battle Creek MI Carlisle Kaneohe Ogden PA HI UT NULL NJ 18833 CA CO WA CA FL FL NULL Export/Import: CustomerPostalCode 32601-2871 75094-7743 12209-1125 07008-3188 94206-4056 80514-4432 97954-5589 96915-7754 34620-2314 34646-4423 07508-5621 49015-3401 17013-8834 96744-2537 84403-4432 NULL > > > > > > > > > > Employee OrderLine_TE Columns Indexes Foreign Keys > Triggers Order_T ProducedIn_T ProductLine_T Product T RawMaterial T Salesperson T Skill_T Supplies T Territory_T Uses_T Vendor T Object Info ble: OrderLine_T Session 100% Result Grid 1003 1004 OrderID ProductID OrderedQuanti... 1001 1001 1001 1002 1004 1005 1006 1006 1006 1007 1007 1008 1008 1009 1009 1010 NULL 1 2 4 3 3 6 18 4 4 1:1 5 7 1 2 3 8 4 7 8 Filter Rows: NULL 2 2 1 5 3 2 2 3 1 2 2 3 2 3 3 2 3 10 NULL Search Q6) From the product_t table, return the number of rows of products with a natural ash finish OR a cherry finish Q7) From the customer_t table, return all entries with a postal code beginning with 9, except those from California. Sort the results by the customer state. Q8) From the orderline_t table, list the total "Ordered Quantity" (label (alias) as "Total") for a total greater than 5. Q9) For every product that has been ordered, display the product ID and the total quantity ordered (label this result as "Popular_item ). List the most popular product first. Hint: Use the OrderLine_T table. ProductID Popular Item 00 m t 8 3 4 15 11 7 Q10) Show product description and product finish from the product table for furniture that isn't made of "Cherry" or "White Ash," and its price is greater than $500. OrderLine_T > Order_T > > > > ProducedIn_T ProductLine_T Product T Columns Indexes Foreign Keys > > Triggers RawMaterial T Salesperson T Skill T Supplies T 100% Result Grid 1 ProductID ProductLineID 2 13 14 5 16 7 8 1:1 NULL 1 2 2 3 1 2 2 3 Filter Rows: NULL Search Product Description End Table Coffee Table Computer Desk Entertainment Center Writers Desk 8-Drawer Desk Dining Table Computer Desk NULL Edit: ProductFinish Cherry Natural Ash Natural Ash Natural Maple Cherry White Ash Natural Ash Walnut NULL Export/Import: Product Standard Pri... 175.00 200.00 375.00 650.00 325.00 750.00 800.00 250.00 NULL > > Tables Customer_T Columns Indexes Foreign Keys Triggers Does BusinessIn_T EmployeeSkills_T Employee_T OrderLine_T Order_T ProducedIn_T ProductLine_T Product T RawMaterial_T Salesperson_T Skill_T Supplies_T Territory_T Uses_T Vendor T 100% Result Grid Search Edit: CustomerID Custor Refresh data re-executing the original query merCity CustomerState Contemporary Casuals Value Furniture Home Furnishings Eastern Furniture Impressions Furniture Gallery Period Furniture California Classics M and H Casual Furniture Seminole Interiors American Euro Lifestyles Battle Creek Furniture Heritage Furnishings Kaneohe Homes Mountain Scenes 1355 S Hines Blvd 15145 S.W. 17th St. 1900 Allard Ave. 1925 Beltline Rd. 5585 Westcott Ct. 325 Flatiron Dr. 394 Rainbow Dr. 816 Peach Rd. 3709 First Street 2400 Rocky Point Dr. 2424 Missouri Ave N. 345 Capitol Ave. SW 66789 College Ave. 112 Kiowai St. 4132 Main Street NULL NULL 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1:1 NULL Filter Rows: Gainesville FL Plano TX NY Albany Carteret Sacramento Boulder Seattle Santa Clara Clearwater Seminole Prospect Park NJ Battle Creek MI Carlisle Kaneohe Ogden PA HI UT NULL NJ 18833 CA CO WA CA FL FL NULL Export/Import: CustomerPostalCode 32601-2871 75094-7743 12209-1125 07008-3188 94206-4056 80514-4432 97954-5589 96915-7754 34620-2314 34646-4423 07508-5621 49015-3401 17013-8834 96744-2537 84403-4432 NULL > > > > > > > > > > Employee OrderLine_TE Columns Indexes Foreign Keys > Triggers Order_T ProducedIn_T ProductLine_T Product T RawMaterial T Salesperson T Skill_T Supplies T Territory_T Uses_T Vendor T Object Info ble: OrderLine_T Session 100% Result Grid 1003 1004 OrderID ProductID OrderedQuanti... 1001 1001 1001 1002 1004 1005 1006 1006 1006 1007 1007 1008 1008 1009 1009 1010 NULL 1 2 4 3 3 6 18 4 4 1:1 5 7 1 2 3 8 4 7 8 Filter Rows: NULL 2 2 1 5 3 2 2 3 1 2 2 3 2 3 3 2 3 10 NULL Search
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
Minions-for-the-Masses uses overtime, inventory, and subcontracting to absorb fluctuations in demand for its fantasy action figures. Production is planned on an annual basis in cases per quarter. New...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Write MATLAB code of the question. Do all parts and show code with comments and also attach a screenshot of code and outputs. Using the results of Problem 4.13, verify the following properties of WN...
-
The density of gasoline at 0C is 0.68 103 kg / m3. (a) What is the density on a hot day, when the temperature is 33C? (b) What is the percent change in density?
-
Identify whether ongoing transactions posted to the following accounts would normally have only debit entries (Dr), only credit entries (Cr), or both debit and credit entries (both). A. B. C. D. E....
-
Petitioner Curtis Flowers has been tried six separate times for the murder of four employees of a Mississippi furniture store. Flowers is black; three of the four victims were white. At the first two...
-
Wyndham Stores operates a regional chain of upscale department stores. The company is going to open another store soon in a prosperous and growing suburban area. In discussing how the company can...
-
Consider the arithmetic series 7+13+19+25+31+37+43 +...and answer thequestions which follow. a) (i) T. (ii) Express Tin terms of S (2) (2) b) (i) T =........... ... S =... (2) (ii) Express T2 in...
-
If your mass is 75 kg, what is your weight on Earth, where the value 'g' is 10 m/s. Write your answer in newtons.
-
The HIM manager recently performed an audit of the integrity of the master patient index. Her audit revealed of 200 patient records reviewed, 5% of those patients had a duplicate record created....
-
A company buys 7 new photocopying machines. Each machine costs $4,619. What is the total cost of the machines? Show your calculations.
-
Explain how clinical guidelines, clinical pathways and protocols can help in improving utilization management in healthcare? Provide examples of applying guidelines in the context of utilization...
-
< 1. Describe at least three types of tangible and intangible resources and capabilities. 2. In the text, are human resources used as an example of tangible or intangible resources? Do you agree with...
-
1. Describe divisional organizational structure and critically analyse the advantages and disadvantages of disadvantages of divisionalisation (use academic papers). 2. Bounce Ltd is a leading...
-
The Trek Bicycle Corporation manufactures bicycles and has three product lines: Model A, Model B, and Model C. Data on sales and expenses are as follows: Model A Model B Model C 1,000 units $100,000...
-
Information graphics, also called infographics, are wildly popular, especially in online environments. Why do you think infographics continue to receive so much attention? How could infographics be...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
Laura is a single taxpayer living in New Jersey with adjusted gross income for the 2012 tax year of $35,550. Laura's employer withheld $3,300 in state income tax from her salary. In April of 2012,...
-
Joan is a self-employed attorney in New York City. Joan took a trip to San Diego, CA, primarily for business, to consult with a client and take a short vacation. On the trip, Joan incurred the...
-
Define terrorism.
-
Congress has prohibited the provision of material support or resources to certain foreign organizations that engage in terrorist activity. 18 U.S.C. 2339B(a)(1) . . . The plaintiffs in this...
-
Following a six-day trial in March 2008, a jury convicted Defendant Hassan Abu-Jihaad on two charges: (1) disclosing national defense information to those not entitled to receive it in violation of...
Study smarter with the SolutionInn App