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...
-
A weight W rests on top of a wall and is attached to one end of a very flexible cord having cross-sectional area A and modulus of elasticity E (see figure). The other end of the cord is attached...
-
How is the income assigned to the noncontrolling interest normally computed?
-
Ratio Analysis} The following information pertains to Perle Corporation's financial results for the past year. Required: Calculate Perle's (1) gross profit margin ratio and (2) net profit margin...
-
Mel OConner owns rental properties in Michigan. Each property has a manager who collects rent, arranges for repairs, and runs advertisements in the local newspaper. The property managers transfer...
-
On completion of an audit-------------- serves the purpose of audit record which may be useful for future reference. a)Audit programme b)Audit working papers c)Audit plan d)Audit notes
-
The time from acceptance to maturity on a $1,000,000 banker's acceptance is 120 days. The importer's bank's acceptance commission is 1.75 percent and the market rate for 120-day B/As is 5.75 percent....
-
Compare the characteristics and purposes for using a norm-referenced academic achievement test, a criterion-referenced assessment, and a curriculum-based assessment. Which assessment would you use to...
-
(PO2, CO2, C4) a) Despite the main reaction in the partial oxidation of propylene (C3H6) to give acrylic acid (C3H4O2), there are two other competing reactions as shown below. These reactions are...
-
6- Consider the following set of processes, along with their burst times and arrival times: Process P1 P2 P3 P4 P5 Total CPU Time Arrival Time 1 2 3 4 1 0 3 5 10 9 a. Complete the following Gantt...
-
1. How would you define work-life balance? (This answer can be brief, but should be answered in a complete sentence) 2. How do you know when your life is in balance (or out of balance)? What does it...
-
Internal analysis results in the identification of what factors that impact the competitive position and profitability of an organization?
-
ABC Inc. is a small New England company that manufactures custom clocks. It uses normal costing system that applies factory overhead on the basis of direct labor-hours. Factory overhead for the past...
-
The Thompson Corporation, a manufacturer of steel products, began operations on October 1, 2019. The accounting department of Thompson has started the fixed-asset and depreciation schedule presented...
-
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...
-
From the standpoint of the borrower, short-term credit is riskier because short-term interest rates fluctuate more than long-term rates, and the firm may be unable to repay the debt. If the lender...
-
The futures market can be used to guard against interest rate and input price risk through the use of hedging. If the firm were concerned that interest rates will rise, it would use a short hedge, or...
-
If the elimination of volatile cash flows through risk management techniques does not significantly change a firm's expected future cash flows and WACC, investors will be indifferent to holding a...
Study smarter with the SolutionInn App