Question
1-List all orders with sales greater than or equal 7000 2-List all orders with sales greater than 4800 and quantity greater than 36 3-List all
1-List all orders with sales greater than or equal 7000
2-List all orders with sales greater than 4800 and quantity greater than 36
3-List all orders with sales between $4000 and $6000 inclusive
4-List all orders with a dealsize medium or small and country is Canada
5-List all orders with product line motorcycles and country is USA or Canada
6-List all orders with a country with an "n" as the third character and with sales greater than $3000
7-List all orders from the states of NJ, NY or MA with quantity greater than 30 and sales greater than $5000
8-List all orders from a country that has "a" as the second letter and sales greater than $3000
9-List all orders from countries that start with a "U" and dealsize is medium
10- List all orders made between 1/1/2004 and 1/1/2005 and with salesgreater than $5000
Question ORDERNUMBERQUANTITYORDEREDPRICEEACHORDERLINENUMBERSALESORDERDATESTATUSPRODUCTLINECITYSTATECOUNTRYDEALSIZE101073095.7228712/24/03 0:00ShippedMotorcyclesNYCNYUSASmall101213481.3552765.95/7/03 0:00ShippedMotorcyclesReimsFranceSmall101344194.7423884.347/1/03 0:00ShippedMotorcyclesParisFranceMedium101454583.2663746.78/25/03 0:00ShippedMotorcyclesPasadenaCAUSAMedium1015949100145205.2710/10/03 0:00ShippedMotorcyclesSan FranciscoCAUSAMedium101683696.6613479.7610/28/03 0:00ShippedMotorcyclesBurlingameCAUSAMedium101802986.1392497.7711/11/03 0:00ShippedMotorcyclesLilleFranceSmall101884810015512.3211/18/03 0:00ShippedMotorcyclesBergenNorwayMedium102012298.5722168.5412/1/03 0:00ShippedMotorcyclesSan FranciscoCAUSASmall1021141100144708.441/15/04 0:00ShippedMotorcyclesParisFranceMedium102233710013965.662/20/04 0:00ShippedMotorcyclesMelbourneVictoriaAustraliaMedium102372310072333.124/5/04 0:00ShippedMotorcyclesNYCNYUSASmall102512810023188.645/18/04 0:00ShippedMotorcyclesNewarkNJUSAMedium102633410023676.766/28/04 0:00ShippedMotorcyclesBridgewaterCTUSAMedium102754592.8314177.357/23/04 0:00ShippedMotorcyclesNantesFranceMedium102853610064099.688/27/04 0:00ShippedMotorcyclesCambridgeMAUSAMedium102992310092597.399/30/04 0:00ShippedMotorcyclesHelsinkiFinlandSmall103094110054394.3810/15/04 0:00ShippedMotorcyclesStavernNorwayMedium103184694.7414358.0411/2/04 0:00ShippedMotorcyclesAllentownPAUSAMedium103294210014396.1411/15/04 0:00ShippedMotorcyclesNYCNYUSAMedium103414110097737.9311/24/04 0:00ShippedMotorcyclesSalzburgAustriaLarge103612072.5513145112/17/04 0:00ShippedMotorcyclesChatswoodNSWAustraliaSmall103752134.9112733.112/3/05 0:00ShippedMotorcyclesNantesFranceSmall103884276.3643207.123/3/05 0:00ShippedMotorcyclesNew BedfordMAUSAMedium104032410072434.564/8/05 0:00ShippedMotorcyclesLiverpoolUKSmall104176610027516.085/13/05 0:00DisputedMotorcyclesMadridSpainLarge1010326100115404.621/29/03 0:00ShippedClassic CarsStavernNorwayMedium101122910017209.113/24/03 0:00ShippedClassic CarsLuleSwedenLarge1012638100117329.065/28/03 0:00ShippedClassic CarsMadridSpainLarge1014037100117374.17/24/03 0:00ShippedClassic CarsBurlingameCAUSALarge1015045100810993.59/19/03 0:00ShippedClassic CarsSingaporeSingaporeLarge101632110014860.2410/20/03 0:00ShippedClassic CarsNYCNYUSAMedium101743410048014.8211/6/03 0:00ShippedClassic CarsSouth BrisbaneQueenslandAustraliaLarge101832310085372.5711/13/03 0:00ShippedClassic CarsPhiladelphiaPAUSAMedium1019442100117290.3611/25/03 0:00ShippedClassic CarsLyonFranceLarge102064710069064.8912/5/03 0:00ShippedClassic CarsVancouverBCCanadaLarge102153510036075.31/29/04 0:00ShippedClassic CarsBurbankCAUSAMedium102282910026463.233/10/04 0:00ShippedClassic CarsCambridgeMAUSAMedium102453410096120.345/4/04 0:00ShippedClassic CarsNew HavenCTUSAMedium102583210067680.646/15/04 0:00ShippedClassic CarsMinato-kuTokyoJapanLarge102702110094905.397/19/04 0:00ShippedClassic CarsChatswoodNSWAustraliaMedium102803410028014.828/17/04 0:00ShippedClassic CarsTorinoItalyLarge1029137100117136.199/8/04 0:00ShippedClassic CarsBorasSwedenLarge1030447100610172.710/11/04 0:00ShippedClassic CarsVersaillesFranceLarge1031248100311623.710/21/04 0:00ShippedClassic CarsSan RafaelCAUSALarge103224010016000.411/4/04 0:00ShippedClassic CarsNashuaNHUSAMedium10333261003300311/18/04 0:00ShippedClassic CarsSan FranciscoCAUSAMedium103473010013944.711/29/04 0:00ShippedClassic CarsMelbourneVictoriaAustraliaMedium1035732100105691.8412/10/04 0:00ShippedClassic CarsSan RafaelCAUSAMedium103694110024514.921/20/05 0:00ShippedClassic CarsBrickhavenMAUSAMedium103813610038254.82/17/05 0:00ShippedClassic CarsSan FranciscoCAUSALarge103912410042416.563/9/05 0:00ShippedClassic CarsNorth SydneyNSWAustraliaSmall104112310094140.235/1/05 0:00ShippedClassic CarsMontrealQuebecCanadaMedium10424501006120015/31/05 0:00In ProcessClassic CarsMadridSpainLarge101073999.9153896.492/24/03 0:00ShippedMotorcyclesNYCNYUSAMedium101202996.3432793.864/29/03 0:00ShippedMotorcyclesMelbourneVictoriaAustraliaSmall101342710053307.777/1/03 0:00ShippedMotorcyclesParisFranceMedium101453710095192.958/25/03 0:00ShippedMotorcyclesPasadenaCAUSAMedium1015937100175016.8310/10/03 0:00ShippedMotorcyclesSan FranciscoCAUSAMedium101682710043660.9310/28/03 0:00ShippedMotorcyclesBurlingameCAUSAMedium1018042100124695.611/11/03 0:00ShippedMotorcyclesLilleFranceMedium101883896.3443660.9211/18/03 0:00ShippedMotorcyclesBergenNorwayMedium102012410053025.9212/1/03 0:00ShippedMotorcyclesSan FranciscoCAUSAMedium102102310023009.091/12/04 0:00ShippedMotorcyclesOsakaOsakaJapanMedium102234710045422.392/20/04 0:00ShippedMotorcyclesMelbourneVictoriaAustraliaMedium102362210012852.084/3/04 0:00ShippedMotorcyclesPhiladelphiaPAUSASmall102514410055756.525/18/04 0:00ShippedMotorcyclesNewarkNJUSAMedium1026340100544726/28/04 0:00ShippedMotorcyclesBridgewaterCTUSAMedium102752210042904.447/23/04 0:00ShippedMotorcyclesNantesFranceSmall102854710096484.598/27/04 0:00ShippedMotorcyclesCambridgeMAUSAMedium102983996.3413757.269/27/04 0:00ShippedMotorcyclesNantesFranceMedium103083410024043.9610/15/04 0:00ShippedMotorcyclesWhite PlainsNYUSAMedium103184510045566.511/2/04 0:00ShippedMotorcyclesAllentownPAUSAMedium10329201002317611/15/04 0:00ShippedMotorcyclesNYCNYUSAMedium103394068.9242756.811/23/04 0:00ShippedMotorcyclesMinato-kuTokyoJapanSmall103612651.1581329.912/17/04 0:00ShippedMotorcyclesChatswoodNSWAustraliaSmall103743910055288.012/2/05 0:00ShippedMotorcyclesSouth BrisbaneQueenslandAustraliaMedium103885044.5152225.53/3/05 0:00ShippedMotorcyclesNew BedfordMAUSASmall104024510015833.84/7/05 0:00ShippedMotorcyclesParisFranceMedium104174510055887.355/13/05 0:00DisputedMotorcyclesMadridSpainMedium101072710046065.552/24/03 0:00ShippedMotorcyclesNYCNYUSAMedium101204610029264.864/29/03 0:00ShippedMotorcyclesMelbourneVictoriaAustraliaLarge101343110047023.987/1/03 0:00ShippedMotorcyclesParisFranceLarge101453310085176.388/25/03 0:00ShippedMotorcyclesPasadenaCAUSAMedium1015922100164132.710/10/03 0:00ShippedMotorcyclesSan FranciscoCAUSAMedium10168201003418310/28/03 0:00ShippedMotorcyclesBurlingameCAUSAMedium1018041100118892.911/11/03 0:00ShippedMotorcyclesLilleFranceLarge101884510038714.711/18/03 0:00ShippedMotorcyclesBergenNorwayLarge102014910048065.8912/1/03 0:00ShippedMotorcyclesSan FranciscoCAUSALarge102103410016123.41/12/04 0:00ShippedMotorcyclesOsakaOsakaJapanMedium102234910039774.032/20/04 0:00ShippedMotorcyclesMelbourneVictoriaAustraliaLarge102373910097023.94/5/04 0:00ShippedMotorcyclesNYCNYUSALarge102514310047078.235/18/04 0:00ShippedMotorcyclesNewarkNJUSALarge102634110048336.946/28/04 0:00ShippedMotorcyclesBridgewaterCTUSALarge102753610036901.927/23/04 0:00ShippedMotorcyclesNantesFranceMedium102852710085438.078/27/04 0:00ShippedMotorcyclesCambridgeMAUSAMedium1029929100116683.349/30/04 0:00ShippedMotorcyclesHelsinkiFinlandMedium103082010014570.410/15/04 0:00ShippedMotorcyclesWhite PlainsNYUSAMedium103183710037667.1411/2/04 0:00ShippedMotorcyclesAllentownPAUSALarge103292610035868.211/15/04 0:00ShippedMotorcyclesNYCNYUSAMedium103393976.6732990.1311/23/04 0:00ShippedMotorcyclesMinato-kuTokyoJapanSmall103622210043664.11/5/05 0:00ShippedMotorcyclesBurlingameCAUSAMedium103742210013834.382/2/05 0:00ShippedMotorcyclesSouth BrisbaneQueenslandAustraliaMedium103882186.7771822.173/3/05 0:00ShippedMotorcyclesNew BedfordMAUSASmall1040366100911886.64/8/05 0:00ShippedMotorcyclesLiverpoolUKLarge104175610049218.165/13/05 0:00DisputedMotorcyclesMadridSpainLarge1010550100272082/11/03 0:00ShippedClassic CarsKobenhavnDenmarkLarge1011946100115004.84/28/03 0:00ShippedClassic CarsSalzburgAustriaMedium101293310024398.246/12/03 0:00ShippedClassic CarsLondonUKMedium1014349100155597.768/10/03 0:00ShippedClassic CarsNew BedfordMAUSAMedium1015532100134526.0810/6/03 0:00ShippedClassic CarsHelsinkiFinlandMedium101674410095924.1610/23/03 0:00CancelledClassic CarsBorasSwedenMedium1017824100123492.4811/8/03 0:00ShippedClassic CarsToulouseFranceMedium101862610093854.2411/14/03 0:00ShippedClassic CarsLondonUKMedium101974510065324.411/26/03 0:00ShippedClassic CarsBarcelonaSpainMedium102093910085197.921/9/04 0:00ShippedClassic CarsLos AngelesCAUSAMedium1022249100125997.62/19/04 0:00ShippedClassic CarsSan DiegoCAUSAMedium102482010032910.45/7/04 0:00CancelledClassic CarsNYCNYUSASmall102612710013378.246/17/04 0:00ShippedClassic CarsMontrealQuebecCanadaMedium102733010043508.87/21/04 0:00ShippedClassic CarsBruxellesBelgiumMedium1028325100629928/20/04 0:00ShippedClassic CarsTsawassenBCCanadaSmall102952410013427.29/10/04 0:00ShippedClassic CarsBostonMAUSAMedium103072210092692.810/14/04 0:00ShippedClassic CarsPhiladelphiaPAUSASmall1031633100174128.9611/1/04 0:00ShippedClassic CarsCowesIsle of WightUKMedium103254764.9363051.7111/5/04 0:00ShippedClassic CarsStavernNorwayMedium103372548.0581201.2511/21/04 0:00ShippedClassic CarsNYCNYUSASmall103502675.4751962.2212/2/04 0:00ShippedClassic CarsMadridSpainSmall103594854.6862624.6412/15/04 0:00ShippedClassic CarsReimsFranceSmall103733910034046.251/31/05 0:00ShippedClassic CarsOuluFinlandMedium103843410044846.72/23/05 0:00ShippedClassic CarsSan FranciscoCAUSAMedium103953210023370.563/17/05 0:00ShippedClassic CarsParisFranceMedium104006410099661.444/1/05 0:00ShippedClassic CarsSan JoseCAUSALarge104141910032764.885/6/05 0:00On HoldClassic CarsBostonMAUSASmall101034210045398.261/29/03 0:00ShippedClassic CarsStavernNorwayMedium101143110084305.284/1/03 0:00ShippedClassic CarsParisFranceMedium101262210043347.745/28/03 0:00ShippedClassic CarsMadridSpainMedium101402610043188.127/24/03 0:00ShippedClassic CarsBurlingameCAUSAMedium101502010013191.29/19/03 0:00ShippedClassic CarsSingaporeSingaporeMedium101642110023536.8210/21/03 0:00ResolvedClassic CarsGrazAustriaMedium101753310095362.8311/6/03 0:00ShippedClassic CarsLondonUKMedium101832810013433.3611/13/03 0:00ShippedClassic CarsPhiladelphiaPAUSAMedium101942610044263.7411/25/03 0:00ShippedClassic CarsLyonFranceMedium1020731100154076.1912/9/03 0:00ShippedClassic CarsBostonMAUSAMedium102174810047020.482/4/04 0:00ShippedClassic CarsSingaporeSingaporeLarge102295010096426.53/11/04 0:00ShippedClassic CarsSan RafaelCAUSAMedium102452810024591.725/4/04 0:00ShippedClassic CarsNew HavenCTUSAMedium1025926100124033.386/15/04 0:00ShippedClassic CarsSingaporeSingaporeMedium102703210024302.087/19/04 0:00ShippedClassic CarsChatswoodNSWAustraliaMedium102814410097020.648/19/04 0:00ShippedClassic CarsAllentownPAUSALarge102913010043855.99/8/04 0:00ShippedClassic CarsBorasSwedenMedium1030538100136680.7810/13/04 0:00ShippedClassic CarsCambridgeMAUSAMedium10313401007667810/22/04 0:00ShippedClassic CarsVancouverBCCanadaMedium103224661.9982851.5411/4/04 0:00ShippedClassic CarsNashuaNHUSASmall103342610023188.1211/19/04 0:00On HoldClassic CarsLuleSwedenMedium10347271002442811/29/04 0:00ShippedClassic CarsMelbourneVictoriaAustraliaMedium103574310095780.9212/10/04 0:00ShippedClassic CarsSan RafaelCAUSAMedium103703565.6342297.051/20/05 0:00ShippedClassic CarsNorth SydneyNSWAustraliaSmall103813710066231.542/17/05 0:00ShippedClassic CarsSan FranciscoCAUSAMedium103913746.971735.33/9/05 0:00ShippedClassic CarsNorth SydneyNSWAustraliaSmall
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started