Question

1 Approved Answer

Posted on Sep 26, 2024

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

image text in transcribed

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 sales greater than $5000 95.7 ORDERNUMBER QUANTITYORDERED PRICEEACH ERLINENUI SALES ORDERDATE STATUS PRODUCTLINE 10107 30 2 2871 2/24/2003 0:00 Shipped Motorcycles 10121 34 81.35 5 2765.9 5/7/2003 0:00 Shipped Motorcycles 10134 41 94.74 2 3884.34 7/1/2003 0:00 Shipped Motorcycles 10145 45 83.26 6 3746.7 8/25/2003 0:00 Shipped Motorcycles 10159 49 100 14 5205.27 10/10/2003 0:00 Shipped Motorcycles 10168 36 96.66 1 3479.76 10/28/2003 0:00 Shipped Motorcycles 10180 29 86.13 9 2497.77 11/11/2003 0:00 Shipped Motorcycles 10188 48 100 1 5512.32 11/18/2003 0:00 Shipped Motorcycles 10201 22 98.57 2 2 2168.54 12/1/2003 0:00 Shipped Motorcycles 10211 41 100 14 4708.44 1/15/2004 0:00 Shipped Motorcycles 10223 37 100 1 3965.66 2/20/2004 0:00 Shipped Motorcycles 10237 23 100 7 2333.12 4/5/2004 0:00 Shipped Motorcycles 10251 28 100 2 3188.64 5/18/2004 0:00 Shipped Motorcycles 10263 34 100 2 3676.76 6/28/2004 0:00 Shipped Motorcycles 10275 45 92.83 1 4177.35 7/23/2004 0:00 Shipped Motorcycles 10285 36 100 6 4099.68 8/27/2004 0:00 Shipped Motorcycles 10299 23 100 9 2597.39 9/30/2004 0:00 Shipped Motorcycles 10309 41 100 5 4394.38 10/15/2004 0:00 Shipped Motorcycles 10318 46 94.74 1 4358.04 11/2/2004 0:00 Shipped Motorcycles 10329 42 100 1 4396.14 11/15/2004 0:00 Shipped Motorcycles 10341 41 100 9 7737.93 11/24/2004 0:00 Shipped Motorcycles 10361 20 72.55 13 1451 12/17/2004 0:00 Shipped Motorcycles 10375 21 34.91 12 733.11 2/3/2005 0:00 Shipped Motorcycles 10388 42 76.36 4 3207.12 3/3/2005 0:00 Shipped Motorcycles 10403 24 100 7 2434.56 4/8/2005 0:00 Shipped Motorcycles 10417 66 100 2 7516.08 5/13/2005 0:00 Disputed Motorcycles 10103 26 100 11 5404.62 1/29/2003 0:00 Shipped Classic Cars 10112 29 100 1 7209.11 3/24/2003 0:00 Shipped Classic Cars 10126 38 100 11 7329.06 5/28/2003 0:00 Shipped Classic Cars 10140 37 100 11 7374.1 7/24/2003 0:00 Shipped Classic Cars 10150 45 100 8 10993.5 9/19/2003 0:00 Shipped Classic Cars 10163 21 100 1 4860.24 10/20/2003 0:00 Shipped Classic Cars 10174 34 100 4 8014.82 11/6/2003 0:00 Shipped Classic Cars 10183 23 100 8 5372.57 11/13/2003 0:00 Shipped Classic Cars 10194 42 100 11 7290.36 11/25/2003 0:00 Shipped Classic Cars 10206 47 100 6 9064.89 12/5/2003 0:00 Shipped Classic Cars 10215 35 100 3 6075.3 1/29/2004 0:00 Shipped Classic Cars 10228 29 100 2 6463.23 3/10/2004 0:00 Shipped Classic Cars 10245 34 100 9 6120.34 5/4/2004 0:00 Shipped Classic Cars 10258 32 100 6 7680.64 6/15/2004 0:00 Shipped Classic Cars 10270 21 100 9 4905.39 7/19/2004 0:00 Shipped Classic Cars 10280 34 100 2 8014.82 8/17/2004 0:00 Shipped Classic Cars 10291 37 100 11 7136.19 9/8/2004 0:00 Shipped Classic Cars 10304 47 100 6 10172.7 10/11/2004 0:00 Shipped Classic Cars 10312 48 100 3 11623.7 10/21/2004 0:00 Shipped Classic Cars 10322 40 100 1 6000.4 11/4/2004 0:00 Shipped Classic Cars 10333 26 100 3 3003 11/18/2004 0:00 Shipped Classic Cars CITY STATE COUNTRYDEALSIZE NYC NY USA Small Reims France Small Paris France Medium Pasadena CA USA Medium San Franci: CA USA Medium Burlingam CA USA Medium Lille France Small Bergen Norway Medium San Franci CA USA Small Paris France Medium Melbourne Victoria Australia Medium NYC NY USA Small Newark NJ USA Medium Bridgewat CT USA Medium Nantes France Medium Cambridge MA USA Medium Helsinki Finland Small Stavern Norway Medium Allentown PA USA Medium NYC NY USA Medium Salzburg Austria Large Chatswoo NSW Australia Small Nantes France Small New Bedfc MA USA Medium Liverpool UK Small Madrid Spain Large Stavern Norway Medium Lule Sweden Large Madrid Spain Large Burlingam CA Large Singapore Singapore Large NYC NY USA Medium South Brisl Queenslan Australia Large Philadelph PA USA Medium Lyon France Large Vancouver BC Canada Large Burbank CA USA Medium Cambridge MA USA Medium New Have CT USA Medium Minato-ku Tokyo Japan Large Chatswoo NSW Australia Medium Torino Italy Large Boras Sweden Large Versailles France Large San Rafael CA USA Large Nashua NH USA Medium San Franci: CA USA Medium USA 26 3 1 30 32 10333 10347 10357 10369 10381 10391 100 100 100 100 10 41 2 36 100 3 4 24 48 49 50 51 52 53 54 55 56 57 58 59 100 100 23 9 50 100 6 39 5 29 27 37 99.91 96.34 100 100 100 100 3 5 9 37 17 10411 10424 10107 10120 10134 10145 10159 10168 10180 10188 10201 10210 10223 10236 10251 60 61 27 4 62 42 100 12 38 4 24 63 64 65 66 96.34 100 100 5 23 2 47 100 4 67 22 100 1 68 44 5 100 100 10263 40 5 22 100 4 47 100 9 10275 10285 10298 10308 39 1 3003 11/18/2004 0:00 Shipped Classic Cars 3944.7 11/29/2004 0:00 Shipped Classic Cars 5691.84 12/10/2004 0:00 Shipped Classic Cars 4514.92 1/20/2005 0:00 Shipped Classic Cars 8254.8 2/17/2005 0:00 Shipped Classic Cars 2416.56 3/9/2005 0:00 Shipped Classic Cars 4140.23 5/1/2005 0:00 Shipped Classic Cars 12001 5/31/2005 0:00 In Process Classic Cars 3896.49 2/24/2003 0:00 Shipped Motorcycles 2793.86 4/29/2003 0:00 Shipped Motorcycles 3307.77 7/1/2003 0:00 Shipped Motorcycles 5192.95 8/25/2003 0:00 Shipped Motorcycles 5016.83 10/10/2003 0:00 Shipped Motorcycles 3660.93 10/28/2003 0:00 Shipped Motorcycles 4695.6 11/11/2003 0:00 Shipped Motorcycles 3660.92 11/18/2003 0:00 Shipped Motorcycles 3025.92 12/1/2003 0:00 Shipped Motorcycles 3009.09 1/12/2004 0:00 Shipped Motorcycles 5422.39 2/20/2004 0:00 Shipped Motorcycles 2852.08 4/3/2004 0:00 Shipped Motorcycles 5756.52 5/18/2004 0:00 Shipped Motorcycles 4472 6/28/2004 0:00 Shipped Motorcycles 2904.44 7/23/2004 0:00 Shipped Motorcycles 6484.59 8/27/2004 0:00 Shipped Motorcycles 3757.26 9/27/2004 0:00 Shipped Motorcycles 4043.96 10/15/2004 0:00 Shipped Motorcycles 5566.5 11/2/2004 0:00 Shipped Motorcycles 3176 11/15/2004 0:00 Shipped Motorcycles 2756.8 11/23/2004 0:00 Shipped Motorcycles 1329.9 12/17/2004 0:00 Shipped Motorcycles 5288.01 2/2/2005 0:00 Shipped Motorcycles 2225.5 3/3/2005 0:00 Shipped Motorcycles 5833.8 4/7/2005 0:00 Shipped Motorcycles 5887.35 5/13/2005 0:00 Disputed Motorcycles 6065.55 2/24/2003 0:00 Shipped Motorcycles 9264.86 4/29/2003 0:00 Shipped Motorcycles 7023.98 7/1/2003 0:00 Shipped Motorcycles 5176.38 8/25/2003 0:00 Shipped Motorcycles 4132.7 10/10/2003 0:00 Shipped Motorcycles 4183 10/28/2003 0:00 Shipped Motorcycles 8892.9 11/11/2003 0:00 Shipped Motorcycles 8714.7 11/18/2003 0:00 Shipped Motorcycles 8065.89 12/1/2003 0:00 Shipped Motorcycles 6123.4 1/12/2004 0:00 Shipped Motorcycles 9774.03 2/20/2004 0:00 Shipped Motorcycles 7023.9 4/5/2004 0:00 Shipped Motorcycles 7078.23 5/18/2004 0:00 Shipped Motorcycles 8336.94 6/28/2004 0:00 Shipped Motorcycles 6901.92 7/23/2004 0:00 Shipped Motorcycles 69 70 71 72 73 74 75 76 77 78 96.34 100 100 34 San Franci: CA USA Medium Melbourne Victoria Australia Medium San Rafael CA USA Medium Brickhaver MA USA Medium San Franci: CA USA Large North Sydr NSW Australia Small Montreal Quebec Canada Medium Madrid Spain Large NYC NY USA Medium Melbourne Victoria Australia Small Paris France Medium Pasadena CA USA Medium San Franci: CA USA Medium Burlingame CA USA Medium Lille France Medium Bergen Norway Medium San Franci: CA USA Medium Osaka Osaka Japan Medium Melbourne Victoria Australia Medium Philadelph PA USA Small Newark NJ USA Medium Bridgewat CT USA Medium Nantes France Small Cambridge MA USA Medium Nantes France Medium White Plair NY USA Medium Allentown PA USA Medium NYC NY USA Medium Minato-ku Tokyo Japan Small Chatswoo NSW Australia Small South Brisl Queenslan Australia Medium New Bedfc MA USA Small Paris France Medium Madrid Spain Medium NYC NY USA Medium Melbourne Victoria Australia Large Paris France Large Pasadena CA USA Medium San Franci: CA USA Medium Burlingam CA USA Medium Lille France Large Bergen Norway Large San Franci: CA USA Large Osaka Osaka Japan Medium Melbourne Victoria Australia Large NYC NY USA Large Newark NJ USA Large Bridgewat CT USA Large Nantes France Medium 2 45 4 20 100 2 10318 10329 10339 10361 10374 40 68.92 4 26 8 5 39 50 51.15 100 44.51 100 5 79 80 81 1 45 45 100 100 5 4 82 27 83 46 2 31 4 33 100 100 100 100 100 84 85 86 87 88 8 22 16 20 3 10388 10402 10417 10107 10120 10134 10145 10159 10168 10180 10188 10201 10210 10223 10237 10251 10263 10275 41 11 100 100 45 89 90 3 4 49 100 34 1 91 92 100 100 49 3 100 93 94 39 43 9 4 4 95 96 4 100 100 100 41 36 3 43 41 10251 10263 10275 10285 10299 100 100 100 36 27 100 29 20 100 100 100 Medium 3 100 3 10308 10318 10329 10339 10362 10374 10388 10403 37 26 39 22 22 21 66 76.67 100 100 4 1 86.77 100 9 10417 56 4 10105 10119 10129 10143 10155 50 46 33 49 32 44 24 100 100 100 100 100 94 95 96 97 98 99 100 101 702 103 104 105 106 107 108 109 710 711 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 10167 10178 10186 10197 9 London 26 45 10209 10222 10248 10261 10273 10283 39 49 20 27 30 25 4 7078.23 5/18/2004 0:00 Shipped Motorcycles 4 8336.94 6/28/2004 0:00 Shipped Motorcycles 3 6901.92 7/23/2004 0:00 Shipped Motorcycles 8 5438.07 8/27/2004 0:00 Shipped Motorcycles 11 6683.34 9/30/2004 0:00 Shipped Motorcycles 1 4570.4 10/15/2004 0:00 Shipped Motorcycles 7667.14 11/2/2004 0:00 Shipped Motorcycles 5868.2 11/15/2004 0:00 Shipped Motorcycles 3 2990.13 11/23/2004 0:00 Shipped Motorcycles 4 3664.1 1/5/2005 0:00 Shipped Motorcycles 3834.38 2/2/2005 0:00 Shipped Motorcycles 7 1822.17 3/3/2005 0:00 Shipped Motorcycles 11886.6 4/8/2005 0:00 Shipped Motorcycles 9218.16 5/13/2005 0:00 Disputed Motorcycles 2 7208 2/11/2003 0:00 Shipped Classic Cars 11 5004.8 4/28/2003 0:00 Shipped Classic Cars 2 4398.24 6/12/2003 0:00 Shipped Classic Cars 15 5597.76 8/10/2003 0:00 Shipped Classic Cars 13 4526.08 10/6/2003 0:00 Shipped Classic Cars 9 5924.16 10/23/2003 0:00 Cancelled Classic Cars 12 3492.48 11/8/2003 0:00 Shipped Classic Cars 3854.24 11/14/2003 0:00 Shipped Classic Cars 6 5324.4 11/26/2003 0:00 Shipped Classic Cars 8 5197.92 1/9/2004 0:00 Shipped Classic Cars 12 5997.6 2/19/2004 0:00 Shipped Classic Cars 3 2910.4 5/7/2004 0:00 Cancelled Classic Cars 3378.24 6/17/2004 0:00 Shipped Classic Cars 4 3508.8 7/21/2004 0:00 Shipped Classic Cars 6 2992 8/20/2004 0:00 Shipped Classic Cars 1 3427.2 9/10/2004 0:00 Shipped Classic Cars 9 2692.8 10/14/2004 0:00 Shipped Classic Cars 17 4128.96 11/1/2004 0:00 Shipped Classic Cars 6 3051.71 11/5/2004 0:00 Shipped Classic Cars 1201.25 11/21/2004 0:00 Shipped Classic Cars 5 1962.22 12/2/2004 0:00 Shipped Classic Cars 6 2624.64 12/15/2004 0:00 Shipped Classic Cars 4046.25 1/31/2005 0:00 Shipped Classic Cars 4 4846.7 2/23/2005 0:00 Shipped Classic Cars 2 2 3370.56 3/17/2005 0:00 Shipped Classic Cars 9661.44 4/1/2005 0:00 Shipped Classic Cars 3 2764.88 5/6/2005 0:00 On Hold Classic Cars 5398.26 1/29/2003 0:00 Shipped Classic Cars 4305.28 4/1/2003 0:00 Shipped Classic Cars 3347.74 5/28/2003 0:00 Shipped Classic Cars 4 3188.12 7/24/2003 0:00 Shipped Classic Cars 1 3191.2 9/19/2003 0:00 Shipped Classic Cars 2 3536.82 10/21/2003 0:00 Resolved Classic Cars 9 5362.83 11/6/2003 0:00 Shipped Classic Cars 3433.36 11/13/2003 0:00 Shipped Classic Cars Newark NJ USA Large Bridgewat CT USA Large Nantes France Medium Cambridge MA USA Medium Helsinki Finland Medium White Plaii NY USA Allentown PA USA Large NYC NY USA Medium Minato-ku Tokyo Japan Small Burlingame CA USA Medium South Brisl Queenslan Australia Medium New Bedfc MA USA Small Liverpool UK Large Madrid Spain Large Kobenhavn Denmark Large Salzburg Austria Medium London UK Medium New Bedfc MA USA Medium Helsinki Finland Medium Boras Sweden Medium Toulouse France Medium UK Medium Barcelona Spain Medium Los Angele CA USA Medium San Diego CA USA Medium NYC NY USA Small Montreal Quebec Canada Medium Bruxelles Belgium Medium Tsawasser BC Canada Small Boston MA USA Medium Philadelph PA USA Small Cowes Isle of Wig UK Medium Stavern Norway Medium NYC NY USA Small Madrid Spain Small Reims France Small Oulu Finland Medium San Franci: CA USA Medium Paris France Medium San Jose CA USA Large Boston MA USA Small Stavern Norway Medium Paris France Medium Madrid Spain Medium Burlingame CA USA Medium Singapore Singapore Medium Graz Austria Medium London UK Medium Philadelph PA USA Medium 100 100 100 100 100 100 100 100 100 100 100 100 100 100 64.93 48.05 75.47 54.68 100 100 100 100 1 4 10295 24 22 33 47 25 8 10307 10316 10325 10337 10350 10359 10373 10384 10395 26 48 39 3 34 32 64 19 10400 10414 9 100 42 4 31 8 737 22 4 10103 10114 10126 10140 10150 10164 10175 10183 738 139 140 141 142 26 20 100 100 100 100 100 100 100 21 33 28 100 1 26 5 48 6 39 3 Madrid Reims Oulu San Franci: CA Paris 34 4 75.47 54.68 100 100 100 100 100 100 100 32 2 64 9 19 3 4 42 31 8 100 4 10350 10359 10373 10384 10395 10400 10414 10103 10114 10126 10140 10150 10164 10175 10183 10194 10207 10217 10229 10245 22 26 100 4 20 100 1 100 2 100 9 100 1 100 4 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 21 33 28 26 31 48 50 28 100 15 1962.22 12/2/2004 0:00 Shipped Classic Cars 2624.64 12/15/2004 0:00 Shipped Classic Cars 4046.25 1/31/2005 0:00 Shipped Classic Cars 4846.7 2/23/2005 0:00 Shipped Classic Cars 3370.56 3/17/2005 0:00 Shipped Classic Cars 9661.44 4/1/2005 0:00 Shipped Classic Cars 2764.88 5/6/2005 0:00 On Hold Classic Cars 5398.26 1/29/2003 0:00 Shipped Classic Cars 4305.28 4/1/2003 0:00 Shipped Classic Cars 3347.74 5/28/2003 0:00 Shipped Classic Cars 3188.12 7/24/2003 0:00 Shipped Classic Cars 3191.2 9/19/2003 0:00 Shipped Classic Cars 3536.82 10/21/2003 0:00 Resolved Classic Cars 5362.83 11/6/2003 0:00 Shipped Classic Cars 3433.36 11/13/2003 0:00 Shipped Classic Cars 4263.74 11/25/2003 0:00 Shipped Classic Cars 4076.19 12/9/2003 0:00 Shipped Classic Cars 7020.48 2/4/2004 0:00 Shipped Classic Cars 6426.5 3/11/2004 0:00 Shipped Classic Cars 4591.72 5/4/2004 0:00 Shipped Classic Cars 4033.38 6/15/2004 0:00 Shipped Classic Cars 4302.08 7/19/2004 0:00 Shipped Classic Cars 7020.64 8/19/2004 0:00 Shipped Classic Cars 3855.9 9/8/2004 0:00 Shipped Classic Cars 6680.78 10/13/2004 0:00 Shipped Classic Cars 6678 10/22/2004 0:00 Shipped Classic Cars 2851.54 11/4/2004 0:00 Shipped Classic Cars 3188.12 11/19/2004 0:00 On Hold Classic Cars 4428 11/29/2004 0:00 Shipped Classic Cars 5780.92 12/10/2004 0:00 Shipped Classic Cars 2297.05 1/20/2005 0:00 Shipped Classic Cars 6231.54 2/17/2005 0:00 Shipped Classic Cars 1735.3 3/9/2005 0:00 Shipped Classic Cars Spain Small France Small Finland Medium USA Medium France Medium USA Large USA Small Norway Medium France Medium Spain Medium USA Medium Singapore Medium Austria Medium UK Medium USA Medium France Medium USA Medium Singapore Large Medium USA Medium Singapore Medium Australia Medium USA Large Sweden Medium USA Medium Canada Medium USA Small Sweden Medium Australia Medium USA Medium Australia Small USA Medium Australia Small 100 4 9 USA San Jose CA Boston MA Stavern Paris Madrid Burlingam CA Singapore Graz London Philadelph PA Lyon Boston MA Singapore San Rafael CA New Have CT Singapore Chatswoo: NSW Allentown PA Boras Cambridge MA Vancouver BC Nashua NH Lule Melbourne Victoria San Rafael CA North Sydr NSW San Franci: CA North Sydr NSW 100 100 2 10259 26 100 12 10270 32 2 10281 44 100 100 100 100 9 4 10291 30 10305 13 38 40 10313 7 10322 46 8 100 61.99 100 100 10334 26 2 10347 27 2 43 9 10357 10370 35 4 100 65.63 100 46.9 10381 37 6 10391 37 7