Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
36. Using the product and sales order detail table, find the products with total units sold greater than 1.5 million. Producto Nane Froductumber Maeflag FrhedGeodeflas Color SafetyockLevel Reorerfort StandardCom Pice So SoeneleanureCode We NU Ae Race AR 5381 Bang 8 Bal Beang BE NULL 1000 750 2.00 0.00 SULL NULL NULL 1000 750 NULL NULL NU NULL 00 600 NULL NULL NU Hea Bal Beatrg BE2908 NULL 00 0.00 NULL NULL NU 316 Ba NULL 800 600 NULL NIAL NU CAS LOwkam M Owam Back s00 375 000 0.00 NULL NULL NU 318 CAE Back 500 375 0.00 NULL NULL NU HLCka CA 7457 Back s00 375 000 000 NULL NULL NU NU > 320 10 321 11 2 12 23 13 324 14 325 15 325 16 327 17 32 Ohang But Careng N She 1000 750 000 000 NULL NULL Sher 1000 750 000 NULL NULL NU Channg CA Back 1000 750 00 0.00 NULL NULL NO Crown Race CR 991 NULL 1000 750 0.00 NULL NULL NU Chan Se csa12 NULL 1000 750 000 NULL NULL NU NU NU Decal1 NULL 1000 790 000 NULL NULL Decal 2 DC 24 NULL 1000 750 000 NULL NULL Denn Tube DT-2377 NULL 800 600 000 NULL NULL NU Matan End Cas CMO2 1. NULL 1000 750 0.00 NULL NULL NU Fig: Products table SalesCrderD SelesderDetao CamerTiacknghunber Orderữn Productio SeeciaOfero inthoe Untcedacout ineTotal prtn 2024 9540 82CSD 0SES4SCCICA3 4911-408 49114C 4911-4 49140C t m 43638 775 204 994 000 2004 94 000 4074 2000 6000-E77418EFE54514CFCOFA 4369 1. 2024 94 000 2024 4 FICS44E eBADo ARCSASCOD 2039 954 000 20394 000 43659 2039 954000 CDES-SS4SDE-GFA6271SFBCE 2039 94000 SATCT02E41-43E ATAC-37F23201 4079 0 CEATI3 AC4Aa1SE EEFOFDBAIRS 2019 994000 O6674 EEKEDAECAIOBEODF 6 521200 0540E 9-8009BARFSADS AR542630BOCD4CESSACIBFBZ477S AC4 esC ASAT7ICDB2504E 1037000 0GAS21 68 4199 AS12-00AFO34728 0.74000 ETEE5E-40808013CF422 419-4500 41SAT302 ACTA-40SB2-660SD14CDGE 439 S 4911-40C 1 772 435 4911-403C8 773 2035 954 000 43455 43114C 774 2009 954 0 43650 4911-48C-0 714 28.5404 000 49114C 716 26.404 000 28440400 10 4911-40C8 570 34200000 11 439 12 59 13 43660 13 4 43550 M 15 1 15 16 4661 16 17 43661 17 11 4911 403C0 491140C8 643140873 712 S1865 12 711 20 1O6S 000 762 419 4S89 000 6431-405743 758 274 794 000 4E0A-4FSAE 4EDA FSAE B0s NO000 EDE175I6473-4C FOCFDA 714.704300 FE1OBFOSD474e 5412TAEBOSSARD4 743 7147043 000 747 714 7043 0 00 1429 C 8136sasaE 24CS-4006-04aAEFERC Fig: Sales order detail table

36. Using the product and sales order detail table, find the products with total units sold greater than 1.5 million. Producto Nane Froductumber Maeflag FrhedGeodeflas Color SafetyockLevel Reorerfort StandardCom Pice So SoeneleanureCode We NU Ae Race AR 5381 Bang 8 Bal Beang BE NULL 1000 750 2.00 0.00 SULL NULL NULL 1000 750 NULL NULL NU NULL 00 600 NULL NULL NU Hea Bal Beatrg BE2908 NULL 00 0.00 NULL NULL NU 316 Ba NULL 800 600 NULL NIAL NU CAS LOwkam M Owam Back s00 375 000 0.00 NULL NULL NU 318 CAE Back 500 375 0.00 NULL NULL NU HLCka CA 7457 Back s00 375 000 000 NULL NULL NU NU > 320 10 321 11 2 12 23 13 324 14 325 15 325 16 327 17 32 Ohang But Careng N She 1000 750 000 000 NULL NULL Sher 1000 750 000 NULL NULL NU Channg CA Back 1000 750 00 0.00 NULL NULL NO Crown Race CR 991 NULL 1000 750 0.00 NULL NULL NU Chan Se csa12 NULL 1000 750 000 NULL NULL NU NU NU Decal1 NULL 1000 790 000 NULL NULL Decal 2 DC 24 NULL 1000 750 000 NULL NULL Denn Tube DT-2377 NULL 800 600 000 NULL NULL NU Matan End Cas CMO2 1. NULL 1000 750 0.00 NULL NULL NU Fig: Products table SalesCrderD SelesderDetao CamerTiacknghunber Orderữn Productio SeeciaOfero inthoe Untcedacout ineTotal prtn 2024 9540 82CSD 0SES4SCCICA3 4911-408 49114C 4911-4 49140C t m 43638 775 204 994 000 2004 94 000 4074 2000 6000-E77418EFE54514CFCOFA 4369 1. 2024 94 000 2024 4 FICS44E eBADo ARCSASCOD 2039 954 000 20394 000 43659 2039 954000 CDES-SS4SDE-GFA6271SFBCE 2039 94000 SATCT02E41-43E ATAC-37F23201 4079 0 CEATI3 AC4Aa1SE EEFOFDBAIRS 2019 994000 O6674 EEKEDAECAIOBEODF 6 521200 0540E 9-8009BARFSADS AR542630BOCD4CESSACIBFBZ477S AC4 esC ASAT7ICDB2504E 1037000 0GAS21 68 4199 AS12-00AFO34728 0.74000 ETEE5E-40808013CF422 419-4500 41SAT302 ACTA-40SB2-660SD14CDGE 439 S 4911-40C 1 772 435 4911-403C8 773 2035 954 000 43455 43114C 774 2009 954 0 43650 4911-48C-0 714 28.5404 000 49114C 716 26.404 000 28440400 10 4911-40C8 570 34200000 11 439 12 59 13 43660 13 4 43550 M 15 1 15 16 4661 16 17 43661 17 11 4911 403C0 491140C8 643140873 712 S1865 12 711 20 1O6S 000 762 419 4S89 000 6431-405743 758 274 794 000 4E0A-4FSAE 4EDA FSAE B0s NO000 EDE175I6473-4C FOCFDA 714.704300 FE1OBFOSD474e 5412TAEBOSSARD4 743 7147043 000 747 714 7043 0 00 1429 C 8136sasaE 24CS-4006-04aAEFERC Fig: Sales order detail table

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
Query must me really appropriate
36. Using the product and sales order detail table, find the products with total units sold greater than 1.5 million. Safety StockLevel Aecrsierfort Standardcom tce So 0.00 ProductD Nane FroductNumber Mskeflag FnahedGeodelag Color AR 5301 SoeUheMeanureCode We NU NU Adae Race NULL 1000 750 0.00 NULL NULL Beang 88 Bal Beamg BE234 NULL 1000 750 000 00 NULL NULL NULL B00 600 000 NULL NULL NU 4. Heatt Bal Beangs BE 2908 NULL 300 600 0.00 NULL NULL 316 17 Ba B-2034 NULL 800 600 NULL NIAL NU LLCwkm CAS Back s00 375 0.00 NULL NULL NU NULL NULL NULL NULL M. Cam Back 500 375 000 0.00 NU Back s00 She 1000 NU NU HLCka Chang Buts Chaneng N Charng CA7457 375 00 000 320 10 321 11 322 12 323 13 324 14 125 15 326 16 327 17 321 CB-2903 CN 6137 750 000 0.00 NULL NULL Sver 1000 Back 1000 750 000 000 NULL NULL NU 750 0.00 00 NULL NULL NU CR 9981 CS212 Croun Race NULL 1000 750 000 0.00 NULL NULL NU Chan S Decal1 Decal 2 NULL 1000 750 000 NULL NULL NU NULL 1000 720 000 NULL NULL NU DC 24 NULL 1000 750 00 NULL NIALL NU Dewn Tibe DT-2377 NULL B00 600 NILL NULL NU Murtan End Cas CMO2 NULL 1000 750 00 NULL NULL NU Fig: Products table Salesrder SalesOrderDetao CamerTackingunber Crdery 4911-403C 8 491140C 4911-40 ProductiD SpeciaOfen intProe UntrceCacount ine Tota rowgud 43638 776 2024954 O00 2024 94 000 074 2000 788600-E74186-3FES S14CFCOFA 2024 994 4CFE44E BBAD ARCSASOCODa 2039 954000 ACADES1-S1S4SD6-3670FA62719FRCE 2039 94000 SATET02E41-43EATAC-S 0 777 436 2024 O 00 4. 4911-403C-88 771 2039 994 0 00 4911-40C8 4911408 491140Cse 4971-400-0 43659 772 2039 94 0 00 2039 954 000 2009 994 O00 4365 773 4079 38O CEATIS32 AC4BAa16E EEFDFD84RS 2039 994000 O667040-F962-4EE39SEDAECA1OBEODEF 6 521200 2840400 43655 774 1. 4365 714 28.5404 000 26 S04 AAS42630 BOCD-ACES SADCIBFAZ475 AC04 C2F-495C ASATICD82504E 06AGS21 68F 499 AS12-0DAFOJE34728 465 49114Ce 716 10 49114C 570 34200000 10373000 11 4369 11 4911403C 0 712 S1865 0 00 491140C8 12 465 13 43660 14 12 711 20 16S 13 6431-406783 1. 419 4589 0.00 419 4S00 41SAT302 ACTA 40TB2 660SD1ACDOE 43560 14 6431-406743 758 174794 EDEY75E4733-4C7FOCFADO02DA FE10BFOS D474e 54127AEBOSASD4 1429 60 B13685E 2C9-006-8048-81AEFERC7 15 15 16 43661 17 43661 16 4EDA FESAE 714.7043 000 714.704300 17 714 7043 O 00 Fig: Sales order detail table
Transcribed Image Text:36. Using the product and sales order detail table, find the products with total units sold greater than 1.5 million. Safety StockLevel Aecrsierfort Standardcom tce So 0.00 ProductD Nane FroductNumber Mskeflag FnahedGeodelag Color AR 5301 SoeUheMeanureCode We NU NU Adae Race NULL 1000 750 0.00 NULL NULL Beang 88 Bal Beamg BE234 NULL 1000 750 000 00 NULL NULL NULL B00 600 000 NULL NULL NU 4. Heatt Bal Beangs BE 2908 NULL 300 600 0.00 NULL NULL 316 17 Ba B-2034 NULL 800 600 NULL NIAL NU LLCwkm CAS Back s00 375 0.00 NULL NULL NU NULL NULL NULL NULL M. Cam Back 500 375 000 0.00 NU Back s00 She 1000 NU NU HLCka Chang Buts Chaneng N Charng CA7457 375 00 000 320 10 321 11 322 12 323 13 324 14 125 15 326 16 327 17 321 CB-2903 CN 6137 750 000 0.00 NULL NULL Sver 1000 Back 1000 750 000 000 NULL NULL NU 750 0.00 00 NULL NULL NU CR 9981 CS212 Croun Race NULL 1000 750 000 0.00 NULL NULL NU Chan S Decal1 Decal 2 NULL 1000 750 000 NULL NULL NU NULL 1000 720 000 NULL NULL NU DC 24 NULL 1000 750 00 NULL NIALL NU Dewn Tibe DT-2377 NULL B00 600 NILL NULL NU Murtan End Cas CMO2 NULL 1000 750 00 NULL NULL NU Fig: Products table Salesrder SalesOrderDetao CamerTackingunber Crdery 4911-403C 8 491140C 4911-40 ProductiD SpeciaOfen intProe UntrceCacount ine Tota rowgud 43638 776 2024954 O00 2024 94 000 074 2000 788600-E74186-3FES S14CFCOFA 2024 994 4CFE44E BBAD ARCSASOCODa 2039 954000 ACADES1-S1S4SD6-3670FA62719FRCE 2039 94000 SATET02E41-43EATAC-S 0 777 436 2024 O 00 4. 4911-403C-88 771 2039 994 0 00 4911-40C8 4911408 491140Cse 4971-400-0 43659 772 2039 94 0 00 2039 954 000 2009 994 O00 4365 773 4079 38O CEATIS32 AC4BAa16E EEFDFD84RS 2039 994000 O667040-F962-4EE39SEDAECA1OBEODEF 6 521200 2840400 43655 774 1. 4365 714 28.5404 000 26 S04 AAS42630 BOCD-ACES SADCIBFAZ475 AC04 C2F-495C ASATICD82504E 06AGS21 68F 499 AS12-0DAFOJE34728 465 49114Ce 716 10 49114C 570 34200000 10373000 11 4369 11 4911403C 0 712 S1865 0 00 491140C8 12 465 13 43660 14 12 711 20 16S 13 6431-406783 1. 419 4589 0.00 419 4S00 41SAT302 ACTA 40TB2 660SD1ACDOE 43560 14 6431-406743 758 174794 EDEY75E4733-4C7FOCFADO02DA FE10BFOS D474e 54127AEBOSASD4 1429 60 B13685E 2C9-006-8048-81AEFERC7 15 15 16 43661 17 43661 16 4EDA FESAE 714.7043 000 714.704300 17 714 7043 O 00 Fig: Sales order detail table
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS