| ==== |
| ---- QUERY: TPCH-Q11 |
| # Q11 - Important Stock Identification |
| # Modifications: query was rewritten to not have a subquery in the having clause |
| select |
| * |
| from ( |
| select |
| ps_partkey, |
| sum(ps_supplycost * ps_availqty) as value |
| from |
| supplier s, |
| s.s_partsupps ps, |
| region.r_nations n |
| where |
| s_nationkey = n_nationkey |
| and n_name = 'GERMANY' |
| group by |
| ps_partkey |
| ) as inner_query |
| where |
| value > ( |
| select |
| sum(ps_supplycost * ps_availqty) * 0.0001 |
| from |
| supplier s, |
| s.s_partsupps ps, |
| region.r_nations n |
| where |
| s_nationkey = n_nationkey |
| and n_name = 'GERMANY' |
| ) |
| order by |
| value desc |
| ---- RESULTS |
| 129760,17538456.86 |
| 166726,16503353.92 |
| 191287,16474801.97 |
| 161758,16101755.54 |
| 34452,15983844.72 |
| 139035,15907078.34 |
| 9403,15451755.62 |
| 154358,15212937.88 |
| 38823,15064802.86 |
| 85606,15053957.15 |
| 33354,14408297.40 |
| 154747,14407580.68 |
| 82865,14235489.78 |
| 76094,14094247.04 |
| 222,13937777.74 |
| 121271,13908336.00 |
| 55221,13716120.47 |
| 22819,13666434.28 |
| 76281,13646853.68 |
| 85298,13581154.93 |
| 85158,13554904.00 |
| 139684,13535538.72 |
| 31034,13498025.25 |
| 87305,13482847.04 |
| 10181,13445148.75 |
| 62323,13411824.30 |
| 26489,13377256.38 |
| 96493,13339057.83 |
| 56548,13329014.97 |
| 55576,13306843.35 |
| 159751,13306614.48 |
| 92406,13287414.50 |
| 182636,13223726.74 |
| 199969,13135288.21 |
| 62865,13001926.94 |
| 7284,12945298.19 |
| 197867,12944510.52 |
| 11562,12931575.51 |
| 75165,12916918.12 |
| 97175,12911283.50 |
| 140840,12896562.23 |
| 65241,12890600.46 |
| 166120,12876927.22 |
| 9035,12863828.70 |
| 144616,12853549.30 |
| 176723,12832309.74 |
| 170884,12792136.58 |
| 29790,12723300.33 |
| 95213,12555483.73 |
| 183873,12550533.05 |
| 171235,12476538.30 |
| 21533,12437821.32 |
| 17290,12432159.50 |
| 156397,12260623.50 |
| 122611,12222812.98 |
| 139155,12220319.25 |
| 146316,12215800.61 |
| 171381,12199734.52 |
| 198633,12078226.95 |
| 167417,12046637.62 |
| 59512,12043468.76 |
| 31688,12034893.64 |
| 159586,12001505.84 |
| 8993,11963814.30 |
| 120302,11857707.55 |
| 43536,11779340.52 |
| 9552,11776909.16 |
| 86223,11772205.08 |
| 53776,11758669.65 |
| 131285,11616953.74 |
| 91628,11611114.83 |
| 169644,11567959.72 |
| 182299,11567462.05 |
| 33107,11453818.76 |
| 104184,11436657.44 |
| 67027,11419127.14 |
| 176869,11371451.71 |
| 30885,11369674.79 |
| 54420,11345076.88 |
| 72240,11313951.05 |
| 178708,11294635.17 |
| 81298,11273686.13 |
| 158324,11243442.72 |
| 117095,11242535.24 |
| 176793,11237733.38 |
| 86091,11177793.79 |
| 116033,11145434.36 |
| 129058,11119112.20 |
| 193714,11104706.39 |
| 117195,11077217.96 |
| 49851,11043701.78 |
| 19791,11030662.62 |
| 75800,11012401.62 |
| 161562,10996371.69 |
| 10119,10980015.75 |
| 39185,10970042.56 |
| 47223,10950022.13 |
| 175594,10942923.05 |
| 111295,10893675.61 |
| 155446,10852764.57 |
| 156391,10839810.38 |
| 40884,10837234.19 |
| 141288,10837130.21 |
| 152388,10830977.82 |
| 33449,10830858.72 |
| 149035,10826130.02 |
| 162620,10814275.68 |
| 118324,10791788.10 |
| 38932,10777541.75 |
| 121294,10764225.22 |
| 48721,10762582.49 |
| 63342,10740132.60 |
| 5614,10724668.80 |
| 62266,10711143.10 |
| 100202,10696675.55 |
| 197741,10688560.72 |
| 169178,10648522.80 |
| 5271,10639392.65 |
| 34499,10584177.10 |
| 71108,10569117.56 |
| 137132,10539880.47 |
| 78451,10524873.24 |
| 150827,10503810.48 |
| 107237,10488030.84 |
| 101727,10473558.10 |
| 58708,10466280.44 |
| 89768,10465477.22 |
| 146493,10444291.58 |
| 55424,10444006.48 |
| 16560,10425574.74 |
| 133114,10415097.90 |
| 195810,10413625.20 |
| 76673,10391977.18 |
| 97305,10390890.57 |
| 134210,10387210.02 |
| 188536,10386529.92 |
| 122255,10335760.32 |
| 2682,10312966.10 |
| 43814,10303086.61 |
| 34767,10290405.18 |
| 165584,10273705.89 |
| 2231,10270415.55 |
| 111259,10263256.56 |
| 195578,10239795.82 |
| 21093,10217531.30 |
| 29856,10216932.54 |
| 133686,10213345.76 |
| 87745,10185509.40 |
| 135153,10179379.70 |
| 11773,10167410.84 |
| 76316,10165151.70 |
| 123076,10161225.78 |
| 91894,10130462.19 |
| 39741,10128387.52 |
| 111753,10119780.98 |
| 142729,10104748.89 |
| 116775,10097750.42 |
| 102589,10034784.36 |
| 186268,10012181.57 |
| 44545,10000286.48 |
| 23307,9966577.50 |
| 124281,9930018.90 |
| 69604,9925730.64 |
| 21971,9908982.03 |
| 58148,9895894.40 |
| 16532,9886529.90 |
| 159180,9883744.43 |
| 74733,9877582.88 |
| 35173,9858275.92 |
| 7116,9856881.02 |
| 124620,9838589.14 |
| 122108,9829949.35 |
| 67200,9828690.69 |
| 164775,9821424.44 |
| 9039,9816447.72 |
| 14912,9803102.20 |
| 190906,9791315.70 |
| 130398,9781674.27 |
| 119310,9776927.21 |
| 10132,9770930.78 |
| 107211,9757586.25 |
| 113958,9757065.50 |
| 37009,9748362.69 |
| 66746,9743528.76 |
| 134486,9731922.00 |
| 15945,9731096.45 |
| 55307,9717745.80 |
| 56362,9714922.83 |
| 57726,9711792.10 |
| 57256,9708621.00 |
| 112292,9701653.08 |
| 87514,9699492.53 |
| 174206,9680562.02 |
| 72865,9679043.34 |
| 114357,9671017.44 |
| 112807,9665019.21 |
| 115203,9661018.73 |
| 177454,9658906.35 |
| 161275,9634313.71 |
| 61893,9617095.44 |
| 122219,9604888.20 |
| 183427,9601362.58 |
| 59158,9599705.96 |
| 61931,9584918.98 |
| 5532,9579964.14 |
| 20158,9576714.38 |
| 167199,9557413.08 |
| 38869,9550279.53 |
| 86949,9541943.70 |
| 198544,9538613.92 |
| 193762,9538238.94 |
| 108807,9536247.16 |
| 168324,9535647.99 |
| 115588,9532195.04 |
| 141372,9529702.14 |
| 175120,9526068.66 |
| 163851,9522808.83 |
| 160954,9520359.45 |
| 117757,9517882.80 |
| 52594,9508325.76 |
| 60960,9498843.06 |
| 70272,9495775.62 |
| 44050,9495515.36 |
| 152213,9494756.96 |
| 121203,9492601.30 |
| 70114,9491012.30 |
| 167588,9484741.11 |
| 136455,9476241.78 |
| 4357,9464355.64 |
| 6786,9463632.57 |
| 61345,9455336.70 |
| 160826,9446754.84 |
| 71275,9440138.40 |
| 77746,9439118.35 |
| 91289,9437472.00 |
| 56723,9435102.16 |
| 86647,9434604.18 |
| 131234,9432120.00 |
| 198129,9427651.36 |
| 165530,9426193.68 |
| 69233,9425053.92 |
| 6243,9423304.66 |
| 90110,9420422.70 |
| 191980,9419368.36 |
| 38461,9419316.07 |
| 167873,9419024.49 |
| 159373,9416950.15 |
| 128707,9413428.50 |
| 45267,9410863.78 |
| 48460,9409793.93 |
| 197672,9406887.68 |
| 60884,9403442.40 |
| 15209,9403245.31 |
| 138049,9401262.10 |
| 199286,9391770.70 |
| 19629,9391236.40 |
| 134019,9390615.15 |
| 169475,9387639.58 |
| 165918,9379510.44 |
| 135602,9374251.54 |
| 162323,9367566.51 |
| 96277,9360850.68 |
| 98336,9359671.29 |
| 119781,9356395.73 |
| 34440,9355365.00 |
| 57362,9355180.10 |
| 167236,9352973.84 |
| 38463,9347530.94 |
| 86749,9346826.44 |
| 170007,9345699.90 |
| 193087,9343744.00 |
| 150383,9332576.75 |
| 60932,9329582.02 |
| 128420,9328206.35 |
| 162145,9327722.88 |
| 55686,9320304.40 |
| 163080,9304916.96 |
| 160583,9303515.92 |
| 118153,9298606.56 |
| 152634,9282184.57 |
| 84731,9276586.92 |
| 119989,9273814.20 |
| 114584,9269698.65 |
| 131817,9268570.08 |
| 29068,9256583.88 |
| 44116,9255922.00 |
| 115818,9253311.91 |
| 103388,9239218.08 |
| 186118,9236209.12 |
| 155809,9235410.84 |
| 147003,9234847.99 |
| 27769,9232511.64 |
| 112779,9231927.36 |
| 124851,9228982.68 |
| 158488,9227216.40 |
| 83328,9224792.20 |
| 136797,9222927.09 |
| 141730,9216370.68 |
| 87304,9215695.50 |
| 156004,9215557.90 |
| 140740,9215329.20 |
| 100648,9212185.08 |
| 174774,9211718.00 |
| 37644,9211578.60 |
| 48807,9209496.24 |
| 95940,9207948.40 |
| 141586,9206699.22 |
| 147248,9205654.95 |
| 61372,9205228.76 |
| 52970,9204415.95 |
| 26430,9203710.51 |
| 28504,9201669.20 |
| 25810,9198878.50 |
| 125329,9198688.50 |
| 167867,9194022.72 |
| 134767,9191444.72 |
| 127745,9191271.56 |
| 69208,9187110.00 |
| 155222,9186469.16 |
| 196916,9182995.82 |
| 195590,9176353.12 |
| 169155,9175176.09 |
| 81558,9171946.50 |
| 185136,9171293.04 |
| 114790,9168509.10 |
| 194142,9165836.61 |
| 167639,9161165.00 |
| 11241,9160789.46 |
| 82628,9160155.54 |
| 41399,9148338.00 |
| 30755,9146196.84 |
| 6944,9143574.58 |
| 6326,9138803.16 |
| 101296,9135657.62 |
| 181479,9121093.30 |
| 76898,9120983.10 |
| 64274,9118745.25 |
| 175826,9117387.99 |
| 142215,9116876.88 |
| 103415,9113128.62 |
| 119765,9110768.79 |
| 107624,9108837.45 |
| 84215,9105257.36 |
| 73774,9102651.92 |
| 173972,9102069.00 |
| 69817,9095513.88 |
| 86943,9092253.00 |
| 138859,9087719.30 |
| 162273,9085296.48 |
| 175945,9080401.21 |
| 16836,9075715.44 |
| 70224,9075265.95 |
| 139765,9074755.89 |
| 30319,9073233.10 |
| 3851,9072657.24 |
| 181271,9070631.52 |
| 162184,9068835.78 |
| 81683,9067258.47 |
| 153028,9067010.51 |
| 123324,9061870.95 |
| 186481,9058608.30 |
| 167680,9052908.76 |
| 165293,9050545.70 |
| 122148,9046298.17 |
| 138604,9045840.80 |
| 78851,9044822.60 |
| 137280,9042355.34 |
| 8823,9040855.10 |
| 163900,9040848.48 |
| 75600,9035392.45 |
| 81676,9031999.40 |
| 46033,9031460.58 |
| 194917,9028500.00 |
| 133936,9026949.02 |
| 33182,9024971.10 |
| 34220,9021485.39 |
| 20118,9019942.60 |
| 178258,9019881.66 |
| 15560,9017687.28 |
| 111425,9016198.56 |
| 95942,9015585.12 |
| 132709,9015240.15 |
| 39731,9014746.95 |
| 154307,9012571.20 |
| 23769,9008157.60 |
| 93328,9007211.20 |
| 142826,8998297.44 |
| 188792,8996014.00 |
| 68703,8994982.22 |
| 145280,8990941.05 |
| 150725,8985686.16 |
| 172046,8982469.52 |
| 70476,8967629.50 |
| 124988,8966805.22 |
| 17937,8963319.76 |
| 177372,8954873.64 |
| 137994,8950916.79 |
| 84019,8950039.98 |
| 40389,8946158.20 |
| 69187,8941054.14 |
| 4863,8939044.92 |
| 50465,8930503.14 |
| 43686,8915543.84 |
| 131352,8909053.59 |
| 198916,8906940.03 |
| 135932,8905282.95 |
| 104673,8903682.00 |
| 152308,8903244.08 |
| 135298,8900323.20 |
| 156873,8899429.10 |
| 157454,8897339.20 |
| 75415,8897068.09 |
| 46325,8895569.09 |
| 1966,8895117.06 |
| 24576,8895034.75 |
| 19425,8890156.60 |
| 169735,8890085.56 |
| 32225,8889829.28 |
| 124537,8889770.71 |
| 146327,8887836.23 |
| 121562,8887740.40 |
| 44731,8882444.95 |
| 93141,8881850.88 |
| 187871,8873506.18 |
| 71709,8873057.28 |
| 151913,8869321.17 |
| 33786,8868955.39 |
| 35902,8868126.06 |
| 23588,8867769.90 |
| 24508,8867616.00 |
| 161282,8866661.43 |
| 188061,8862304.00 |
| 132847,8862082.00 |
| 166843,8861200.80 |
| 30609,8860214.73 |
| 56191,8856546.96 |
| 160740,8852685.43 |
| 71229,8846106.99 |
| 91208,8845541.28 |
| 10995,8845306.56 |
| 78094,8839938.29 |
| 36489,8838538.10 |
| 198437,8836494.84 |
| 151693,8833807.64 |
| 185367,8829791.37 |
| 65682,8820622.89 |
| 65421,8819329.24 |
| 122225,8816821.86 |
| 85330,8811013.16 |
| 64555,8810643.12 |
| 104188,8808211.02 |
| 54411,8805703.40 |
| 39438,8805282.56 |
| 70795,8800060.92 |
| 20383,8799073.28 |
| 21952,8798624.19 |
| 63584,8796590.00 |
| 158768,8796422.95 |
| 166588,8796214.38 |
| 120600,8793558.06 |
| 157202,8788287.88 |
| 55358,8786820.75 |
| 168322,8786670.73 |
| 25143,8786324.80 |
| 5368,8786274.14 |
| 114025,8786201.12 |
| 97744,8785315.94 |
| 164327,8784503.86 |
| 76542,8782613.28 |
| 4731,8772846.70 |
| 157590,8772006.45 |
| 154276,8771733.91 |
| 28705,8771576.64 |
| 100226,8769455.00 |
| 179195,8769185.16 |
| 184355,8768118.05 |
| 120408,8768011.12 |
| 63145,8761991.96 |
| 53135,8753491.80 |
| 173071,8750508.80 |
| 41087,8749436.79 |
| 194830,8747438.40 |
| 43496,8743359.30 |
| 30235,8741611.00 |
| 26391,8741399.64 |
| 191816,8740258.72 |
| 47616,8737229.68 |
| 152101,8734432.76 |
| 163784,8730514.34 |
| 5134,8728424.64 |
| 155241,8725429.86 |
| 188814,8724182.40 |
| 140782,8720378.75 |
| 153141,8719407.51 |
| 169373,8718609.06 |
| 41335,8714773.80 |
| 197450,8714617.32 |
| 87004,8714017.79 |
| 181804,8712257.76 |
| 122814,8711119.14 |
| 109939,8709193.16 |
| 98094,8708780.04 |
| 74630,8708040.75 |
| 197291,8706519.09 |
| 184173,8705467.45 |
| 192175,8705411.12 |
| 19471,8702536.12 |
| 18052,8702155.70 |
| 135560,8698137.72 |
| 152791,8697325.80 |
| 170953,8696909.19 |
| 116137,8696687.17 |
| 7722,8696589.40 |
| 49788,8694846.71 |
| 13252,8694822.42 |
| 12633,8694559.36 |
| 193438,8690426.72 |
| 17326,8689329.16 |
| 96124,8679794.58 |
| 143802,8676626.48 |
| 30389,8675826.60 |
| 75250,8675257.14 |
| 72613,8673524.94 |
| 123520,8672456.25 |
| 325,8667741.28 |
| 167291,8667556.18 |
| 150119,8663403.54 |
| 88420,8663355.40 |
| 179784,8653021.34 |
| 130884,8651970.00 |
| 172611,8648217.00 |
| 85373,8647796.22 |
| 122717,8646758.54 |
| 113431,8646348.34 |
| 66015,8643349.40 |
| 33141,8643243.18 |
| 69786,8637396.92 |
| 181857,8637393.28 |
| 122939,8636378.00 |
| 196223,8635391.02 |
| 50532,8632648.24 |
| 58102,8632614.54 |
| 93581,8632372.36 |
| 52804,8632109.25 |
| 755,8627091.68 |
| 16597,8623357.05 |
| 119041,8622397.00 |
| 89050,8621185.98 |
| 98696,8620784.82 |
| 94399,8620524.00 |
| 151295,8616671.02 |
| 56417,8613450.35 |
| 121322,8612948.23 |
| 126883,8611373.42 |
| 29155,8610163.64 |
| 114530,8608471.74 |
| 131007,8607394.82 |
| 128715,8606833.62 |
| 72522,8601479.98 |
| 144061,8595718.74 |
| 83503,8595034.20 |
| 112199,8590717.44 |
| 9227,8587350.42 |
| 116318,8585910.66 |
| 41248,8585559.64 |
| 159398,8584821.00 |
| 105966,8582308.79 |
| 137876,8580641.30 |
| 122272,8580400.77 |
| 195717,8577278.10 |
| 165295,8571121.92 |
| 5840,8570728.74 |
| 120860,8570610.44 |
| 66692,8567540.52 |
| 135596,8563276.31 |
| 150576,8562794.10 |
| 7500,8562393.84 |
| 107716,8561541.56 |
| 100611,8559995.85 |
| 171192,8557390.08 |
| 107660,8556696.60 |
| 13461,8556545.12 |
| 90310,8555131.51 |
| 141493,8553782.93 |
| 71286,8552682.00 |
| 136423,8551300.76 |
| 54241,8550785.25 |
| 120325,8549976.60 |
| 424,8547527.10 |
| 196543,8545907.09 |
| 13042,8542717.18 |
| 58332,8536074.69 |
| 9191,8535663.92 |
| 134357,8535429.90 |
| 96207,8534900.60 |
| 92292,8530618.78 |
| 181093,8528303.52 |
| 105064,8527491.60 |
| 59635,8526854.08 |
| 136974,8524351.56 |
| 126694,8522783.37 |
| 6247,8522606.90 |
| 139447,8522521.92 |
| 96313,8520949.92 |
| 108454,8520916.25 |
| 181254,8519496.10 |
| 71117,8519223.00 |
| 131703,8517215.28 |
| 59312,8510568.36 |
| 2903,8509960.35 |
| 102838,8509527.69 |
| 162806,8508906.05 |
| 41527,8508222.36 |
| 118416,8505858.36 |
| 180203,8505024.16 |
| 14773,8500598.28 |
| 140446,8499514.24 |
| 199641,8497362.59 |
| 109240,8494617.12 |
| 150268,8494188.38 |
| 45310,8492380.65 |
| 36552,8490733.60 |
| 199690,8490145.80 |
| 185353,8488726.68 |
| 163615,8484985.01 |
| 196520,8483545.04 |
| 133438,8483482.35 |
| 77285,8481442.32 |
| 55824,8476893.90 |
| 76753,8475522.12 |
| 46129,8472717.96 |
| 28358,8472515.50 |
| 9317,8472145.32 |
| 33823,8469721.44 |
| 39055,8469145.07 |
| 91471,8468874.56 |
| 142299,8466039.55 |
| 97672,8464119.80 |
| 134712,8461781.79 |
| 157988,8460123.20 |
| 102284,8458652.44 |
| 73533,8458453.32 |
| 90599,8457874.86 |
| 112160,8457863.36 |
| 124792,8457633.70 |
| 66097,8457573.15 |
| 165271,8456969.01 |
| 146925,8454887.91 |
| 164277,8454838.50 |
| 131290,8454811.20 |
| 179386,8450909.90 |
| 90486,8447873.86 |
| 175924,8444421.66 |
| 185922,8442394.88 |
| 38492,8436438.32 |
| 172511,8436287.34 |
| 139539,8434180.29 |
| 11926,8433199.52 |
| 55889,8431449.88 |
| 163068,8431116.40 |
| 138772,8428406.36 |
| 126821,8425180.68 |
| 22091,8420687.88 |
| 55981,8419434.38 |
| 100960,8419403.46 |
| 172568,8417955.21 |
| 63135,8415945.53 |
| 137651,8413170.35 |
| 191353,8413039.84 |
| 62988,8411571.48 |
| 103417,8411541.12 |
| 12052,8411519.28 |
| 104260,8408516.55 |
| 157129,8405730.08 |
| 77254,8405537.22 |
| 112966,8403512.89 |
| 168114,8402764.56 |
| 49940,8402328.20 |
| 52017,8398753.60 |
| 176179,8398087.00 |
| 100215,8395906.61 |
| 61256,8392811.20 |
| 15366,8388907.80 |
| 109479,8388027.20 |
| 66202,8386522.83 |
| 81707,8385761.19 |
| 51727,8385426.40 |
| 9980,8382754.62 |
| 174403,8378575.73 |
| 54558,8378041.92 |
| 3141,8377378.22 |
| 134829,8377105.52 |
| 145056,8376920.76 |
| 194020,8375157.64 |
| 7117,8373982.27 |
| 120146,8373796.20 |
| 126843,8370761.28 |
| 62117,8369493.44 |
| 111221,8367525.81 |
| 159337,8366092.26 |
| 173903,8365428.48 |
| 136438,8364065.45 |
| 56684,8363198.00 |
| 137597,8363185.94 |
| 20039,8361138.24 |
| 121326,8359635.52 |
| 48435,8352863.10 |
| 1712,8349107.00 |
| 167190,8347238.70 |
| 32113,8346452.04 |
| 40580,8342983.32 |
| 74785,8342519.13 |
| 14799,8342236.75 |
| 177291,8341736.83 |
| 198956,8340370.65 |
| 69179,8338465.99 |
| 118764,8337616.56 |
| 128814,8336435.56 |
| 82729,8331766.88 |
| 152048,8330638.99 |
| 171085,8326259.50 |
| 126730,8325974.40 |
| 77525,8323282.50 |
| 170653,8322840.50 |
| 5257,8320350.78 |
| 67350,8318987.56 |
| 109008,8317836.54 |
| 199043,8316603.54 |
| 139969,8316551.54 |
| 22634,8316531.24 |
| 173309,8315750.25 |
| 10887,8315019.36 |
| 42392,8312895.96 |
| 126040,8312623.20 |
| 101590,8304555.42 |
| 46891,8302192.12 |
| 138721,8301745.62 |
| 113715,8301533.20 |
| 78778,8299685.64 |
| 142908,8299447.77 |
| 64419,8297631.80 |
| 21396,8296272.27 |
| 4180,8295646.92 |
| 63534,8295383.67 |
| 135957,8294389.86 |
| 30126,8291920.32 |
| 158427,8288938.00 |
| 14545,8288395.92 |
| 75548,8288287.20 |
| 64473,8286137.44 |
| 149553,8285714.88 |
| 151284,8283526.65 |
| 171091,8282934.36 |
| 194256,8278985.34 |
| 952,8276136.00 |
| 121541,8275390.26 |
| 177664,8275315.20 |
| 51117,8274504.30 |
| 66770,8273407.80 |
| 37238,8272728.06 |
| 46679,8270486.55 |
| 165852,8268312.60 |
| 99458,8266564.47 |
| 114519,8265493.54 |
| 7231,8264881.50 |
| 19033,8264826.56 |
| 125123,8262732.65 |
| 18642,8261578.99 |
| 50386,8261380.05 |
| 193770,8259578.82 |
| 7276,8258101.60 |
| 178045,8253904.15 |
| 49033,8253696.23 |
| 187195,8251334.58 |
| 10590,8249227.40 |
| 143779,8247057.70 |
| 35205,8245675.17 |
| 19729,8245081.60 |
| 144946,8240479.80 |
| 123786,8239581.24 |
| 70843,8237973.20 |
| 112437,8236907.52 |
| 5436,8236039.57 |
| 163754,8235471.16 |
| 115945,8234811.36 |
| 27918,8233957.88 |
| 105712,8233571.86 |
| 41007,8229431.79 |
| 40476,8226640.41 |
| 145620,8221371.60 |
| 7771,8220413.33 |
| 86424,8215572.61 |
| 129137,8215478.40 |
| 76020,8210495.36 |
| 140213,8209831.80 |
| 32379,8208338.88 |
| 130616,8207715.75 |
| 195469,8206609.80 |
| 191805,8205147.75 |
| 90906,8200951.20 |
| 170910,8195558.01 |
| 105399,8193122.63 |
| 123798,8192385.97 |
| 90218,8191689.16 |
| 114766,8189339.54 |
| 11289,8187354.72 |
| 178308,8185750.50 |
| 71271,8185519.24 |
| 1115,8184903.38 |
| 152636,8184530.72 |
| 151619,8182909.05 |
| 116943,8181072.69 |
| 28891,8181051.54 |
| 47049,8180955.00 |
| 158827,8180470.90 |
| 92620,8179671.55 |
| 20814,8176953.54 |
| 179323,8176795.55 |
| 193453,8174343.94 |
| 56888,8173342.00 |
| 28087,8169876.30 |
| 164254,8169632.35 |
| 57661,8168848.16 |
| 7363,8167538.05 |
| 164499,8167512.08 |
| 197557,8165940.45 |
| 5495,8164805.22 |
| 966,8163824.79 |
| 98435,8161771.45 |
| 127227,8161344.92 |
| 194100,8160978.78 |
| 40134,8160358.08 |
| 107341,8159952.05 |
| 6790,8158792.66 |
| 43851,8157101.40 |
| 51295,8156419.20 |
| 69512,8151537.00 |
| 164274,8149869.93 |
| 130854,8145338.85 |
| 186865,8143586.82 |
| 176629,8141411.20 |
| 193739,8141377.77 |
| 6810,8139822.60 |
| 27732,8136724.96 |
| 50616,8134089.82 |
| 123908,8128920.54 |
| 140994,8128470.82 |
| 99039,8128290.78 |
| 62735,8124940.50 |
| 47829,8122796.50 |
| 192635,8122687.57 |
| 192429,8119268.00 |
| 145812,8119165.63 |
| 42896,8118529.80 |
| 146877,8118266.16 |
| 60882,8116095.04 |
| 18254,8114783.04 |
| 165464,8114571.80 |
| 57936,8111927.25 |
| 52226,8110723.32 |
| 128571,8106788.80 |
| 100308,8105837.04 |
| 8872,8102395.62 |
| 58867,8102033.19 |
| 145153,8100222.84 |
| 172088,8098138.20 |
| 59398,8095845.45 |
| 89395,8093576.10 |
| 171961,8093538.00 |
| 88736,8090762.16 |
| 174053,8090350.11 |
| 102237,8089103.22 |
| 43041,8086537.90 |
| 110219,8085296.90 |
| 126738,8084199.20 |
| 44787,8083628.40 |
| 31277,8083580.76 |
| 93595,8082188.80 |
| 189040,8080257.21 |
| 59851,8079024.24 |
| 175100,8077904.01 |
| 43429,8076729.96 |
| 154199,8074940.76 |
| 60963,8073894.40 |
| 8768,8072760.96 |
| 66095,8071421.70 |
| 111552,8068184.48 |
| 24563,8067500.40 |
| 16167,8067495.24 |
| 12662,8067248.85 |
| 94540,8063727.16 |
| 23308,8063463.18 |
| 27390,8062823.25 |
| 130660,8062787.48 |
| 8608,8062411.16 |
| 181552,8062008.30 |
| 199319,8060248.56 |
| 55475,8058850.92 |
| 142711,8057926.58 |
| 103499,8056978.00 |
| 105943,8056698.75 |
| 8432,8053052.16 |
| 149392,8049675.69 |
| 101248,8048855.49 |
| 140962,8047260.70 |
| 87101,8046651.83 |
| 133107,8046476.73 |
| 45126,8045924.40 |
| 87508,8042966.39 |
| 124711,8042722.72 |
| 173169,8042224.41 |
| 175161,8041331.98 |
| 167787,8040075.78 |
| 3242,8038855.53 |
| 114789,8038628.35 |
| 43833,8038545.83 |
| 141198,8035110.72 |
| 137248,8034109.35 |
| 96673,8033491.20 |
| 32180,8032380.72 |
| 166493,8031902.40 |
| 66959,8031839.40 |
| 85628,8029693.44 |
| 110971,8029469.70 |
| 130395,8027463.92 |
| 7757,8026840.37 |
| 178446,8025379.09 |
| 41295,8024785.53 |
| 100956,8024179.30 |
| 131917,8021604.78 |
| 24224,8020463.52 |
| 2073,8020009.64 |
| 121622,8018462.17 |
| 14357,8016906.30 |
| 135601,8016209.44 |
| 58458,8016192.52 |
| 73036,8015799.00 |
| 184722,8015680.31 |
| 151664,8014821.96 |
| 195090,8012680.20 |
| 162609,8011241.00 |
| 83532,8009753.85 |
| 50166,8007137.89 |
| 181562,8006805.96 |
| 175165,8005319.76 |
| 62500,8005316.28 |
| 36342,8004333.40 |
| 128435,8004242.88 |
| 92516,8003836.80 |
| 30802,8003710.88 |
| 107418,8000430.30 |
| 46620,7999778.35 |
| 191803,7994734.15 |
| 106343,7993087.76 |
| 59362,7990397.46 |
| 8329,7990052.90 |
| 75133,7988244.00 |
| 179023,7986829.62 |
| 135899,7985726.64 |
| 5824,7985340.02 |
| 148579,7984889.56 |
| 95888,7984735.72 |
| 9791,7982699.79 |
| 170437,7982370.72 |
| 39782,7977858.24 |
| 20605,7977556.00 |
| 28682,7976960.00 |
| 42172,7973399.00 |
| 56137,7971405.40 |
| 64729,7970769.72 |
| 98643,7968603.73 |
| 153787,7967535.58 |
| 8932,7967222.19 |
| 20134,7965713.28 |
| 197635,7963507.58 |
| 80408,7963312.17 |
| 37728,7961875.68 |
| 26624,7961772.31 |
| 44736,7961144.10 |
| 29763,7960605.03 |
| 36147,7959463.68 |
| 146040,7957587.66 |
| 115469,7957485.14 |
| 142276,7956790.63 |
| 181280,7954037.35 |
| 115096,7953047.55 |
| 109650,7952258.73 |
| 93862,7951992.24 |
| 158325,7950728.30 |
| 55952,7950387.06 |
| 122397,7947106.27 |
| 28114,7946945.72 |
| 11966,7945197.48 |
| 47814,7944083.00 |
| 85096,7943691.06 |
| 51657,7943593.77 |
| 196680,7943578.89 |
| 13141,7942730.34 |
| 193327,7941036.25 |
| 152612,7940663.71 |
| 139680,7939242.36 |
| 31134,7938318.30 |
| 45636,7937240.85 |
| 56694,7936015.95 |
| 8114,7933921.88 |
| 71518,7932261.69 |
| 72922,7930400.64 |
| 146699,7929167.40 |
| 92387,7928972.67 |
| 186289,7928786.19 |
| 95952,7927972.78 |
| 196514,7927180.70 |
| 4403,7925729.04 |
| 2267,7925649.37 |
| 45924,7925047.68 |
| 11493,7916722.23 |
| 104478,7916253.60 |
| 166794,7913842.00 |
| 161995,7910874.27 |
| 23538,7909752.06 |
| 41093,7909579.92 |
| 112073,7908617.57 |
| 92814,7908262.50 |
| 88919,7907992.50 |
| 79753,7907933.88 |
| 108765,7905338.98 |
| 146530,7905336.60 |
| 71475,7903367.58 |
| 36289,7901946.50 |
| 61739,7900794.00 |
| 52338,7898638.08 |
| 194299,7898421.24 |
| 105235,7897829.94 |
| 77207,7897752.72 |
| 96712,7897575.27 |
| 10157,7897046.25 |
| 171154,7896814.50 |
| 79373,7896186.00 |
| 113808,7893353.88 |
| 27901,7892952.00 |
| 128820,7892882.72 |
| 25891,7890511.20 |
| 122819,7888881.02 |
| 154731,7888301.33 |
| 101674,7879324.60 |
| 51968,7879102.21 |
| 72073,7877736.11 |
| 5182,7874521.73 |
| ---- TYPES |
| BIGINT, decimal |
| ==== |