Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
snigrini
Starting Member
4 Posts |
 Posted - 2015-05-06 : 06:53:00
|
| Hi. Can someone please help me with the following query? It is as follows:Display all the distinct orders where the quantity is in the bottom quartile (in otherwords, show all the orders which is in the lowest quarter of orders – lowest 25%).I have the following data:Columns:[OrderID],[ProductID],[UnitPrice],[Quantity],[Discount] 10248 42 9.80 10 0OrderID ProductID UnitPrice Quantity Discount10248 11 14.00 12 010248 42 9.80 10 010248 72 34.80 5 010249 14 18.60 9 010249 51 42.40 40 010250 41 7.70 10 010250 51 42.40 35 0.1510250 65 16.80 15 0.1510251 22 16.80 6 0.0510251 57 15.60 15 0.0510251 65 16.80 20 010252 20 64.80 40 0.0510252 33 2.00 25 0.0510252 60 27.20 40 010253 31 10.00 20 010253 39 14.40 42 010253 49 16.00 40 010254 24 3.60 15 0.1510254 55 19.20 21 0.1510254 74 8.00 21 010255 2 15.20 20 010255 16 13.90 35 010255 36 15.20 25 010255 59 44.00 30 010256 53 26.20 15 010256 77 10.40 12 010257 27 35.10 25 010257 39 14.40 6 010257 77 10.40 15 010258 2 15.20 50 0.210258 5 17.00 65 0.210258 32 25.60 6 0.210259 21 8.00 10 010259 37 20.80 1 010260 41 7.70 16 0.2510260 57 15.60 50 010260 62 39.40 15 0.2510260 70 12.00 21 0.2510261 21 8.00 20 010261 35 14.40 20 010262 5 17.00 12 0.210262 7 24.00 15 010262 56 30.40 2 010263 16 13.90 60 0.2510263 24 3.60 28 010263 30 20.70 60 0.2510263 74 8.00 36 0.2510264 2 15.20 35 010264 41 7.70 25 0.1510265 17 31.20 30 010265 70 12.00 20 010266 12 30.40 12 0.0510267 40 14.70 50 010267 59 44.00 70 0.1510267 76 14.40 15 0.1510268 29 99.00 10 010268 72 27.80 4 010269 33 2.00 60 0.0510269 72 27.80 20 0.0510270 36 15.20 30 010270 43 36.80 25 010271 33 2.00 24 010272 20 64.80 6 010272 31 10.00 40 010272 72 27.80 24 010273 10 24.80 24 0.0510273 31 10.00 15 0.0510273 33 2.00 20 010273 40 14.70 60 0.0510273 76 14.40 33 0.0510274 71 17.20 20 010274 72 27.80 7 010275 24 3.60 12 0.0510275 59 44.00 6 0.0510276 10 24.80 15 010276 13 4.80 10 010277 28 36.40 20 010277 62 39.40 12 010278 44 15.50 16 010278 59 44.00 15 010278 63 35.10 8 010278 73 12.00 25 010279 17 31.20 15 0.2510280 24 3.60 12 010280 55 19.20 20 010280 75 6.20 30 010281 19 7.30 1 010281 24 3.60 6 010281 35 14.40 4 010282 30 20.70 6 010282 57 15.60 2 010283 15 12.40 20 010283 19 7.30 18 010283 60 27.20 35 010283 72 27.80 3 010284 27 35.10 15 0.2510284 44 15.50 21 010284 60 27.20 20 0.2510284 67 11.20 5 0.2510285 1 14.40 45 0.210285 40 14.70 40 0.210285 53 26.20 36 0.210286 35 14.40 100 010286 62 39.40 40 010287 16 13.90 40 0.1510287 34 11.20 20 010287 46 9.60 15 0.1510288 54 5.90 10 0.110288 68 10.00 3 0.110289 3 8.00 30 010289 64 26.60 9 010290 5 17.00 20 010290 29 99.00 15 010290 49 16.00 15 010290 77 10.40 10 010291 13 4.80 20 0.110291 44 15.50 24 0.110291 51 42.40 2 0.110292 20 64.80 20 010293 18 50.00 12 010293 24 3.60 10 010293 63 35.10 5 010293 75 6.20 6 010294 1 14.40 18 010294 17 31.20 15 010294 43 36.80 15 010294 60 27.20 21 010294 75 6.20 6 010295 56 30.40 4 010296 11 16.80 12 010296 16 13.90 30 010296 69 28.80 15 010297 39 14.40 60 010297 72 27.80 20 010298 2 15.20 40 010298 36 15.20 40 0.2510298 59 44.00 30 0.2510298 62 39.40 15 010299 19 7.30 15 010299 70 12.00 20 010300 66 13.60 30 010300 68 10.00 20 010301 40 14.70 10 010301 56 30.40 20 010302 17 31.20 40 010302 28 36.40 28 010302 43 36.80 12 010303 40 14.70 40 0.110303 65 16.80 30 0.110303 68 10.00 15 0.110304 49 16.00 30 010304 59 44.00 10 010304 71 17.20 2 010305 18 50.00 25 0.110305 29 99.00 25 0.110305 39 14.40 30 0.110306 30 20.70 10 010306 53 26.20 10 010306 54 5.90 5 010307 62 39.40 10 010307 68 10.00 3 010308 69 28.80 1 010308 70 12.00 5 010309 4 17.60 20 010309 6 20.00 30 010309 42 11.20 2 010309 43 36.80 20 010309 71 17.20 3 010310 16 13.90 10 010310 62 39.40 5 010311 42 11.20 6 010311 69 28.80 7 010312 28 36.40 4 010312 43 36.80 24 010312 53 26.20 20 010312 75 6.20 10 010313 36 15.20 12 010314 32 25.60 40 0.110314 58 10.60 30 0.110314 62 39.40 25 0.110315 34 11.20 14 010315 70 12.00 30 010316 41 7.70 10 010316 62 39.40 70 010317 1 14.40 20 010318 41 7.70 20 010318 76 14.40 6 010319 17 31.20 8 010319 28 36.40 14 010319 76 14.40 30 010320 71 17.20 30 010321 35 14.40 10 010322 52 5.60 20 010323 15 12.40 5 010323 25 11.20 4 010323 39 14.40 4 010324 16 13.90 21 0.1510324 35 14.40 70 0.1510324 46 9.60 30 010324 59 44.00 40 0.1510324 63 35.10 80 0.1510325 6 20.00 6 010325 13 4.80 12 010325 14 18.60 9 010325 31 10.00 4 010325 72 27.80 40 010326 4 17.60 24 010326 57 15.60 16 010326 75 6.20 50 010327 2 15.20 25 0.210327 11 16.80 50 0.210327 30 20.70 35 0.210327 58 10.60 30 0.210328 59 44.00 9 010328 65 16.80 40 010328 68 10.00 10 010329 19 7.30 10 0.0510329 30 20.70 8 0.0510329 38 210.80 20 0.0510329 56 30.40 12 0.0510330 26 24.90 50 0.1510330 72 27.80 25 0.1510331 54 5.90 15 010332 18 50.00 40 0.210332 42 11.20 10 0.210332 47 7.60 16 0.210333 14 18.60 10 010333 21 8.00 10 0.110333 71 17.20 40 0.110334 52 5.60 8 010334 68 10.00 10 010335 2 15.20 7 0.210335 31 10.00 25 0.210335 32 25.60 6 0.210335 51 42.40 48 0.210336 4 17.60 18 0.110337 23 7.20 40 010337 26 24.90 24 010337 36 15.20 20 010337 37 20.80 28 010337 72 27.80 25 010338 17 31.20 20 010338 30 20.70 15 010339 4 17.60 10 010339 17 31.20 70 0.0510339 62 39.40 28 010340 18 50.00 20 0.0510340 41 7.70 12 0.0510340 43 36.80 40 0.0510341 33 2.00 8 010341 59 44.00 9 0.1510342 2 15.20 24 0.210342 31 10.00 56 0.210342 36 15.20 40 0.210342 55 19.20 40 0.210343 64 26.60 50 010343 68 10.00 4 0.0510343 76 14.40 15 010344 4 17.60 35 010344 8 32.00 70 0.2510345 8 32.00 70 010345 19 7.30 80 010345 42 11.20 9 010346 17 31.20 36 0.110346 56 30.40 20 010347 25 11.20 10 010347 39 14.40 50 0.1510347 40 14.70 4 010347 75 6.20 6 0.1510348 1 14.40 15 0.1510348 23 7.20 25 010349 54 5.90 24 010350 50 13.00 15 0.110350 69 28.80 18 0.110351 38 210.80 20 0.0510351 41 7.70 13 010351 44 15.50 77 0.0510351 65 16.80 10 0.0510352 24 3.60 10 010352 54 5.90 20 0.1510353 11 16.80 12 0.210353 38 210.80 50 0.210354 1 14.40 12 010354 29 99.00 4 010355 24 3.60 25 010355 57 15.60 25 010356 31 10.00 30 010356 55 19.20 12 010356 69 28.80 20 010357 10 24.80 30 0.210357 26 24.90 16 010357 60 27.20 8 0.210358 24 3.60 10 0.0510358 34 11.20 10 0.0510358 36 15.20 20 0.0510359 16 13.90 56 0.0510359 31 10.00 70 0.0510359 60 27.20 80 0.0510360 28 36.40 30 010360 29 99.00 35 010360 38 210.80 10 010360 49 16.00 35 010360 54 5.90 28 010361 39 14.40 54 0.110361 60 27.20 55 0.110362 25 11.20 50 010362 51 42.40 20 010362 54 5.90 24 010363 31 10.00 20 010363 75 6.20 12 010363 76 14.40 12 010364 69 28.80 30 010364 71 17.20 5 010365 11 16.80 24 010366 65 16.80 5 010366 77 10.40 5 010367 34 11.20 36 010367 54 5.90 18 010367 65 16.80 15 010367 77 10.40 7 010368 21 8.00 5 0.110368 28 36.40 13 0.110368 57 15.60 25 010368 64 26.60 35 0.110369 29 99.00 20 010369 56 30.40 18 0.2510370 1 14.40 15 0.1510370 64 26.60 30 010370 74 8.00 20 0.1510371 36 15.20 6 0.210372 20 64.80 12 0.2510372 38 210.80 40 0.2510372 60 27.20 70 0.2510372 72 27.80 42 0.2510373 58 10.60 80 0.210373 71 17.20 50 0.210374 31 10.00 30 010374 58 10.60 15 010375 14 18.60 15 010375 54 5.90 10 010376 31 10.00 42 0.0510377 28 36.40 20 0.1510377 39 14.40 20 0.1510378 71 17.20 6 010379 41 7.70 8 0.110379 63 35.10 16 0.110379 65 16.80 20 0.110380 30 20.70 18 0.110380 53 26.20 20 0.110380 60 27.20 6 0.110380 70 12.00 30 010381 74 8.00 14 010382 5 17.00 32 010382 18 50.00 9 010382 29 99.00 14 010382 33 2.00 60 010382 74 8.00 50 010383 13 4.80 20 010383 50 13.00 15 010383 56 30.40 20 010384 20 64.80 28 010384 60 27.20 15 010385 7 24.00 10 0.210385 60 27.20 20 0.210385 68 10.00 8 0.210386 24 3.60 15 010386 34 11.20 10 010387 24 3.60 15 010387 28 36.40 6 010387 59 44.00 12 010387 71 17.20 15 010388 45 7.60 15 0.210388 52 5.60 20 0.210388 53 26.20 40 010389 10 24.80 16 010389 55 19.20 15 010389 62 39.40 20 010389 70 12.00 30 010390 31 10.00 60 0.110390 35 14.40 40 0.110390 46 9.60 45 010390 72 27.80 24 0.110391 13 4.80 18 010392 69 28.80 50 010393 2 15.20 25 0.2510393 14 18.60 42 0.2510393 25 11.20 7 0.2510393 26 24.90 70 0.2510393 31 10.00 32 010394 13 4.80 10 010394 62 39.40 10 010395 46 9.60 28 0.110395 53 26.20 70 0.110395 69 28.80 8 010396 23 7.20 40 010396 71 17.20 60 010396 72 27.80 21 010397 21 8.00 10 0.1510397 51 42.40 18 0.1510398 35 14.40 30 010398 55 19.20 120 0.110399 68 10.00 60 010399 71 17.20 30 010399 76 14.40 35 010399 77 10.40 14 010400 29 99.00 21 010400 35 14.40 35 010400 49 16.00 30 010401 30 20.70 18 010401 56 30.40 70 010401 65 16.80 20 010401 71 17.20 60 010402 23 7.20 60 010402 63 35.10 65 010403 16 13.90 21 0.1510403 48 10.20 70 0.1510404 26 24.90 30 0.0510404 42 11.20 40 0.0510404 49 16.00 30 0.0510405 3 8.00 50 010406 1 14.40 10 010406 21 8.00 30 0.110406 28 36.40 42 0.110406 36 15.20 5 0.110406 40 14.70 2 0.110407 11 16.80 30 010407 69 28.80 15 010407 71 17.20 15 010408 37 20.80 10 010408 54 5.90 6 010408 62 39.40 35 010409 14 18.60 12 010409 21 8.00 12 010410 33 2.00 49 010410 59 44.00 16 010411 41 7.70 25 0.210411 44 15.50 40 0.210411 59 44.00 9 0.210412 14 18.60 20 0.110413 1 14.40 24 010413 62 39.40 40 010413 76 14.40 14 010414 19 7.30 18 0.0510414 33 2.00 50 010415 17 31.20 2 010415 33 2.00 20 010416 19 7.30 20 010416 53 26.20 10 010416 57 15.60 20 010417 38 210.80 50 010417 46 9.60 2 0.2510417 68 10.00 36 0.2510417 77 10.40 35 010418 2 15.20 60 010418 47 7.60 55 010418 61 22.80 16 010418 74 8.00 15 010419 60 27.20 60 0.0510419 69 28.80 20 0.0510420 9 77.60 20 0.110420 13 4.80 2 0.110420 70 12.00 8 0.110420 73 12.00 20 0.110421 19 7.30 4 0.1510421 26 24.90 30 010421 53 26.20 15 0.1510421 77 10.40 10 0.1510422 26 24.90 2 010423 31 10.00 14 010423 59 44.00 20 010424 35 14.40 60 0.210424 38 210.80 49 0.210424 68 10.00 30 0.210425 55 19.20 10 0.2510425 76 14.40 20 0.2510426 56 30.40 5 010426 64 26.60 7 010427 14 18.60 35 010428 46 9.60 20 010429 50 13.00 40 010429 63 35.10 35 0.2510430 17 31.20 45 0.210430 21 8.00 50 010430 56 30.40 30 010430 59 44.00 70 0.210431 17 31.20 50 0.2510431 40 14.70 50 0.2510431 47 7.60 30 0.2510432 26 24.90 10 010432 54 5.90 40 010433 56 30.40 28 010434 11 16.80 6 010434 76 14.40 18 0.1510435 2 15.20 10 010435 22 16.80 12 010435 72 27.80 10 010436 46 9.60 5 010436 56 30.40 40 0.110436 64 26.60 30 0.110436 75 6.20 24 0.110437 53 26.20 15 010438 19 7.30 15 0.210438 34 11.20 20 0.210438 57 15.60 15 0.210439 12 30.40 15 010439 16 13.90 16 010439 64 26.60 6 010439 74 8.00 30 010440 2 15.20 45 0.1510440 16 13.90 49 0.1510440 29 99.00 24 0.1510440 61 22.80 90 0.1510441 27 35.10 50 010442 11 16.80 30 010442 54 5.90 80 010442 66 13.60 60 010443 11 16.80 6 0.210443 28 36.40 12 010444 17 31.20 10 010444 26 24.90 15 010444 35 14.40 8 010444 41 7.70 30 010445 39 14.40 6 010445 54 5.90 15 010446 19 7.30 12 0.110446 24 3.60 20 0.110446 31 10.00 3 0.110446 52 5.60 15 0.110447 19 7.30 40 010447 65 16.80 35 010447 71 17.20 2 010448 26 24.90 6 010448 40 14.70 20 010449 10 24.80 14 010449 52 5.60 20 010449 62 39.40 35 010450 10 24.80 20 0.210450 54 5.90 6 0.210451 55 19.20 120 0.110451 64 26.60 35 0.110451 65 16.80 28 0.110451 77 10.40 55 0.110452 28 36.40 15 010452 44 15.50 100 0.0510453 48 10.20 15 0.110453 70 12.00 25 0.110454 16 13.90 20 0.210454 33 2.00 20 0.210454 46 9.60 10 0.210455 39 14.40 20 010455 53 26.20 50 010455 61 22.80 25 010455 71 17.20 30 010456 21 8.00 40 0.1510456 49 16.00 21 0.1510457 59 44.00 36 010458 26 24.90 30 010458 28 36.40 30 010458 43 36.80 20 010458 56 30.40 15 010458 71 17.20 50 010459 7 24.00 16 0.0510459 46 9.60 20 0.0510459 72 27.80 40 010460 68 10.00 21 0.2510460 75 6.20 4 0.2510461 21 8.00 40 0.2510461 30 20.70 28 0.2510461 55 19.20 60 0.2510462 13 4.80 1 010462 23 7.20 21 010463 19 7.30 21 010463 42 11.20 50 010464 4 17.60 16 0.210464 43 36.80 3 010464 56 30.40 30 0.210464 60 27.20 20 010465 24 3.60 25 010465 29 99.00 18 0.110465 40 14.70 20 010465 45 7.60 30 0.110465 50 13.00 25 010466 11 16.80 10 010466 46 9.60 5 010467 24 3.60 28 010467 25 11.20 12 010468 30 20.70 8 010468 43 36.80 15 010469 2 15.20 40 0.1510469 16 13.90 35 0.1510469 44 15.50 2 0.1510470 18 50.00 30 010470 23 7.20 15 010470 64 26.60 8 010471 7 24.00 30 010471 56 30.40 20 010472 24 3.60 80 0.0510472 51 42.40 18 010473 33 2.00 12 010473 71 17.20 12 010474 14 18.60 12 010474 28 36.40 18 010474 40 14.70 21 010474 75 6.20 10 010475 31 10.00 35 0.1510475 66 13.60 60 0.1510475 76 14.40 42 0.1510476 55 19.20 2 0.0510476 70 12.00 12 010477 1 14.40 15 010477 21 8.00 21 0.2510477 39 14.40 20 0.2510478 10 24.80 20 0.0510479 38 210.80 30 010479 53 26.20 28 010479 59 44.00 60 010479 64 26.60 30 010480 47 7.60 30 010480 59 44.00 12 010481 49 16.00 24 010481 60 27.20 40 010482 40 14.70 10 010483 34 11.20 35 0.0510483 77 10.40 30 0.0510484 21 8.00 14 010484 40 14.70 10 010484 51 42.40 3 010485 2 15.20 20 0.110485 3 8.00 20 0.110485 55 19.20 30 0.110485 70 12.00 60 0.110486 11 16.80 5 010486 51 42.40 25 010486 74 8.00 16 010487 19 7.30 5 010487 26 24.90 30 010487 54 5.90 24 0.2510488 59 44.00 30 010488 73 12.00 20 0.210489 11 16.80 15 0.2510489 16 13.90 18 010490 59 44.00 60 010490 68 10.00 30 010490 75 6.20 36 010491 44 15.50 15 0.1510491 77 10.40 7 0.1510492 25 11.20 60 0.0510492 42 11.20 20 0.0510493 65 16.80 15 0.110493 66 13.60 10 0.110493 69 28.80 10 0.110494 56 30.40 30 010495 23 7.20 10 010495 41 7.70 20 010495 77 10.40 5 010496 31 10.00 20 0.0510497 56 30.40 14 010497 72 27.80 25 010497 77 10.40 25 010498 24 4.50 14 010498 40 18.40 5 010498 42 14.00 30 010499 28 45.60 20 010499 49 20.00 25 010500 15 15.50 12 0.0510500 28 45.60 8 0.0510501 54 7.45 20 010502 45 9.50 21 010502 53 32.80 6 010502 67 14.00 30 010503 14 23.25 70 010503 65 21.05 20 010504 2 19.00 12 010504 21 10.00 12 010504 53 32.80 10 010504 61 28.50 25 010505 62 49.30 3 010506 25 14.00 18 0.110506 70 15.00 14 0.110507 43 46.00 15 0.1510507 48 12.75 15 0.1510508 13 6.00 10 010508 39 18.00 10 010509 28 45.60 3 010510 29 123.79 36 010510 75 7.75 36 0.110511 4 22.00 50 0.1510511 7 30.00 50 0.1510511 8 40.00 10 0.1510512 24 4.50 10 0.1510512 46 12.00 9 0.1510512 47 9.50 6 0.1510512 60 34.00 12 0.1510513 21 10.00 40 0.210513 32 32.00 50 0.210513 61 28.50 15 0.210514 20 81.00 39 010514 28 45.60 35 010514 56 38.00 70 010514 65 21.05 39 010514 75 7.75 50 010515 9 97.00 16 0.1510515 16 17.45 50 010515 27 43.90 120 010515 33 2.50 16 0.1510515 60 34.00 84 0.1510516 18 62.50 25 0.110516 41 9.65 80 0.110516 42 14.00 20 010517 52 7.00 6 010517 59 55.00 4 010517 70 15.00 6 010518 24 4.50 5 010518 38 263.50 15 010518 44 19.45 9 010519 10 31.00 16 0.0510519 56 38.00 40 010519 60 34.00 10 0.0510520 24 4.50 8 010520 53 32.80 5 010521 35 18.00 3 010521 41 9.65 10 010521 68 12.50 6 010522 1 18.00 40 0.210522 8 40.00 24 010522 30 25.89 20 0.210522 40 18.40 25 0.210523 17 39.00 25 0.110523 20 81.00 15 0.110523 37 26.00 18 0.110523 41 9.65 6 0.110524 10 31.00 2 010524 30 25.89 10 010524 43 46.00 60 010524 54 7.45 15 010525 36 19.00 30 010525 40 18.40 15 0.110526 1 18.00 8 0.1510526 13 6.00 10 010526 56 38.00 30 0.1510527 4 22.00 50 0.110527 36 19.00 30 0.110528 11 21.00 3 010528 33 2.50 8 0.210528 72 34.80 9 010529 55 24.00 14 010529 68 12.50 20 010529 69 36.00 10 010530 17 39.00 40 010530 43 46.00 25 010530 61 28.50 20 010530 76 18.00 50 010531 59 55.00 2 010532 30 25.89 15 010532 66 17.00 24 010533 4 22.00 50 0.0510533 72 34.80 24 010533 73 15.00 24 0.0510534 30 25.89 10 010534 40 18.40 10 0.210534 54 7.45 10 0.210535 11 21.00 50 0.110535 40 18.40 10 0.110535 57 19.50 5 0.110535 59 55.00 15 0.110536 12 38.00 15 0.2510536 31 12.50 20 010536 33 2.50 30 010536 60 34.00 35 0.2510537 31 12.50 30 010537 51 53.00 6 010537 58 13.25 20 010537 72 34.80 21 010537 73 15.00 9 010538 70 15.00 7 010538 72 34.80 1 010539 13 6.00 8 010539 21 10.00 15 010539 33 2.50 15 010539 49 20.00 6 010540 3 10.00 60 010540 26 31.23 40 010540 38 263.50 30 010540 68 12.50 35 010541 24 4.50 35 0.110541 38 263.50 4 0.110541 65 21.05 36 0.110541 71 21.50 9 0.110542 11 21.00 15 0.0510542 54 7.45 24 0.0510543 12 38.00 30 0.1510543 23 9.00 70 0.1510544 28 45.60 7 010544 67 14.00 7 010545 11 21.00 10 010546 7 30.00 10 010546 35 18.00 30 010546 62 49.30 40 010547 32 32.00 24 0.1510547 36 19.00 60 010548 34 14.00 10 0.2510548 41 9.65 14 010549 31 12.50 55 0.1510549 45 9.50 100 0.1510549 51 53.00 48 0.1510550 17 39.00 8 0.110550 19 9.20 10 010550 21 10.00 6 0.110550 61 28.50 10 0.110551 16 17.45 40 0.1510551 35 18.00 20 0.1510551 44 19.45 40 010552 69 36.00 18 010552 75 7.75 30 010553 11 21.00 15 010553 16 17.45 14 010553 22 21.00 24 010553 31 12.50 30 010553 35 18.00 6 010554 16 17.45 30 0.0510554 23 9.00 20 0.0510554 62 49.30 20 0.0510554 77 13.00 10 0.0510555 14 23.25 30 0.210555 19 9.20 35 0.210555 24 4.50 18 0.210555 51 53.00 20 0.210555 56 38.00 40 0.210556 72 34.80 24 010557 64 33.25 30 010557 75 7.75 20 010558 47 9.50 25 010558 51 53.00 20 010558 52 7.00 30 010558 53 32.80 18 010558 73 15.00 3 010559 41 9.65 12 0.0510559 55 24.00 18 0.0510560 30 25.89 20 010560 62 49.30 15 0.2510561 44 19.45 10 010561 51 53.00 50 010562 33 2.50 20 0.110562 62 49.30 10 0.110563 36 19.00 25 010563 52 7.00 70 010564 17 39.00 16 0.0510564 31 12.50 6 0.0510564 55 24.00 25 0.0510565 24 4.50 25 0.110565 64 33.25 18 0.110566 11 21.00 35 0.1510566 18 62.50 18 0.1510566 76 18.00 10 010567 31 12.50 60 0.210567 51 53.00 3 010567 59 55.00 40 0.210568 10 31.00 5 010569 31 12.50 35 0.210569 76 18.00 30 010570 11 21.00 15 0.0510570 56 38.00 60 0.0510571 14 23.25 11 0.1510571 42 14.00 28 0.1510572 16 17.45 12 0.110572 32 32.00 10 0.110572 40 18.40 50 010572 75 7.75 15 0.110573 17 39.00 18 010573 34 14.00 40 010573 53 32.80 25 010574 33 2.50 14 010574 40 18.40 2 010574 62 49.30 10 010574 64 33.25 6 010575 59 55.00 12 010575 63 43.90 6 010575 72 34.80 30 010575 76 18.00 10 010576 1 18.00 10 010576 31 12.50 20 010576 44 19.45 21 010577 39 18.00 10 010577 75 7.75 20 010577 77 13.00 18 010578 35 18.00 20 010578 57 19.50 6 010579 15 15.50 10 010579 75 7.75 21 010580 14 23.25 15 0.0510580 41 9.65 9 0.0510580 65 21.05 30 0.0510581 75 7.75 50 0.210582 57 19.50 4 010582 76 18.00 14 010583 29 123.79 10 010583 60 34.00 24 0.1510583 69 36.00 10 0.1510584 31 12.50 50 0.0510585 47 9.50 15 010586 52 7.00 4 0.1510587 26 31.23 6 010587 35 18.00 20 010587 77 13.00 20 010588 18 62.50 40 0.210588 42 14.00 100 0.210589 35 18.00 4 010590 1 18.00 20 010590 77 13.00 60 0.0510591 3 10.00 14 010591 7 30.00 10 010591 54 7.45 50 010592 15 15.50 25 0.0510592 26 31.23 5 0.0510593 20 81.00 21 0.210593 69 36.00 20 0.210593 76 18.00 4 0.210594 52 7.00 24 010594 58 13.25 30 010595 35 18.00 30 0.2510595 61 28.50 120 0.2510595 69 36.00 65 0.2510596 56 38.00 5 0.210596 63 43.90 24 0.210596 75 7.75 30 0.210597 24 4.50 35 0.210597 57 19.50 20 010597 65 21.05 12 0.210598 27 43.90 50 010598 71 21.50 9 010599 62 49.30 10 010600 54 7.45 4 010600 73 15.00 30 010601 13 6.00 60 010601 59 55.00 35 010602 77 13.00 5 0.2510603 22 21.00 48 010603 49 20.00 25 0.0510604 48 12.75 6 0.110604 76 18.00 10 0.110605 16 17.45 30 0.0510605 59 55.00 20 0.0510605 60 34.00 70 0.0510605 71 21.50 15 0.0510606 4 22.00 20 0.210606 55 24.00 20 0.210606 62 49.30 10 0.210607 7 30.00 45 010607 17 39.00 100 010607 33 2.50 14 010607 40 18.40 42 010607 72 34.80 12 010608 56 38.00 28 010609 1 18.00 3 010609 10 31.00 10 010609 21 10.00 6 010610 36 19.00 21 0.2510611 1 18.00 6 010611 2 19.00 10 010611 60 34.00 15 010612 10 31.00 70 010612 36 19.00 55 010612 49 20.00 18 010612 60 34.00 40 010612 76 18.00 80 010613 13 6.00 8 0.110613 75 7.75 40 010614 11 21.00 14 010614 21 10.00 8 010614 39 18.00 5 010615 55 24.00 5 010616 38 263.50 15 0.0510616 56 38.00 14 010616 70 15.00 15 0.0510616 71 21.50 15 0.0510617 59 55.00 30 0.1510618 6 25.00 70 010618 56 38.00 20 010618 68 12.50 15 010619 21 10.00 42 010619 22 21.00 40 010620 24 4.50 5 010620 52 7.00 5 010621 19 9.20 5 010621 23 9.00 10 010621 70 15.00 20 010621 71 21.50 15 010622 2 19.00 20 010622 68 12.50 18 0.210623 14 23.25 21 010623 19 9.20 15 0.110623 21 10.00 25 0.110623 24 4.50 3 010623 35 18.00 30 0.110624 28 45.60 10 010624 29 123.79 6 010624 44 19.45 10 010625 14 23.25 3 010625 42 14.00 5 010625 60 34.00 10 0An example of how the output should look is: OrderID ProductID10602 77and there should be 263 results displayed.Thank-you |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2015-05-06 : 10:33:27
|
do you mean this?SELECT * FROM (SELECT *,NTILE(4) OVER(ORDER BY Quantity) AS Quartile FROM Tbl)s WHERE Quartile = 1 |
 |
|
|
snigrini
Starting Member
4 Posts |
Posted - 2015-05-07 : 12:14:15
|
| Hi James.That does not give me the correct answer. The answer that it gives me is as follows:ProductID OrderIDUnitPrice Discount Quantity 37 10259 20.80 1 0 119 10281 7.30 1 0 169 10308 28.80 1 0 113 10462 4.80 1 0 172 10538 34.80 1 0 159 10665 55.00 1 0 131 10782 12.50 1 0 140 10807 18.40 1 0 130 10917 25.89 1 0 14 11077 22.00 1 0 16 11077 25.00 1 0.02 17 11077 30.00 1 0.05 110 11077 31.00 1 0 114 11077 23.25 1 0.03 120 11077 81.00 1 0.04 132 11077 32.00 1 0 166 11077 17.00 1 0 173 11077 15.00 2 0.01 177 11077 13.00 2 0 152 11077 7.00 2 0 155 11077 24.00 2 0 160 11077 34.00 2 0.06 164 11077 33.25 2 0.03 139 11077 18.00 2 0.05 123 11077 9.00 2 0 116 11077 17.45 2 0.03 112 11077 38.00 2 0.05 18 11077 40.00 2 0.1 176 11075 18.00 2 0.15 152 11038 7.00 2 0 111 10926 21.00 2 0 153 10933 32.80 2 0 128 10952 45.60 2 0 160 10963 34.00 2 0.15 172 10992 34.80 2 0 11 11005 18.00 2 0 129 11006 123.79 2 0.25 168 11013 12.50 2 0 149 11019 20.00 2 0 165 10806 21.05 2 0 162 10798 49.30 2 0 138 10828 263.50 2 0 119 10831 9.20 2 0 177 10835 13.00 2 0.2 151 10870 53.00 2 0 139 10784 18.00 2 0.15 142 10767 14.00 2 0 131 10774 12.50 2 0.25 177 10735 13.00 2 0.1 110 10676 31.00 2 0 175 10634 7.75 2 0 146 10643 12.00 2 0.25 130 10652 25.89 2 0.25 140 10574 18.40 2 0 159 10531 55.00 2 0 110 10524 31.00 2 0 144 10469 15.50 2 0.15 155 10476 19.20 2 0.05 142 10309 11.20 2 0 171 10304 17.20 2 0 157 10282 15.60 2 0 151 10291 42.40 2 0.1 156 10262 30.40 2 0 140 10406 14.70 2 0.1 117 10415 31.20 2 0 146 10417 9.60 2 0.25 113 10420 4.80 2 0.1 126 10422 24.90 2 0 171 10447 17.20 2 0 131 10446 10.00 3 0.1 168 10288 10.00 3 0.1 172 10283 27.80 3 0 171 10309 17.20 3 0 168 10307 10.00 3 0 151 10484 42.40 3 0 143 10464 36.80 3 0 162 10505 49.30 3 0 128 10509 45.60 3 0 111 10528 21.00 3 0 135 10521 18.00 3 0 173 10558 15.00 3 0 151 10567 53.00 3 0 11 10609 18.00 3 0 124 10623 4.50 3 0 114 10625 23.25 3 0 116 10673 17.45 3 0 139 10661 18.00 3 0.2 114 10656 23.25 3 0.1 131 10730 12.50 3 0.05 12 10722 19.00 3 0 153 10712 32.80 3 0.05 130 10719 25.89 3 0.25 167 10775 14.00 3 0 154 10781 7.45 3 0.2 17 10790 30.00 3 0.15 154 10792 7.45 3 0 116 10738 17.45 3 0 169 10752 36.00 3 0 140 10754 18.40 3 0 135 10870 18.00 3 0 162 10861 49.30 3 0 153 10867 32.80 3 0 19 10848 97.00 3 0 151 10860 53.00 3 0 128 10873 45.60 3 0 170 10900 15.00 3 0.25 113 10832 6.00 3 0.2 164 10832 33.25 3 0 162 10822 49.30 3 0 146 11019 12.00 3 0 170 11057 15.00 3 0 121 11058 10.00 3 0 116 11066 17.45 3 0 141 11077 9.65 3 0 146 11077 12.00 3 0.02 13 11077 10.00 4 0 175 11077 7.75 4 0 130 11065 25.89 4 0.25 155 11064 24.00 4 0.1 160 11060 34.00 4 0 161 11058 28.50 4 0 113 11077 6.00 4 0 170 11037 15.00 4 0 161 11042 28.50 4 0 112 11049 38.00 4 0.2 17 11023 30.00 4 0 142 11013 14.00 4 0 11 11003 18.00 4 0 160 10995 34.00 4 0 141 10989 9.65 4 0 164 10968 33.25 4 0 118 10935 62.50 4 0.25 159 10947 55.00 4 0 155 10948 24.00 4 0 149 10804 20.00 4 0.15 11 10838 18.00 4 0.25 151 10843 53.00 4 0.25 170 10858 15.00 4 0 133 10850 2.50 4 0.15 135 10864 18.00 4 0 145 10753 9.50 4 0 113 10737 6.00 4 0 122 10768 21.00 4 0 152 10725 7.00 4 0 166 10682 17.00 4 0 141 10685 9.65 4 0 112 10695 38.00 4 0 132 10705 32.00 4 0 15 10708 21.35 4 0 155 10668 24.00 4 0.1 118 10644 62.50 4 0.1 154 10600 7.45 4 0 157 10582 19.50 4 0 152 10586 7.00 4 0.15 135 10589 18.00 4 0 176 10593 18.00 4 0.2 138 10541 263.50 4 0.1 159 10517 55.00 4 0 175 10460 6.20 4 0.25 128 10312 36.40 4 0 125 10323 11.20 4 0 139 10323 14.40 4 0 131 10325 10.00 4 0 168 10343 10.00 4 0.05 140 10347 14.70 4 0 135 10281 14.40 4 0 156 10295 30.40 4 0 172 10268 27.80 4 0 119 10421 7.30 4 0.15 129 10354 99.00 4 0 171 10364 17.20 5 0 165 10366 16.80 5 0 177 10366 10.40 5 0 121 10368 8.00 5 0.1 156 10426 30.40 5 0 136 10406 15.20 5 0.1 146 10436 9.60 5 0 172 10248 34.80 5 0 163 10293 35.10 5 0 167 10284 11.20 5 0.25 115 10323 12.40 5 0 162 10310 39.40 5 0 154 10306 5.90 5 0 170 10308 12.00 5 0 146 10466 9.60 5 0 111 10486 16.80 5 0 119 10487 7.30 5 0 177 10495 10.40 5 0 140 10498 18.40 5 0 124 10518 4.50 5 0 153 10520 32.80 5 0 157 10535 19.50 5 0.1 156 10596 38.00 5 0.2 126 10592 31.23 5 0.05 110 10568 31.00 5 0 177 10602 13.00 5 0.25 124 10620 4.50 5 0 152 10620 7.00 5 0 119 10621 9.20 5 0 139 10614 18.00 5 0 155 10615 24.00 5 0 142 10625 14.00 5 0 123 10674 9.00 5 0 136 10708 19.00 5 0 12 10703 19.00 5 0 11 10700 18.00 5 0.2 111 10726 21.00 5 0 161 10724 28.50 5 0 121 10716 10.00 5 0 119 10710 9.20 5 0 147 10710 9.50 5 0 138 10783 263.50 5 0 128 10740 45.60 5 0.2 174 10753 10.00 5 0 114 10750 23.25 5 0.15 12 10851 19.00 5 0.05 17 10858 30.00 5 0 113 10898 6.00 5 0 125 10887 14.00 5 0 143 10842 46.00 5 0 120 10828 81.00 5 0 162 10802 49.30 5 0.25 125 10810 14.00 5 0 170 10810 15.00 5 0 111 10944 21.00 5 0.25 138 10964 263.50 5 0 172 10958 34.80 5 0 14 10950 22.00 5 0 120 10927 81.00 5 0 152 10927 7.00 5 0 147 10928 9.50 5 0 176 10928 18.00 5 0 141 10909 9.65 5 0 161 10910 28.50 5 0 126 10973 31.23 5 0 156 11018 38.00 5 0 140 11038 18.40 5 0.2 161 11034 28.50 6 0 155 11001 24.00 6 0 126 11004 31.23 6 0 176 11004 18.00 6 0 141 10973 9.65 6 0 117 10972 39.00 6 0 144 10978 19.45 6 0.15 143 10987 46.00 6 0 116 10916 17.45 6 0 132 10916 32.00 6 0 175 10924 7.75 6 0 141 10951 9.65 6 0.05 17 10958 30.00 6 0 152 10961 7.00 6 0.05 118 10964 62.50 6 0 117 10949 39.00 6 0 170 10822 15.00 6 0 151 10821 53.00 6 0 154 10794 7.45 6 0.2 16 10830 25.00 6 0 135 10836 18.00 6 0 125 10840 14.00 6 0.2 113 10837 6.00 6 0 162 10902 49.30 6 0.15 117 10852 39.00 6 0 124 10866 4.50 6 0.25 168 10756 12.50 6 0.2 136 10739 19.00 6 0 113 10746 6.00 6 0 159 10749 55.00 6 0 110 10775 31.00 6 0 122 10763 21.00 6 0 155 10725 24.00 6 0 140 10728 18.40 6 0 13 10702 10.00 6 0 14 10704 22.00 6 0 19 10693 97.00 6 0 136 10687 19.00 6 0.25 142 10673 14.00 6 0 143 10673 46.00 6 0 147 10656 9.50 6 0.1 158 10636 13.25 6 0 154 10654 7.45 6 0.1 129 10624 123.79 6 0 148 10604 12.75 6 0.1 121 10609 10.00 6 0 11 10611 18.00 6 0 164 10574 33.25 6 0 163 10575 43.90 6 0 126 10587 31.23 6 0 157 10578 19.50 6 0 151 10537 53.00 6 0 141 10523 9.65 6 0.1 168 10521 12.50 6 0 170 10517 15.00 6 0 152 10517 7.00 6 0 149 10539 20.00 6 0 121 10550 10.00 6 0.1 131 10564 12.50 6 0.05 135 10553 18.00 6 0 153 10502 32.80 6 0 147 10512 9.50 6 0.15 142 10311 11.20 6 0 16 10325 20.00 6 0 176 10318 14.40 6 0 175 10347 6.20 6 0.15 132 10335 25.60 6 0.2 130 10282 20.70 6 0 124 10281 3.60 6 0 159 10275 44.00 6 0.05 175 10293 6.20 6 0 175 10294 6.20 6 0 122 10251 16.80 6 0.05 132 10258 25.60 6 0.2 139 10257 14.40 6 0 120 10272 64.80 6 0 164 10439 26.60 6 0 139 10445 14.40 6 0 111 10443 16.80 6 0.2 126 10448 24.90 6 0 154 10450 5.90 6 0.2 154 10408 5.90 6 0 111 10434 16.80 6 0 136 10371 15.20 6 0.2 171 10378 17.20 6 0 160 10380 27.20 6 0.1 128 10387 36.40 6 0 125 10393 11.20 7 0.25 177 10367 10.40 7 0 164 10426 26.60 7 0 172 10274 27.80 7 0 12 10335 15.20 7 0.2 169 10311 28.80 7 0 177 10491 10.40 7 0.15 128 10544 45.60 7 0 167 10544 14.00 7 0 170 10538 15.00 7 0 119 10676 9.20 7 0 119 10697 9.20 7 0.25 151 10716 53.00 7 0 175 10773 7.75 7 0.2 172 10745 34.80 7 0 159 10757 55.00 7 0 154 10800 7.45 7 0.1 143 10819 46.00 7 0 113 10810 6.00 7 0 119 10926 9.20 7 0 133 10972 2.50 7 0 161 10998 28.50 7 0 113 11036 6.00 7 0 118 11026 62.50 8 0 128 11068 45.60 8 0.15 12 11072 19.00 8 0 11 11006 18.00 8 0 137 10966 26.00 8 0 118 10985 62.50 8 0.1 123 10935 9.00 8 0.25 128 10937 45.60 8 0 17 10940 30.00 8 0 151 10956 53.00 8 0 164 10957 33.25 8 0 148 10814 12.75 8 0.15 129 10834 123.79 8 0.05 135 10831 18.00 8 0 138 10831 263.50 8 0 152 10862 7.00 8 0 139 10899 18.00 8 0.15 124 10883 4.50 8 0 11 10752 18.00 8 0 131 10747 12.50 8 0 152 10793 7.00 8 0 171 10720 21.50 8 0 117 10698 39.00 8 0.05 170 10698 15.00 8 0.05 159 10706 55.00 8 0 133 10677 2.50 8 0.15 131 10668 12.50 8 0.1 118 10639 62.50 8 0 175 10631 7.75 8 0.1 113 10613 6.00 8 0.1 121 10614 10.00 8 0 113 10539 6.00 8 0 124 10520 4.50 8 0 133 10528 2.50 8 0.2 11 10526 18.00 8 0.15 117 10550 39.00 8 0.1 128 10500 45.60 8 0.05 130 10468 20.70 8 0 164 10470 26.60 8 0 117 10319 31.20 8 0 152 10334 5.60 8 0 130 10329 20.70 8 0.05 133 10341 2.00 8 0 163 10278 35.10 8 0 170 10420 12.00 8 0.1 135 10444 14.40 8 0 141 10379 7.70 8 0.1 160 10357 27.20 8 0.2 169 10395 28.80 8 0 168 10385 10.00 8 0.2 118 10382 50.00 9 0 159 10411 44.00 9 0.2 164 10289 26.60 9 0 114 10249 18.60 9 0 159 10341 44.00 9 0.15 142 10345 11.20 9 0 159 10328 44.00 9 0 114 10325 18.60 9 0 146 10512 12.00 9 0.15 171 10541 21.50 9 0.1 172 10528 34.80 9 0 144 10518 19.45 9 0 173 10537 15.00 9 0 171 10598 21.50 9 0 141 10580 9.65 9 0.05 164 10629 33.25 9 0 135 10697 18.00 9 0.25 152 10683 7.00 9 0 162 10746 49.30 9 0 163 10747 43.90 9 0 143 10831 46.00 9 0 131 10833 12.50 9 0.1 153 10833 32.80 9 0.1 170 10824 15.00 9 0 169 10962 36.00 9 0 150 10948 16.25 9 0 143 10982 46.00 9 0 146 10969 12.00 9 0 160 11009 34.00 9 0 141 11067 9.65 9 0 12 11049 19.00 10 0.2 119 11076 9.20 10 0.25 12 11075 19.00 10 0.15 111 11073 21.00 10 0 113 11071 6.00 10 0.05 133 11054 2.50 10 0 177 11060 13.00 10 0 153 11062 32.80 10 0.2 151 11026 53.00 10 0 11 11025 18.00 10 0.1 11 11035 18.00 10 0 154 11035 7.45 10 0 124 11051 4.50 10 0.2 161 11052 28.50 10 0.2 111 11043 21.00 10 0 124 11010 4.50 10 0 123 11013 9.00 10 0 118 11018 62.50 10 0 129 11007 123.79 10 0 159 11005 55.00 10 0 140 11003 18.40 10 0 152 11003 7.00 10 0 175 10973 7.75 10 0 163 10974 43.90 10 0 175 10975 7.75 10 0 151 10977 53.00 10 0 140 10978 18.40 10 0 176 10986 18.00 10 0 131 10945 12.50 10 0 12 10939 19.00 10 0.15 169 10964 36.00 10 0 124 10960 4.50 10 0.25 172 10926 34.80 10 0 113 10926 6.00 10 0 142 10923 14.00 10 0.2 143 10923 46.00 10 0.2 160 10917 34.00 10 0 117 10915 39.00 10 0 154 10915 7.45 10 0 135 10921 18.00 10 0 11 10911 18.00 10 0 149 10910 20.00 10 0 12 10829 19.00 10 0 113 10829 6.00 10 0 125 10832 14.00 10 0.2 139 10840 18.00 10 0.2 151 10800 53.00 10 0.1 134 10805 14.00 10 0 138 10805 263.50 10 0 144 10796 19.45 10 0 172 10798 34.80 10 0 110 10874 31.00 10 0 165 10879 21.05 10 0 176 10879 18.00 10 0 173 10881 15.00 10 0 134 10890 14.00 10 0 124 10893 4.50 10 0 111 10869 21.00 10 0 155 10872 24.00 10 0.05 118 10853 62.50 10 0 125 10851 14.00 10 0.05 157 10851 19.50 10 0.05 127 10858 43.90 10 0 129 10857 123.79 10 0.25 176 10749 18.00 10 0 132 10759 32.00 10 0 12 10792 19.00 10 0 131 10783 12.50 10 0 110 10785 31.00 10 0 175 10785 7.75 10 0 141 10778 9.65 10 0 129 10687 123.79 10 0 18 10695 40.00 10 0 161 10716 28.50 10 0 160 10709 34.00 10 0 165 10730 21.05 10 0.05 156 10727 38.00 10 0.05 159 10727 55.00 10 0.05 160 10625 34.00 10 0 128 10624 45.60 10 0 111 10637 21.00 10 0 14 10635 22.00 10 0.1 116 10671 17.45 10 0 162 10671 49.30 10 0 153 10675 32.80 10 0 147 10657 9.50 10 0 176 10665 18.00 10 0 165 10666 21.05 10 0 168 10662 12.50 10 0 115 10579 15.50 10 0 129 10583 123.79 10 0 169 10583 36.00 10 0.15 17 10591 30.00 10 0 162 10574 49.30 10 0 176 10575 18.00 10 0 11 10576 18.00 10 0 139 10577 18.00 10 0 176 10566 18.00 10 0 132 10572 32.00 10 0.1 162 10599 49.30 10 0 176 10604 18.00 10 0.1 12 10611 19.00 10 0 110 10609 31.00 10 0 162 10606 49.30 10 0.2 144 10624 19.45 10 0 123 10621 9.00 10 0 140 10535 18.40 10 0.1 169 10529 36.00 10 0 130 10534 25.89 10 0 140 10534 18.40 10 0.2 154 10534 7.45 10 0.2 160 10519 34.00 10 0.05 1There are also 593 rows where there should only be 263. In the outpu, the first row shold have an OrderID of 10609 and ProductID should be 1. |
|
|
|
snigrini
Starting Member
4 Posts |
Posted - 2015-05-07 : 12:14:27
|
| Hi James.That does not give me the correct answer. The answer that it gives me is as follows:ProductID OrderIDUnitPrice Discount Quantity 37 10259 20.80 1 0 119 10281 7.30 1 0 169 10308 28.80 1 0 113 10462 4.80 1 0 172 10538 34.80 1 0 159 10665 55.00 1 0 131 10782 12.50 1 0 140 10807 18.40 1 0 130 10917 25.89 1 0 14 11077 22.00 1 0 16 11077 25.00 1 0.02 17 11077 30.00 1 0.05 110 11077 31.00 1 0 114 11077 23.25 1 0.03 120 11077 81.00 1 0.04 132 11077 32.00 1 0 166 11077 17.00 1 0 173 11077 15.00 2 0.01 177 11077 13.00 2 0 152 11077 7.00 2 0 155 11077 24.00 2 0 160 11077 34.00 2 0.06 164 11077 33.25 2 0.03 139 11077 18.00 2 0.05 123 11077 9.00 2 0 116 11077 17.45 2 0.03 112 11077 38.00 2 0.05 18 11077 40.00 2 0.1 176 11075 18.00 2 0.15 152 11038 7.00 2 0 111 10926 21.00 2 0 153 10933 32.80 2 0 128 10952 45.60 2 0 160 10963 34.00 2 0.15 172 10992 34.80 2 0 11 11005 18.00 2 0 129 11006 123.79 2 0.25 168 11013 12.50 2 0 149 11019 20.00 2 0 165 10806 21.05 2 0 162 10798 49.30 2 0 138 10828 263.50 2 0 119 10831 9.20 2 0 177 10835 13.00 2 0.2 151 10870 53.00 2 0 139 10784 18.00 2 0.15 142 10767 14.00 2 0 131 10774 12.50 2 0.25 177 10735 13.00 2 0.1 110 10676 31.00 2 0 175 10634 7.75 2 0 146 10643 12.00 2 0.25 130 10652 25.89 2 0.25 140 10574 18.40 2 0 159 10531 55.00 2 0 110 10524 31.00 2 0 144 10469 15.50 2 0.15 155 10476 19.20 2 0.05 142 10309 11.20 2 0 171 10304 17.20 2 0 157 10282 15.60 2 0 151 10291 42.40 2 0.1 156 10262 30.40 2 0 140 10406 14.70 2 0.1 117 10415 31.20 2 0 146 10417 9.60 2 0.25 113 10420 4.80 2 0.1 126 10422 24.90 2 0 171 10447 17.20 2 0 131 10446 10.00 3 0.1 168 10288 10.00 3 0.1 172 10283 27.80 3 0 171 10309 17.20 3 0 168 10307 10.00 3 0 151 10484 42.40 3 0 143 10464 36.80 3 0 162 10505 49.30 3 0 128 10509 45.60 3 0 111 10528 21.00 3 0 135 10521 18.00 3 0 173 10558 15.00 3 0 151 10567 53.00 3 0 11 10609 18.00 3 0 124 10623 4.50 3 0 114 10625 23.25 3 0 116 10673 17.45 3 0 139 10661 18.00 3 0.2 114 10656 23.25 3 0.1 131 10730 12.50 3 0.05 12 10722 19.00 3 0 153 10712 32.80 3 0.05 130 10719 25.89 3 0.25 167 10775 14.00 3 0 154 10781 7.45 3 0.2 17 10790 30.00 3 0.15 154 10792 7.45 3 0 116 10738 17.45 3 0 169 10752 36.00 3 0 140 10754 18.40 3 0 135 10870 18.00 3 0 162 10861 49.30 3 0 153 10867 32.80 3 0 19 10848 97.00 3 0 151 10860 53.00 3 0 128 10873 45.60 3 0 170 10900 15.00 3 0.25 113 10832 6.00 3 0.2 164 10832 33.25 3 0 162 10822 49.30 3 0 146 11019 12.00 3 0 170 11057 15.00 3 0 121 11058 10.00 3 0 116 11066 17.45 3 0 141 11077 9.65 3 0 146 11077 12.00 3 0.02 13 11077 10.00 4 0 175 11077 7.75 4 0 130 11065 25.89 4 0.25 155 11064 24.00 4 0.1 160 11060 34.00 4 0 161 11058 28.50 4 0 113 11077 6.00 4 0 170 11037 15.00 4 0 161 11042 28.50 4 0 112 11049 38.00 4 0.2 17 11023 30.00 4 0 142 11013 14.00 4 0 11 11003 18.00 4 0 160 10995 34.00 4 0 141 10989 9.65 4 0 164 10968 33.25 4 0 118 10935 62.50 4 0.25 159 10947 55.00 4 0 155 10948 24.00 4 0 149 10804 20.00 4 0.15 11 10838 18.00 4 0.25 151 10843 53.00 4 0.25 170 10858 15.00 4 0 133 10850 2.50 4 0.15 135 10864 18.00 4 0 145 10753 9.50 4 0 113 10737 6.00 4 0 122 10768 21.00 4 0 152 10725 7.00 4 0 166 10682 17.00 4 0 141 10685 9.65 4 0 112 10695 38.00 4 0 132 10705 32.00 4 0 15 10708 21.35 4 0 155 10668 24.00 4 0.1 118 10644 62.50 4 0.1 154 10600 7.45 4 0 157 10582 19.50 4 0 152 10586 7.00 4 0.15 135 10589 18.00 4 0 176 10593 18.00 4 0.2 138 10541 263.50 4 0.1 159 10517 55.00 4 0 175 10460 6.20 4 0.25 128 10312 36.40 4 0 125 10323 11.20 4 0 139 10323 14.40 4 0 131 10325 10.00 4 0 168 10343 10.00 4 0.05 140 10347 14.70 4 0 135 10281 14.40 4 0 156 10295 30.40 4 0 172 10268 27.80 4 0 119 10421 7.30 4 0.15 129 10354 99.00 4 0 171 10364 17.20 5 0 165 10366 16.80 5 0 177 10366 10.40 5 0 121 10368 8.00 5 0.1 156 10426 30.40 5 0 136 10406 15.20 5 0.1 146 10436 9.60 5 0 172 10248 34.80 5 0 163 10293 35.10 5 0 167 10284 11.20 5 0.25 115 10323 12.40 5 0 162 10310 39.40 5 0 154 10306 5.90 5 0 170 10308 12.00 5 0 146 10466 9.60 5 0 111 10486 16.80 5 0 119 10487 7.30 5 0 177 10495 10.40 5 0 140 10498 18.40 5 0 124 10518 4.50 5 0 153 10520 32.80 5 0 157 10535 19.50 5 0.1 156 10596 38.00 5 0.2 126 10592 31.23 5 0.05 110 10568 31.00 5 0 177 10602 13.00 5 0.25 124 10620 4.50 5 0 152 10620 7.00 5 0 119 10621 9.20 5 0 139 10614 18.00 5 0 155 10615 24.00 5 0 142 10625 14.00 5 0 123 10674 9.00 5 0 136 10708 19.00 5 0 12 10703 19.00 5 0 11 10700 18.00 5 0.2 111 10726 21.00 5 0 161 10724 28.50 5 0 121 10716 10.00 5 0 119 10710 9.20 5 0 147 10710 9.50 5 0 138 10783 263.50 5 0 128 10740 45.60 5 0.2 174 10753 10.00 5 0 114 10750 23.25 5 0.15 12 10851 19.00 5 0.05 17 10858 30.00 5 0 113 10898 6.00 5 0 125 10887 14.00 5 0 143 10842 46.00 5 0 120 10828 81.00 5 0 162 10802 49.30 5 0.25 125 10810 14.00 5 0 170 10810 15.00 5 0 111 10944 21.00 5 0.25 138 10964 263.50 5 0 172 10958 34.80 5 0 14 10950 22.00 5 0 120 10927 81.00 5 0 152 10927 7.00 5 0 147 10928 9.50 5 0 176 10928 18.00 5 0 141 10909 9.65 5 0 161 10910 28.50 5 0 126 10973 31.23 5 0 156 11018 38.00 5 0 140 11038 18.40 5 0.2 161 11034 28.50 6 0 155 11001 24.00 6 0 126 11004 31.23 6 0 176 11004 18.00 6 0 141 10973 9.65 6 0 117 10972 39.00 6 0 144 10978 19.45 6 0.15 143 10987 46.00 6 0 116 10916 17.45 6 0 132 10916 32.00 6 0 175 10924 7.75 6 0 141 10951 9.65 6 0.05 17 10958 30.00 6 0 152 10961 7.00 6 0.05 118 10964 62.50 6 0 117 10949 39.00 6 0 170 10822 15.00 6 0 151 10821 53.00 6 0 154 10794 7.45 6 0.2 16 10830 25.00 6 0 135 10836 18.00 6 0 125 10840 14.00 6 0.2 113 10837 6.00 6 0 162 10902 49.30 6 0.15 117 10852 39.00 6 0 124 10866 4.50 6 0.25 168 10756 12.50 6 0.2 136 10739 19.00 6 0 113 10746 6.00 6 0 159 10749 55.00 6 0 110 10775 31.00 6 0 122 10763 21.00 6 0 155 10725 24.00 6 0 140 10728 18.40 6 0 13 10702 10.00 6 0 14 10704 22.00 6 0 19 10693 97.00 6 0 136 10687 19.00 6 0.25 142 10673 14.00 6 0 143 10673 46.00 6 0 147 10656 9.50 6 0.1 158 10636 13.25 6 0 154 10654 7.45 6 0.1 129 10624 123.79 6 0 148 10604 12.75 6 0.1 121 10609 10.00 6 0 11 10611 18.00 6 0 164 10574 33.25 6 0 163 10575 43.90 6 0 126 10587 31.23 6 0 157 10578 19.50 6 0 151 10537 53.00 6 0 141 10523 9.65 6 0.1 168 10521 12.50 6 0 170 10517 15.00 6 0 152 10517 7.00 6 0 149 10539 20.00 6 0 121 10550 10.00 6 0.1 131 10564 12.50 6 0.05 135 10553 18.00 6 0 153 10502 32.80 6 0 147 10512 9.50 6 0.15 142 10311 11.20 6 0 16 10325 20.00 6 0 176 10318 14.40 6 0 175 10347 6.20 6 0.15 132 10335 25.60 6 0.2 130 10282 20.70 6 0 124 10281 3.60 6 0 159 10275 44.00 6 0.05 175 10293 6.20 6 0 175 10294 6.20 6 0 122 10251 16.80 6 0.05 132 10258 25.60 6 0.2 139 10257 14.40 6 0 120 10272 64.80 6 0 164 10439 26.60 6 0 139 10445 14.40 6 0 111 10443 16.80 6 0.2 126 10448 24.90 6 0 154 10450 5.90 6 0.2 154 10408 5.90 6 0 111 10434 16.80 6 0 136 10371 15.20 6 0.2 171 10378 17.20 6 0 160 10380 27.20 6 0.1 128 10387 36.40 6 0 125 10393 11.20 7 0.25 177 10367 10.40 7 0 164 10426 26.60 7 0 172 10274 27.80 7 0 12 10335 15.20 7 0.2 169 10311 28.80 7 0 177 10491 10.40 7 0.15 128 10544 45.60 7 0 167 10544 14.00 7 0 170 10538 15.00 7 0 119 10676 9.20 7 0 119 10697 9.20 7 0.25 151 10716 53.00 7 0 175 10773 7.75 7 0.2 172 10745 34.80 7 0 159 10757 55.00 7 0 154 10800 7.45 7 0.1 143 10819 46.00 7 0 113 10810 6.00 7 0 119 10926 9.20 7 0 133 10972 2.50 7 0 161 10998 28.50 7 0 113 11036 6.00 7 0 118 11026 62.50 8 0 128 11068 45.60 8 0.15 12 11072 19.00 8 0 11 11006 18.00 8 0 137 10966 26.00 8 0 118 10985 62.50 8 0.1 123 10935 9.00 8 0.25 128 10937 45.60 8 0 17 10940 30.00 8 0 151 10956 53.00 8 0 164 10957 33.25 8 0 148 10814 12.75 8 0.15 129 10834 123.79 8 0.05 135 10831 18.00 8 0 138 10831 263.50 8 0 152 10862 7.00 8 0 139 10899 18.00 8 0.15 124 10883 4.50 8 0 11 10752 18.00 8 0 131 10747 12.50 8 0 152 10793 7.00 8 0 171 10720 21.50 8 0 117 10698 39.00 8 0.05 170 10698 15.00 8 0.05 159 10706 55.00 8 0 133 10677 2.50 8 0.15 131 10668 12.50 8 0.1 118 10639 62.50 8 0 175 10631 7.75 8 0.1 113 10613 6.00 8 0.1 121 10614 10.00 8 0 113 10539 6.00 8 0 124 10520 4.50 8 0 133 10528 2.50 8 0.2 11 10526 18.00 8 0.15 117 10550 39.00 8 0.1 128 10500 45.60 8 0.05 130 10468 20.70 8 0 164 10470 26.60 8 0 117 10319 31.20 8 0 152 10334 5.60 8 0 130 10329 20.70 8 0.05 133 10341 2.00 8 0 163 10278 35.10 8 0 170 10420 12.00 8 0.1 135 10444 14.40 8 0 141 10379 7.70 8 0.1 160 10357 27.20 8 0.2 169 10395 28.80 8 0 168 10385 10.00 8 0.2 118 10382 50.00 9 0 159 10411 44.00 9 0.2 164 10289 26.60 9 0 114 10249 18.60 9 0 159 10341 44.00 9 0.15 142 10345 11.20 9 0 159 10328 44.00 9 0 114 10325 18.60 9 0 146 10512 12.00 9 0.15 171 10541 21.50 9 0.1 172 10528 34.80 9 0 144 10518 19.45 9 0 173 10537 15.00 9 0 171 10598 21.50 9 0 141 10580 9.65 9 0.05 164 10629 33.25 9 0 135 10697 18.00 9 0.25 152 10683 7.00 9 0 162 10746 49.30 9 0 163 10747 43.90 9 0 143 10831 46.00 9 0 131 10833 12.50 9 0.1 153 10833 32.80 9 0.1 170 10824 15.00 9 0 169 10962 36.00 9 0 150 10948 16.25 9 0 143 10982 46.00 9 0 146 10969 12.00 9 0 160 11009 34.00 9 0 141 11067 9.65 9 0 12 11049 19.00 10 0.2 119 11076 9.20 10 0.25 12 11075 19.00 10 0.15 111 11073 21.00 10 0 113 11071 6.00 10 0.05 133 11054 2.50 10 0 177 11060 13.00 10 0 153 11062 32.80 10 0.2 151 11026 53.00 10 0 11 11025 18.00 10 0.1 11 11035 18.00 10 0 154 11035 7.45 10 0 124 11051 4.50 10 0.2 161 11052 28.50 10 0.2 111 11043 21.00 10 0 124 11010 4.50 10 0 123 11013 9.00 10 0 118 11018 62.50 10 0 129 11007 123.79 10 0 159 11005 55.00 10 0 140 11003 18.40 10 0 152 11003 7.00 10 0 175 10973 7.75 10 0 163 10974 43.90 10 0 175 10975 7.75 10 0 151 10977 53.00 10 0 140 10978 18.40 10 0 176 10986 18.00 10 0 131 10945 12.50 10 0 12 10939 19.00 10 0.15 169 10964 36.00 10 0 124 10960 4.50 10 0.25 172 10926 34.80 10 0 113 10926 6.00 10 0 142 10923 14.00 10 0.2 143 10923 46.00 10 0.2 160 10917 34.00 10 0 117 10915 39.00 10 0 154 10915 7.45 10 0 135 10921 18.00 10 0 11 10911 18.00 10 0 149 10910 20.00 10 0 12 10829 19.00 10 0 113 10829 6.00 10 0 125 10832 14.00 10 0.2 139 10840 18.00 10 0.2 151 10800 53.00 10 0.1 134 10805 14.00 10 0 138 10805 263.50 10 0 144 10796 19.45 10 0 172 10798 34.80 10 0 110 10874 31.00 10 0 165 10879 21.05 10 0 176 10879 18.00 10 0 173 10881 15.00 10 0 134 10890 14.00 10 0 124 10893 4.50 10 0 111 10869 21.00 10 0 155 10872 24.00 10 0.05 118 10853 62.50 10 0 125 10851 14.00 10 0.05 157 10851 19.50 10 0.05 127 10858 43.90 10 0 129 10857 123.79 10 0.25 176 10749 18.00 10 0 132 10759 32.00 10 0 12 10792 19.00 10 0 131 10783 12.50 10 0 110 10785 31.00 10 0 175 10785 7.75 10 0 141 10778 9.65 10 0 129 10687 123.79 10 0 18 10695 40.00 10 0 161 10716 28.50 10 0 160 10709 34.00 10 0 165 10730 21.05 10 0.05 156 10727 38.00 10 0.05 159 10727 55.00 10 0.05 160 10625 34.00 10 0 128 10624 45.60 10 0 111 10637 21.00 10 0 14 10635 22.00 10 0.1 116 10671 17.45 10 0 162 10671 49.30 10 0 153 10675 32.80 10 0 147 10657 9.50 10 0 176 10665 18.00 10 0 165 10666 21.05 10 0 168 10662 12.50 10 0 115 10579 15.50 10 0 129 10583 123.79 10 0 169 10583 36.00 10 0.15 17 10591 30.00 10 0 162 10574 49.30 10 0 176 10575 18.00 10 0 11 10576 18.00 10 0 139 10577 18.00 10 0 176 10566 18.00 10 0 132 10572 32.00 10 0.1 162 10599 49.30 10 0 176 10604 18.00 10 0.1 12 10611 19.00 10 0 110 10609 31.00 10 0 162 10606 49.30 10 0.2 144 10624 19.45 10 0 123 10621 9.00 10 0 140 10535 18.40 10 0.1 169 10529 36.00 10 0 130 10534 25.89 10 0 140 10534 18.40 10 0.2 154 10534 7.45 10 0.2 160 10519 34.00 10 0.05 1There are also 593 rows where there should only be 263. In the outpu, the first row shold have an OrderID of 10609 and ProductID should be 1. |
|
|
|
snigrini
Starting Member
4 Posts |
Posted - 2015-05-07 : 12:14:27
|
| Hi James.That does not give me the correct answer. The answer that it gives me is as follows:ProductID OrderIDUnitPrice Discount Quantity 37 10259 20.80 1 0 119 10281 7.30 1 0 169 10308 28.80 1 0 113 10462 4.80 1 0 172 10538 34.80 1 0 159 10665 55.00 1 0 131 10782 12.50 1 0 140 10807 18.40 1 0 130 10917 25.89 1 0 14 11077 22.00 1 0 16 11077 25.00 1 0.02 17 11077 30.00 1 0.05 110 11077 31.00 1 0 114 11077 23.25 1 0.03 120 11077 81.00 1 0.04 132 11077 32.00 1 0 166 11077 17.00 1 0 173 11077 15.00 2 0.01 177 11077 13.00 2 0 152 11077 7.00 2 0 155 11077 24.00 2 0 160 11077 34.00 2 0.06 164 11077 33.25 2 0.03 139 11077 18.00 2 0.05 123 11077 9.00 2 0 116 11077 17.45 2 0.03 112 11077 38.00 2 0.05 18 11077 40.00 2 0.1 176 11075 18.00 2 0.15 152 11038 7.00 2 0 111 10926 21.00 2 0 153 10933 32.80 2 0 128 10952 45.60 2 0 160 10963 34.00 2 0.15 172 10992 34.80 2 0 11 11005 18.00 2 0 129 11006 123.79 2 0.25 168 11013 12.50 2 0 149 11019 20.00 2 0 165 10806 21.05 2 0 162 10798 49.30 2 0 138 10828 263.50 2 0 119 10831 9.20 2 0 177 10835 13.00 2 0.2 151 10870 53.00 2 0 139 10784 18.00 2 0.15 142 10767 14.00 2 0 131 10774 12.50 2 0.25 177 10735 13.00 2 0.1 110 10676 31.00 2 0 175 10634 7.75 2 0 146 10643 12.00 2 0.25 130 10652 25.89 2 0.25 140 10574 18.40 2 0 159 10531 55.00 2 0 110 10524 31.00 2 0 144 10469 15.50 2 0.15 155 10476 19.20 2 0.05 142 10309 11.20 2 0 171 10304 17.20 2 0 157 10282 15.60 2 0 151 10291 42.40 2 0.1 156 10262 30.40 2 0 140 10406 14.70 2 0.1 117 10415 31.20 2 0 146 10417 9.60 2 0.25 113 10420 4.80 2 0.1 126 10422 24.90 2 0 171 10447 17.20 2 0 131 10446 10.00 3 0.1 168 10288 10.00 3 0.1 172 10283 27.80 3 0 171 10309 17.20 3 0 168 10307 10.00 3 0 151 10484 42.40 3 0 143 10464 36.80 3 0 162 10505 49.30 3 0 128 10509 45.60 3 0 111 10528 21.00 3 0 135 10521 18.00 3 0 173 10558 15.00 3 0 151 10567 53.00 3 0 11 10609 18.00 3 0 124 10623 4.50 3 0 114 10625 23.25 3 0 116 10673 17.45 3 0 139 10661 18.00 3 0.2 114 10656 23.25 3 0.1 131 10730 12.50 3 0.05 12 10722 19.00 3 0 153 10712 32.80 3 0.05 130 10719 25.89 3 0.25 167 10775 14.00 3 0 154 10781 7.45 3 0.2 17 10790 30.00 3 0.15 154 10792 7.45 3 0 116 10738 17.45 3 0 169 10752 36.00 3 0 140 10754 18.40 3 0 135 10870 18.00 3 0 162 10861 49.30 3 0 153 10867 32.80 3 0 19 10848 97.00 3 0 151 10860 53.00 3 0 128 10873 45.60 3 0 170 10900 15.00 3 0.25 113 10832 6.00 3 0.2 164 10832 33.25 3 0 162 10822 49.30 3 0 146 11019 12.00 3 0 170 11057 15.00 3 0 121 11058 10.00 3 0 116 11066 17.45 3 0 141 11077 9.65 3 0 146 11077 12.00 3 0.02 13 11077 10.00 4 0 175 11077 7.75 4 0 130 11065 25.89 4 0.25 155 11064 24.00 4 0.1 160 11060 34.00 4 0 161 11058 28.50 4 0 113 11077 6.00 4 0 170 11037 15.00 4 0 161 11042 28.50 4 0 112 11049 38.00 4 0.2 17 11023 30.00 4 0 142 11013 14.00 4 0 11 11003 18.00 4 0 160 10995 34.00 4 0 141 10989 9.65 4 0 164 10968 33.25 4 0 118 10935 62.50 4 0.25 159 10947 55.00 4 0 155 10948 24.00 4 0 149 10804 20.00 4 0.15 11 10838 18.00 4 0.25 151 10843 53.00 4 0.25 170 10858 15.00 4 0 133 10850 2.50 4 0.15 135 10864 18.00 4 0 145 10753 9.50 4 0 113 10737 6.00 4 0 122 10768 21.00 4 0 152 10725 7.00 4 0 166 10682 17.00 4 0 141 10685 9.65 4 0 112 10695 38.00 4 0 132 10705 32.00 4 0 15 10708 21.35 4 0 155 10668 24.00 4 0.1 118 10644 62.50 4 0.1 154 10600 7.45 4 0 157 10582 19.50 4 0 152 10586 7.00 4 0.15 135 10589 18.00 4 0 176 10593 18.00 4 0.2 138 10541 263.50 4 0.1 159 10517 55.00 4 0 175 10460 6.20 4 0.25 128 10312 36.40 4 0 125 10323 11.20 4 0 139 10323 14.40 4 0 131 10325 10.00 4 0 168 10343 10.00 4 0.05 140 10347 14.70 4 0 135 10281 14.40 4 0 156 10295 30.40 4 0 172 10268 27.80 4 0 119 10421 7.30 4 0.15 129 10354 99.00 4 0 171 10364 17.20 5 0 165 10366 16.80 5 0 177 10366 10.40 5 0 121 10368 8.00 5 0.1 156 10426 30.40 5 0 136 10406 15.20 5 0.1 146 10436 9.60 5 0 172 10248 34.80 5 0 163 10293 35.10 5 0 167 10284 11.20 5 0.25 115 10323 12.40 5 0 162 10310 39.40 5 0 154 10306 5.90 5 0 170 10308 12.00 5 0 146 10466 9.60 5 0 111 10486 16.80 5 0 119 10487 7.30 5 0 177 10495 10.40 5 0 140 10498 18.40 5 0 124 10518 4.50 5 0 153 10520 32.80 5 0 157 10535 19.50 5 0.1 156 10596 38.00 5 0.2 126 10592 31.23 5 0.05 110 10568 31.00 5 0 177 10602 13.00 5 0.25 124 10620 4.50 5 0 152 10620 7.00 5 0 119 10621 9.20 5 0 139 10614 18.00 5 0 155 10615 24.00 5 0 142 10625 14.00 5 0 123 10674 9.00 5 0 136 10708 19.00 5 0 12 10703 19.00 5 0 11 10700 18.00 5 0.2 111 10726 21.00 5 0 161 10724 28.50 5 0 121 10716 10.00 5 0 119 10710 9.20 5 0 147 10710 9.50 5 0 138 10783 263.50 5 0 128 10740 45.60 5 0.2 174 10753 10.00 5 0 114 10750 23.25 5 0.15 12 10851 19.00 5 0.05 17 10858 30.00 5 0 113 10898 6.00 5 0 125 10887 14.00 5 0 143 10842 46.00 5 0 120 10828 81.00 5 0 162 10802 49.30 5 0.25 125 10810 14.00 5 0 170 10810 15.00 5 0 111 10944 21.00 5 0.25 138 10964 263.50 5 0 172 10958 34.80 5 0 14 10950 22.00 5 0 120 10927 81.00 5 0 152 10927 7.00 5 0 147 10928 9.50 5 0 176 10928 18.00 5 0 141 10909 9.65 5 0 161 10910 28.50 5 0 126 10973 31.23 5 0 156 11018 38.00 5 0 140 11038 18.40 5 0.2 161 11034 28.50 6 0 155 11001 24.00 6 0 126 11004 31.23 6 0 176 11004 18.00 6 0 141 10973 9.65 6 0 117 10972 39.00 6 0 144 10978 19.45 6 0.15 143 10987 46.00 6 0 116 10916 17.45 6 0 132 10916 32.00 6 0 175 10924 7.75 6 0 141 10951 9.65 6 0.05 17 10958 30.00 6 0 152 10961 7.00 6 0.05 118 10964 62.50 6 0 117 10949 39.00 6 0 170 10822 15.00 6 0 151 10821 53.00 6 0 154 10794 7.45 6 0.2 16 10830 25.00 6 0 135 10836 18.00 6 0 125 10840 14.00 6 0.2 113 10837 6.00 6 0 162 10902 49.30 6 0.15 117 10852 39.00 6 0 124 10866 4.50 6 0.25 168 10756 12.50 6 0.2 136 10739 19.00 6 0 113 10746 6.00 6 0 159 10749 55.00 6 0 110 10775 31.00 6 0 122 10763 21.00 6 0 155 10725 24.00 6 0 140 10728 18.40 6 0 13 10702 10.00 6 0 14 10704 22.00 6 0 19 10693 97.00 6 0 136 10687 19.00 6 0.25 142 10673 14.00 6 0 143 10673 46.00 6 0 147 10656 9.50 6 0.1 158 10636 13.25 6 0 154 10654 7.45 6 0.1 129 10624 123.79 6 0 148 10604 12.75 6 0.1 121 10609 10.00 6 0 11 10611 18.00 6 0 164 10574 33.25 6 0 163 10575 43.90 6 0 126 10587 31.23 6 0 157 10578 19.50 6 0 151 10537 53.00 6 0 141 10523 9.65 6 0.1 168 10521 12.50 6 0 170 10517 15.00 6 0 152 10517 7.00 6 0 149 10539 20.00 6 0 121 10550 10.00 6 0.1 131 10564 12.50 6 0.05 135 10553 18.00 6 0 153 10502 32.80 6 0 147 10512 9.50 6 0.15 142 10311 11.20 6 0 16 10325 20.00 6 0 176 10318 14.40 6 0 175 10347 6.20 6 0.15 132 10335 25.60 6 0.2 130 10282 20.70 6 0 124 10281 3.60 6 0 159 10275 44.00 6 0.05 175 10293 6.20 6 0 175 10294 6.20 6 0 122 10251 16.80 6 0.05 132 10258 25.60 6 0.2 139 10257 14.40 6 0 120 10272 64.80 6 0 164 10439 26.60 6 0 139 10445 14.40 6 0 111 10443 16.80 6 0.2 126 10448 24.90 6 0 154 10450 5.90 6 0.2 154 10408 5.90 6 0 111 10434 16.80 6 0 136 10371 15.20 6 0.2 171 10378 17.20 6 0 160 10380 27.20 6 0.1 128 10387 36.40 6 0 125 10393 11.20 7 0.25 177 10367 10.40 7 0 164 10426 26.60 7 0 172 10274 27.80 7 0 12 10335 15.20 7 0.2 169 10311 28.80 7 0 177 10491 10.40 7 0.15 128 10544 45.60 7 0 167 10544 14.00 7 0 170 10538 15.00 7 0 119 10676 9.20 7 0 119 10697 9.20 7 0.25 151 10716 53.00 7 0 175 10773 7.75 7 0.2 172 10745 34.80 7 0 159 10757 55.00 7 0 154 10800 7.45 7 0.1 143 10819 46.00 7 0 113 10810 6.00 7 0 119 10926 9.20 7 0 133 10972 2.50 7 0 161 10998 28.50 7 0 113 11036 6.00 7 0 118 11026 62.50 8 0 128 11068 45.60 8 0.15 12 11072 19.00 8 0 11 11006 18.00 8 0 137 10966 26.00 8 0 118 10985 62.50 8 0.1 123 10935 9.00 8 0.25 128 10937 45.60 8 0 17 10940 30.00 8 0 151 10956 53.00 8 0 164 10957 33.25 8 0 148 10814 12.75 8 0.15 129 10834 123.79 8 0.05 135 10831 18.00 8 0 138 10831 263.50 8 0 152 10862 7.00 8 0 139 10899 18.00 8 0.15 124 10883 4.50 8 0 11 10752 18.00 8 0 131 10747 12.50 8 0 152 10793 7.00 8 0 171 10720 21.50 8 0 117 10698 39.00 8 0.05 170 10698 15.00 8 0.05 159 10706 55.00 8 0 133 10677 2.50 8 0.15 131 10668 12.50 8 0.1 118 10639 62.50 8 0 175 10631 7.75 8 0.1 113 10613 6.00 8 0.1 121 10614 10.00 8 0 113 10539 6.00 8 0 124 10520 4.50 8 0 133 10528 2.50 8 0.2 11 10526 18.00 8 0.15 117 10550 39.00 8 0.1 128 10500 45.60 8 0.05 130 10468 20.70 8 0 164 10470 26.60 8 0 117 10319 31.20 8 0 152 10334 5.60 8 0 130 10329 20.70 8 0.05 133 10341 2.00 8 0 163 10278 35.10 8 0 170 10420 12.00 8 0.1 135 10444 14.40 8 0 141 10379 7.70 8 0.1 160 10357 27.20 8 0.2 169 10395 28.80 8 0 168 10385 10.00 8 0.2 118 10382 50.00 9 0 159 10411 44.00 9 0.2 164 10289 26.60 9 0 114 10249 18.60 9 0 159 10341 44.00 9 0.15 142 10345 11.20 9 0 159 10328 44.00 9 0 114 10325 18.60 9 0 146 10512 12.00 9 0.15 171 10541 21.50 9 0.1 172 10528 34.80 9 0 144 10518 19.45 9 0 173 10537 15.00 9 0 171 10598 21.50 9 0 141 10580 9.65 9 0.05 164 10629 33.25 9 0 135 10697 18.00 9 0.25 152 10683 7.00 9 0 162 10746 49.30 9 0 163 10747 43.90 9 0 143 10831 46.00 9 0 131 10833 12.50 9 0.1 153 10833 32.80 9 0.1 170 10824 15.00 9 0 169 10962 36.00 9 0 150 10948 16.25 9 0 143 10982 46.00 9 0 146 10969 12.00 9 0 160 11009 34.00 9 0 141 11067 9.65 9 0 12 11049 19.00 10 0.2 119 11076 9.20 10 0.25 12 11075 19.00 10 0.15 111 11073 21.00 10 0 113 11071 6.00 10 0.05 133 11054 2.50 10 0 177 11060 13.00 10 0 153 11062 32.80 10 0.2 151 11026 53.00 10 0 11 11025 18.00 10 0.1 11 11035 18.00 10 0 154 11035 7.45 10 0 124 11051 4.50 10 0.2 161 11052 28.50 10 0.2 111 11043 21.00 10 0 124 11010 4.50 10 0 123 11013 9.00 10 0 118 11018 62.50 10 0 129 11007 123.79 10 0 159 11005 55.00 10 0 140 11003 18.40 10 0 152 11003 7.00 10 0 175 10973 7.75 10 0 163 10974 43.90 10 0 175 10975 7.75 10 0 151 10977 53.00 10 0 140 10978 18.40 10 0 176 10986 18.00 10 0 131 10945 12.50 10 0 12 10939 19.00 10 0.15 169 10964 36.00 10 0 124 10960 4.50 10 0.25 172 10926 34.80 10 0 113 10926 6.00 10 0 142 10923 14.00 10 0.2 143 10923 46.00 10 0.2 160 10917 34.00 10 0 117 10915 39.00 10 0 154 10915 7.45 10 0 135 10921 18.00 10 0 11 10911 18.00 10 0 149 10910 20.00 10 0 12 10829 19.00 10 0 113 10829 6.00 10 0 125 10832 14.00 10 0.2 139 10840 18.00 10 0.2 151 10800 53.00 10 0.1 134 10805 14.00 10 0 138 10805 263.50 10 0 144 10796 19.45 10 0 172 10798 34.80 10 0 110 10874 31.00 10 0 165 10879 21.05 10 0 176 10879 18.00 10 0 173 10881 15.00 10 0 134 10890 14.00 10 0 124 10893 4.50 10 0 111 10869 21.00 10 0 155 10872 24.00 10 0.05 118 10853 62.50 10 0 125 10851 14.00 10 0.05 157 10851 19.50 10 0.05 127 10858 43.90 10 0 129 10857 123.79 10 0.25 176 10749 18.00 10 0 132 10759 32.00 10 0 12 10792 19.00 10 0 131 10783 12.50 10 0 110 10785 31.00 10 0 175 10785 7.75 10 0 141 10778 9.65 10 0 129 10687 123.79 10 0 18 10695 40.00 10 0 161 10716 28.50 10 0 160 10709 34.00 10 0 165 10730 21.05 10 0.05 156 10727 38.00 10 0.05 159 10727 55.00 10 0.05 160 10625 34.00 10 0 128 10624 45.60 10 0 111 10637 21.00 10 0 14 10635 22.00 10 0.1 116 10671 17.45 10 0 162 10671 49.30 10 0 153 10675 32.80 10 0 147 10657 9.50 10 0 176 10665 18.00 10 0 165 10666 21.05 10 0 168 10662 12.50 10 0 115 10579 15.50 10 0 129 10583 123.79 10 0 169 10583 36.00 10 0.15 17 10591 30.00 10 0 162 10574 49.30 10 0 176 10575 18.00 10 0 11 10576 18.00 10 0 139 10577 18.00 10 0 176 10566 18.00 10 0 132 10572 32.00 10 0.1 162 10599 49.30 10 0 176 10604 18.00 10 0.1 12 10611 19.00 10 0 110 10609 31.00 10 0 162 10606 49.30 10 0.2 144 10624 19.45 10 0 123 10621 9.00 10 0 140 10535 18.40 10 0.1 169 10529 36.00 10 0 130 10534 25.89 10 0 140 10534 18.40 10 0.2 154 10534 7.45 10 0.2 160 10519 34.00 10 0.05 1There are also 593 rows where there should only be 263. In the outpu, the first row shold have an OrderID of 10609 and ProductID should be 1. |
|
|
|
|
|
|
|
|
Urgently need help with quartiles in sql