Q6) From the product_t table, return the number of rows of products with a natural ash...

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