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...
-
Question 1 (a)Describe the FOUR (4) methods of allocating joint costs to products.(12 marks) (b)Weng Tai company simultaneously produces three products (X, Y and Z) from a single process. X and Y are...
-
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...
-
Consider that the quantities listed in the table of Problem 3.50 have Btu's. Determine the missing entries. Process -200 600 Q1-2 3 200 -600 04-1
-
In the following table the transportation cost for Gregory Bier Corp. are provided: Destination Source W X Y Z Supply $132 A $116 $250 $110 220 $220 $230 $180 $178 B 300 $152 $173 $196 $164 C 435...
-
Mass transfer models include transfer in only the packed region. Mass transfer also occurs in the column ends where liquid and vapor are separated. Discuss how these end effects affect a design. How...
-
John Doe purchased a bottle of Bleach-All, a well-known brand, from Roes combination service station and grocery store. When John used the Bleach-All, his clothes deteriorated due to an error in...
-
A single-threaded power screw is 20 mm in diameter with a pitch of 7 mm. A vertical load on the screw reaches a maximum of 5 kN. The coefficients of friction are 0.06 for the collar and 0.09 for the...
-
Bryant Corporation was incorporated on December 1, 2009, and began operations one week later. Before closing the books for the fiscal year ended November 30, 2010, Bryants controller prepared the...
-
As a project manager, you're prioritizing stakeholders with a power grid. You have a stakeholder you will need to manage closely. Where will you place this person in the power grid?
-
A golf club is swung starting from rest with an angular acceleration of 499.84 degrees/s 2 to reach an angular velocity of 382.95 degrees/s. Determine the rotation (degrees; enter unit as "deg") of...
-
Starshine Operating Assumptions $42.90 BV $36.00 IB $62.50 Stock Price $42.90 WACC $46.78 APV $45.35 Operating Assumptions for Starshine Copy to Clipboard 0.0 Increase in Domestic Revenues ($M) 0.0...
-
Summarize all the topics that are discussed in this youtube video. The video is called Economic Update: American's Self Image VS Reality. Also talk about if you agree with it or not.
-
Summarize the movie: Who Moved My Cheese . Include in your summary a listing of all four actors by name, coupled with a summary of the key characteristics for each. Think of a time in your life when...
-
A 68.5 kg football player is gliding across very smooth ice at 1.85 m/s. He throws a 0.450 kg football straight forward. a) What is the player's speed afterward if the ball is thrown at 13.5 m/s...
-
Determine the derivative using basic differentiation laws: h(m) - em - me +e+ 5-In(11m) h' (m) - sin (a)
-
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...
-
You have been invited to give a talk on mass transfer at the local high school. You want to show a live demonstration. Brainstorm at least five different demonstrations that you can develop with very...
-
For binary diffusion with convection, use Eqs. (15-15e), (15-15f), (15-17a), (15-17b), and sum of mole fractions equals 1.0 to show that \(D_{\mathrm{AB}}=D_{\mathrm{BA}}\). Fick's law diffusive flux...
-
For binary distillation with \(\mathrm{CMO}, \mathrm{v}_{\text {ref,mol }}=0\). If \(\mathrm{CMO}\) is valid, show that \(\mathrm{v}_{\text {ref,mass }} eq 0\) if \(\mathrm{MW}_{\mathrm{A}} eq...
Study smarter with the SolutionInn App