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...

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

Extracted 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
Jun 11, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?