{"n1ql": "SELECT AVG( decimal_field1 ) FROM simple_table_1 WHERE (int_field1 != 4760) AND ((decimal_field1 > 4849) OR ((int_field1 != 4760) AND (decimal_field1 IN [ 5 , 9 , 13 , 15 , 48 ]))) ", "expected_result": [{"AVG( decimal_field1 )": 7385}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT AVG( decimal_field1 ) FROM simple_table_1 WHERE (int_field1 != 4760) AND ((decimal_field1 > 4849) OR ((int_field1 != 4760) AND (decimal_field1 IN ( 5 , 9 , 13 , 15 , 48 )))) "} {"n1ql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE NOT (((decimal_field1 IN [ 3 , 8 , 13 , 27 , 54 ]) AND ((decimal_field1 = 5082) AND (decimal_field1 <= 5082)) OR char_field1 <> \"N\")) ", "expected_result": [{"SUM( decimal_field1 )": 226665}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE NOT (((decimal_field1 IN ( 3 , 8 , 13 , 27 , 54 )) AND ((decimal_field1 = 5082) AND (decimal_field1 <= 5082)) OR char_field1 <> \"N\")) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE decimal_field1 IN [ 3 , 8 , 13 , 27 , 54 ] ", "expected_result": [{"SUM( int_field1 )": 31324}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE decimal_field1 IN ( 3 , 8 , 13 , 27 , 54 ) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_1 WHERE (decimal_field1 > 4849) AND ((decimal_field1 > 4849) OR (decimal_field1 > 4849)) ", "expected_result": [{"COUNT(*)": 507}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_1 WHERE (decimal_field1 > 4849) AND ((decimal_field1 > 4849) OR (decimal_field1 > 4849)) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_10 WHERE (bool_field1) AND ((varchar_field1 > \"ZWjEXagolJ\" AND decimal_field1 IN [ 3 , 8 , 13 , 27 , 54 ])) ", "expected_result": [{"COUNT(*)": 1}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_10 WHERE (bool_field1) AND ((varchar_field1 > \"ZWjEXagolJ\" AND decimal_field1 IN ( 3 , 8 , 13 , 27 , 54 ))) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE (bool_field1 = true AND char_field1 IN [ \"A\" , \"B\" , \"C\" , \"D\" , \"E\" ]) ", "expected_result": [{"SUM( int_field1 )": 447274}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE (bool_field1 = true AND char_field1 IN ( \"A\" , \"B\" , \"C\" , \"D\" , \"E\" )) "} {"n1ql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE (decimal_field1 IS NOT NULL) OR (decimal_field1 IN [ 3 , 8 , 13 , 27 , 54 ]) ", "expected_result": [{"SUM( decimal_field1 )": 5018763}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE (decimal_field1 IS NOT NULL) OR (decimal_field1 IN ( 3 , 8 , 13 , 27 , 54 )) "} {"n1ql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE NOT ((int_field1 <= 5069 OR NOT (NOT ((char_field1 = \"N\") OR (char_field1 IS NULL))))) ", "expected_result": [{"SUM( decimal_field1 )": 2477903}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE NOT ((int_field1 <= 5069 OR NOT (NOT ((char_field1 = \"N\") OR (char_field1 IS NULL))))) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_1 WHERE ((bool_field1 != false AND int_field1 IN [ 9 , 29 , 37 , 44 , 50 ])) AND ((bool_field1 != false AND int_field1 IN [ 9 , 29 , 37 , 44 , 50 ])) ", "expected_result": [{"COUNT(*)": 2}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_1 WHERE ((bool_field1 != false AND int_field1 IN ( 9 , 29 , 37 , 44 , 50 ))) AND ((bool_field1 != false AND int_field1 IN ( 9 , 29 , 37 , 44 , 50 ))) "} {"n1ql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE NOT ((int_field1 IN [ 3 , 13 , 21 , 27 , 36 ] OR varchar_field1 = \"ZWjEXagolJ\")) ", "expected_result": [{"SUM( decimal_field1 )": 4995141}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE NOT ((int_field1 IN ( 3 , 13 , 21 , 27 , 36 ) OR varchar_field1 = \"ZWjEXagolJ\")) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_1 WHERE NOT ((bool_field1 = false OR (char_field1 IN [ \"A\" , \"B\" , \"C\" , \"D\" , \"E\" ]) OR (char_field1 NOT LIKE \"N\"))) ", "expected_result": [{"COUNT(*)": 20}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_1 WHERE NOT ((bool_field1 = false OR (char_field1 IN ( \"A\" , \"B\" , \"C\" , \"D\" , \"E\" )) OR (char_field1 NOT LIKE \"N\"))) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_1 WHERE (int_field1 IN [ 9 , 29 , 37 , 44 , 50 ]) AND ((bool_field1 != true AND NOT (decimal_field1 > 4849))) ", "expected_result": [{"COUNT(*)": 2}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_1 WHERE (int_field1 IN ( 9 , 29 , 37 , 44 , 50 )) AND ((bool_field1 != true AND NOT (decimal_field1 > 4849))) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_10 WHERE (bool_field1 AND decimal_field1 IN [ 3 , 8 , 13 , 27 , 54 ]) ", "expected_result": [{"COUNT(*)": 2}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_10 WHERE (bool_field1 AND decimal_field1 IN ( 3 , 8 , 13 , 27 , 54 )) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_10 WHERE (decimal_field1 != 5082) OR (decimal_field1 IN [ 3 , 8 , 13 , 27 , 54 ]) ", "expected_result": [{"COUNT(*)": 999}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_10 WHERE (decimal_field1 != 5082) OR (decimal_field1 IN ( 3 , 8 , 13 , 27 , 54 )) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((((NOT ((decimal_field1 = 4849) AND (decimal_field1 <= 4849))) OR (int_field1 = 4760)) AND ((decimal_field1 IS NULL) OR (decimal_field1 != 4849))) AND (NOT ((decimal_field1 IS NULL) AND (decimal_field1 <= 4849)))) OR ((decimal_field1 = 4849) AND (decimal_field1 > 4849)) ", "expected_result": [{"SUM( int_field1 )": 4770547}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((((NOT ((decimal_field1 = 4849) AND (decimal_field1 <= 4849))) OR (int_field1 = 4760)) AND ((decimal_field1 IS NULL) OR (decimal_field1 != 4849))) AND (NOT ((decimal_field1 IS NULL) AND (decimal_field1 <= 4849)))) OR ((decimal_field1 = 4849) AND (decimal_field1 > 4849)) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE NOT ((int_field1 IN [ 9 , 29 , 37 , 44 , 50 ] OR char_field1 != \"N\")) ", "expected_result": [{"SUM( int_field1 )": 132767}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE NOT ((int_field1 IN ( 9 , 29 , 37 , 44 , 50 ) OR char_field1 != \"N\")) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_1 WHERE (NOT (bool_field1)) OR (bool_field1) ", "expected_result": [{"COUNT(*)": 1000}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_1 WHERE (NOT (bool_field1)) OR (bool_field1) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_1 WHERE ((bool_field1 AND int_field1 BETWEEN 9 and 9992)) AND (decimal_field1 IN [ 5 , 9 , 13 , 15 , 48 ]) ", "expected_result": [{"COUNT(*)": 1}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_1 WHERE ((bool_field1 AND int_field1 BETWEEN 9 and 9992)) AND (decimal_field1 IN ( 5 , 9 , 13 , 15 , 48 )) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 OR char_field1 IN [ \"A\" , \"B\" , \"C\" , \"D\" , \"E\" ])) AND ((bool_field1 AND int_field1 IN [ 9 , 29 , 37 , 44 , 50 ])) ", "expected_result": [{"SUM( int_field1 )": 66}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 OR char_field1 IN ( \"A\" , \"B\" , \"C\" , \"D\" , \"E\" ))) AND ((bool_field1 AND int_field1 IN ( 9 , 29 , 37 , 44 , 50 ))) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_10 WHERE (bool_field1 AND decimal_field1 IN [ 3 , 8 , 13 , 27 , 54 ]) ", "expected_result": [{"COUNT(*)": 2}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_10 WHERE (bool_field1 AND decimal_field1 IN ( 3 , 8 , 13 , 27 , 54 )) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_1 WHERE (bool_field1 AND decimal_field1 IN [ 5 , 9 , 13 , 15 , 48 ]) ", "expected_result": [{"COUNT(*)": 1}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_1 WHERE (bool_field1 AND decimal_field1 IN ( 5 , 9 , 13 , 15 , 48 )) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_10 WHERE (int_field1 BETWEEN 3 and 9979 AND varchar_field1 IN [ \"ADdiftNWjX\" , \"AMHCjniudX\" , \"APMThwexAu\" , \"ARyeblEWAc\" , \"AVVmxLwfLr\" ] AND bool_field1) ", "expected_result": [{"COUNT(*)": 4}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_10 WHERE (int_field1 BETWEEN 3 and 9979 AND varchar_field1 IN ( \"ADdiftNWjX\" , \"AMHCjniudX\" , \"APMThwexAu\" , \"ARyeblEWAc\" , \"AVVmxLwfLr\" ) AND bool_field1) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_10 WHERE (bool_field1) AND (varchar_field1 IN [ \"ADdiftNWjX\" , \"AMHCjniudX\" , \"APMThwexAu\" , \"ARyeblEWAc\" , \"AVVmxLwfLr\" ]) ", "expected_result": [{"COUNT(*)": 4}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_10 WHERE (bool_field1) AND (varchar_field1 IN ( \"ADdiftNWjX\" , \"AMHCjniudX\" , \"APMThwexAu\" , \"ARyeblEWAc\" , \"AVVmxLwfLr\" )) "} {"n1ql": "SELECT SUM(DISTINCT decimal_field1 ) FROM simple_table_1 WHERE NOT ((NOT (bool_field1) AND int_field1 < 4760)) GROUP BY int_field1 , decimal_field1 ", "expected_result": [{"SUM(DISTINCT decimal_field1 )": 8608}, {"SUM(DISTINCT decimal_field1 )": 5615}, {"SUM(DISTINCT decimal_field1 )": 609}, {"SUM(DISTINCT decimal_field1 )": 8007}, {"SUM(DISTINCT decimal_field1 )": 1114}, {"SUM(DISTINCT decimal_field1 )": 7759}, {"SUM(DISTINCT decimal_field1 )": 3831}, {"SUM(DISTINCT decimal_field1 )": 6474}, {"SUM(DISTINCT decimal_field1 )": 1426}, {"SUM(DISTINCT decimal_field1 )": 3233}, {"SUM(DISTINCT decimal_field1 )": 1059}, {"SUM(DISTINCT decimal_field1 )": 1969}, {"SUM(DISTINCT decimal_field1 )": 1116}, {"SUM(DISTINCT decimal_field1 )": 3749}, {"SUM(DISTINCT decimal_field1 )": 7669}, {"SUM(DISTINCT decimal_field1 )": 9260}, {"SUM(DISTINCT decimal_field1 )": 1504}, {"SUM(DISTINCT decimal_field1 )": 9666}, {"SUM(DISTINCT decimal_field1 )": 9442}, {"SUM(DISTINCT decimal_field1 )": 1237}, {"SUM(DISTINCT decimal_field1 )": 1737}, {"SUM(DISTINCT decimal_field1 )": 1155}, {"SUM(DISTINCT decimal_field1 )": 7411}, {"SUM(DISTINCT decimal_field1 )": 1658}, {"SUM(DISTINCT decimal_field1 )": 9415}, {"SUM(DISTINCT decimal_field1 )": 590}, {"SUM(DISTINCT decimal_field1 )": 4801}, {"SUM(DISTINCT decimal_field1 )": 6678}, {"SUM(DISTINCT decimal_field1 )": 3028}, {"SUM(DISTINCT decimal_field1 )": 1166}, {"SUM(DISTINCT decimal_field1 )": 7037}, {"SUM(DISTINCT decimal_field1 )": 2398}, {"SUM(DISTINCT decimal_field1 )": 864}, {"SUM(DISTINCT decimal_field1 )": 4401}, {"SUM(DISTINCT decimal_field1 )": 8369}, {"SUM(DISTINCT decimal_field1 )": 5327}, {"SUM(DISTINCT decimal_field1 )": 2504}, {"SUM(DISTINCT decimal_field1 )": 2808}, {"SUM(DISTINCT decimal_field1 )": 8031}, {"SUM(DISTINCT decimal_field1 )": 9847}, {"SUM(DISTINCT decimal_field1 )": 7407}, {"SUM(DISTINCT decimal_field1 )": 1331}, {"SUM(DISTINCT decimal_field1 )": 1162}, {"SUM(DISTINCT decimal_field1 )": 794}, {"SUM(DISTINCT decimal_field1 )": 3778}, {"SUM(DISTINCT decimal_field1 )": 2747}, {"SUM(DISTINCT decimal_field1 )": 6814}, {"SUM(DISTINCT decimal_field1 )": 3097}, {"SUM(DISTINCT decimal_field1 )": 411}, {"SUM(DISTINCT decimal_field1 )": 2414}, {"SUM(DISTINCT decimal_field1 )": 2465}, {"SUM(DISTINCT decimal_field1 )": 8175}, {"SUM(DISTINCT decimal_field1 )": 4081}, {"SUM(DISTINCT decimal_field1 )": 3536}, {"SUM(DISTINCT decimal_field1 )": 5758}, {"SUM(DISTINCT decimal_field1 )": 5085}, {"SUM(DISTINCT decimal_field1 )": 7005}, {"SUM(DISTINCT decimal_field1 )": 896}, {"SUM(DISTINCT decimal_field1 )": 8893}, {"SUM(DISTINCT decimal_field1 )": 4814}, {"SUM(DISTINCT decimal_field1 )": 168}, {"SUM(DISTINCT decimal_field1 )": 5638}, {"SUM(DISTINCT decimal_field1 )": 4632}, {"SUM(DISTINCT decimal_field1 )": 1163}, {"SUM(DISTINCT decimal_field1 )": 3981}, {"SUM(DISTINCT decimal_field1 )": 6019}, {"SUM(DISTINCT decimal_field1 )": 5045}, {"SUM(DISTINCT decimal_field1 )": 5602}, {"SUM(DISTINCT decimal_field1 )": 1926}, {"SUM(DISTINCT decimal_field1 )": 1794}, {"SUM(DISTINCT decimal_field1 )": 8943}, {"SUM(DISTINCT decimal_field1 )": 6157}, {"SUM(DISTINCT decimal_field1 )": 741}, {"SUM(DISTINCT decimal_field1 )": 6901}, {"SUM(DISTINCT decimal_field1 )": 2909}, {"SUM(DISTINCT decimal_field1 )": 4212}, {"SUM(DISTINCT decimal_field1 )": 4178}, {"SUM(DISTINCT decimal_field1 )": 5181}, {"SUM(DISTINCT decimal_field1 )": 5314}, {"SUM(DISTINCT decimal_field1 )": 9812}, {"SUM(DISTINCT decimal_field1 )": 5668}, {"SUM(DISTINCT decimal_field1 )": 3100}, {"SUM(DISTINCT decimal_field1 )": 654}, {"SUM(DISTINCT decimal_field1 )": 6446}, {"SUM(DISTINCT decimal_field1 )": 973}, {"SUM(DISTINCT decimal_field1 )": 7446}, {"SUM(DISTINCT decimal_field1 )": 9730}, {"SUM(DISTINCT decimal_field1 )": 2431}, {"SUM(DISTINCT decimal_field1 )": 9890}, {"SUM(DISTINCT decimal_field1 )": 2450}, {"SUM(DISTINCT decimal_field1 )": 4068}, {"SUM(DISTINCT decimal_field1 )": 3138}, {"SUM(DISTINCT decimal_field1 )": 2239}, {"SUM(DISTINCT decimal_field1 )": 6039}, {"SUM(DISTINCT decimal_field1 )": 5885}, {"SUM(DISTINCT decimal_field1 )": 4120}, {"SUM(DISTINCT decimal_field1 )": 2239}, {"SUM(DISTINCT decimal_field1 )": 8353}, {"SUM(DISTINCT decimal_field1 )": 3359}, {"SUM(DISTINCT decimal_field1 )": 4500}, {"SUM(DISTINCT decimal_field1 )": 2667}, {"SUM(DISTINCT decimal_field1 )": 9902}, {"SUM(DISTINCT decimal_field1 )": 1927}, {"SUM(DISTINCT decimal_field1 )": 3066}, {"SUM(DISTINCT decimal_field1 )": 7274}, {"SUM(DISTINCT decimal_field1 )": 7301}, {"SUM(DISTINCT decimal_field1 )": 9388}, {"SUM(DISTINCT decimal_field1 )": 8826}, {"SUM(DISTINCT decimal_field1 )": 3569}, {"SUM(DISTINCT decimal_field1 )": 2302}, {"SUM(DISTINCT decimal_field1 )": 8648}, {"SUM(DISTINCT decimal_field1 )": 8654}, {"SUM(DISTINCT decimal_field1 )": 9565}, {"SUM(DISTINCT decimal_field1 )": 5643}, {"SUM(DISTINCT decimal_field1 )": 7701}, {"SUM(DISTINCT decimal_field1 )": 4614}, {"SUM(DISTINCT decimal_field1 )": 5574}, {"SUM(DISTINCT decimal_field1 )": 8932}, {"SUM(DISTINCT decimal_field1 )": 9748}, {"SUM(DISTINCT decimal_field1 )": 1912}, {"SUM(DISTINCT decimal_field1 )": 6151}, {"SUM(DISTINCT decimal_field1 )": 1502}, {"SUM(DISTINCT decimal_field1 )": 6457}, {"SUM(DISTINCT decimal_field1 )": 3966}, {"SUM(DISTINCT decimal_field1 )": 1841}, {"SUM(DISTINCT decimal_field1 )": 9351}, {"SUM(DISTINCT decimal_field1 )": 2637}, {"SUM(DISTINCT decimal_field1 )": 8286}, {"SUM(DISTINCT decimal_field1 )": 2835}, {"SUM(DISTINCT decimal_field1 )": 3401}, {"SUM(DISTINCT decimal_field1 )": 7558}, {"SUM(DISTINCT decimal_field1 )": 3682}, {"SUM(DISTINCT decimal_field1 )": 5797}, {"SUM(DISTINCT decimal_field1 )": 3843}, {"SUM(DISTINCT decimal_field1 )": 9771}, {"SUM(DISTINCT decimal_field1 )": 1673}, {"SUM(DISTINCT decimal_field1 )": 6266}, {"SUM(DISTINCT decimal_field1 )": 9406}, {"SUM(DISTINCT decimal_field1 )": 3562}, {"SUM(DISTINCT decimal_field1 )": 4100}, {"SUM(DISTINCT decimal_field1 )": 8440}, {"SUM(DISTINCT decimal_field1 )": 5401}, {"SUM(DISTINCT decimal_field1 )": 5632}, {"SUM(DISTINCT decimal_field1 )": 2759}, {"SUM(DISTINCT decimal_field1 )": 5598}, {"SUM(DISTINCT decimal_field1 )": 7948}, {"SUM(DISTINCT decimal_field1 )": 8733}, {"SUM(DISTINCT decimal_field1 )": 8792}, {"SUM(DISTINCT decimal_field1 )": 5885}, {"SUM(DISTINCT decimal_field1 )": 8966}, {"SUM(DISTINCT decimal_field1 )": 1917}, {"SUM(DISTINCT decimal_field1 )": 6067}, {"SUM(DISTINCT decimal_field1 )": 6220}, {"SUM(DISTINCT decimal_field1 )": 2065}, {"SUM(DISTINCT decimal_field1 )": 7620}, {"SUM(DISTINCT decimal_field1 )": 9113}, {"SUM(DISTINCT decimal_field1 )": 2892}, {"SUM(DISTINCT decimal_field1 )": 3201}, {"SUM(DISTINCT decimal_field1 )": 5284}, {"SUM(DISTINCT decimal_field1 )": 473}, {"SUM(DISTINCT decimal_field1 )": 9932}, {"SUM(DISTINCT decimal_field1 )": 8037}, {"SUM(DISTINCT decimal_field1 )": 147}, {"SUM(DISTINCT decimal_field1 )": 6819}, {"SUM(DISTINCT decimal_field1 )": 4195}, {"SUM(DISTINCT decimal_field1 )": 2901}, {"SUM(DISTINCT decimal_field1 )": 3303}, {"SUM(DISTINCT decimal_field1 )": 7884}, {"SUM(DISTINCT decimal_field1 )": 7784}, {"SUM(DISTINCT decimal_field1 )": 3808}, {"SUM(DISTINCT decimal_field1 )": 5591}, {"SUM(DISTINCT decimal_field1 )": 3179}, {"SUM(DISTINCT decimal_field1 )": 3039}, {"SUM(DISTINCT decimal_field1 )": 8791}, {"SUM(DISTINCT decimal_field1 )": 8622}, {"SUM(DISTINCT decimal_field1 )": 8421}, {"SUM(DISTINCT decimal_field1 )": 2012}, {"SUM(DISTINCT decimal_field1 )": 3546}, {"SUM(DISTINCT decimal_field1 )": 3426}, {"SUM(DISTINCT decimal_field1 )": 9021}, {"SUM(DISTINCT decimal_field1 )": 796}, {"SUM(DISTINCT decimal_field1 )": 6147}, {"SUM(DISTINCT decimal_field1 )": 8789}, {"SUM(DISTINCT decimal_field1 )": 751}, {"SUM(DISTINCT decimal_field1 )": 7276}, {"SUM(DISTINCT decimal_field1 )": 9322}, {"SUM(DISTINCT decimal_field1 )": 7774}, {"SUM(DISTINCT decimal_field1 )": 2383}, {"SUM(DISTINCT decimal_field1 )": 6420}, {"SUM(DISTINCT decimal_field1 )": 496}, {"SUM(DISTINCT decimal_field1 )": 8812}, {"SUM(DISTINCT decimal_field1 )": 5319}, {"SUM(DISTINCT decimal_field1 )": 2354}, {"SUM(DISTINCT decimal_field1 )": 6894}, {"SUM(DISTINCT decimal_field1 )": 3268}, {"SUM(DISTINCT decimal_field1 )": 328}, {"SUM(DISTINCT decimal_field1 )": 4628}, {"SUM(DISTINCT decimal_field1 )": 9835}, {"SUM(DISTINCT decimal_field1 )": 9856}, {"SUM(DISTINCT decimal_field1 )": 8570}, {"SUM(DISTINCT decimal_field1 )": 8845}, {"SUM(DISTINCT decimal_field1 )": 1499}, {"SUM(DISTINCT decimal_field1 )": 8246}, {"SUM(DISTINCT decimal_field1 )": 3070}, {"SUM(DISTINCT decimal_field1 )": 9293}, {"SUM(DISTINCT decimal_field1 )": 3169}, {"SUM(DISTINCT decimal_field1 )": 3763}, {"SUM(DISTINCT decimal_field1 )": 3319}, {"SUM(DISTINCT decimal_field1 )": 9414}, {"SUM(DISTINCT decimal_field1 )": 7749}, {"SUM(DISTINCT decimal_field1 )": 9778}, {"SUM(DISTINCT decimal_field1 )": 808}, {"SUM(DISTINCT decimal_field1 )": 5263}, {"SUM(DISTINCT decimal_field1 )": 5873}, {"SUM(DISTINCT decimal_field1 )": 4534}, {"SUM(DISTINCT decimal_field1 )": 8289}, {"SUM(DISTINCT decimal_field1 )": 4134}, {"SUM(DISTINCT decimal_field1 )": 4586}, {"SUM(DISTINCT decimal_field1 )": 6501}, {"SUM(DISTINCT decimal_field1 )": 4370}, {"SUM(DISTINCT decimal_field1 )": 3816}, {"SUM(DISTINCT decimal_field1 )": 6866}, {"SUM(DISTINCT decimal_field1 )": 8955}, {"SUM(DISTINCT decimal_field1 )": 5684}, {"SUM(DISTINCT decimal_field1 )": 2670}, {"SUM(DISTINCT decimal_field1 )": 6490}, {"SUM(DISTINCT decimal_field1 )": 1779}, {"SUM(DISTINCT decimal_field1 )": 5050}, {"SUM(DISTINCT decimal_field1 )": 5065}, {"SUM(DISTINCT decimal_field1 )": 2548}, {"SUM(DISTINCT decimal_field1 )": 5197}, {"SUM(DISTINCT decimal_field1 )": 8314}, {"SUM(DISTINCT decimal_field1 )": 948}, {"SUM(DISTINCT decimal_field1 )": 6052}, {"SUM(DISTINCT decimal_field1 )": 3223}, {"SUM(DISTINCT decimal_field1 )": 8383}, {"SUM(DISTINCT decimal_field1 )": 8247}, {"SUM(DISTINCT decimal_field1 )": 4007}, {"SUM(DISTINCT decimal_field1 )": 2046}, {"SUM(DISTINCT decimal_field1 )": 4688}, {"SUM(DISTINCT decimal_field1 )": 7379}, {"SUM(DISTINCT decimal_field1 )": 9013}, {"SUM(DISTINCT decimal_field1 )": 9272}, {"SUM(DISTINCT decimal_field1 )": 5728}, {"SUM(DISTINCT decimal_field1 )": 4238}, {"SUM(DISTINCT decimal_field1 )": 3587}, {"SUM(DISTINCT decimal_field1 )": 2121}, {"SUM(DISTINCT decimal_field1 )": 2286}, {"SUM(DISTINCT decimal_field1 )": 5572}, {"SUM(DISTINCT decimal_field1 )": 1526}, {"SUM(DISTINCT decimal_field1 )": 6674}, {"SUM(DISTINCT decimal_field1 )": 7583}, {"SUM(DISTINCT decimal_field1 )": 3696}, {"SUM(DISTINCT decimal_field1 )": 8539}, {"SUM(DISTINCT decimal_field1 )": 1483}, {"SUM(DISTINCT decimal_field1 )": 7464}, {"SUM(DISTINCT decimal_field1 )": 9386}, {"SUM(DISTINCT decimal_field1 )": 9244}, {"SUM(DISTINCT decimal_field1 )": 8615}, {"SUM(DISTINCT decimal_field1 )": 4098}, {"SUM(DISTINCT decimal_field1 )": 403}, {"SUM(DISTINCT decimal_field1 )": 5403}, {"SUM(DISTINCT decimal_field1 )": 9457}, {"SUM(DISTINCT decimal_field1 )": 5281}, {"SUM(DISTINCT decimal_field1 )": 5122}, {"SUM(DISTINCT decimal_field1 )": 5080}, {"SUM(DISTINCT decimal_field1 )": 2628}, {"SUM(DISTINCT decimal_field1 )": 2796}, {"SUM(DISTINCT decimal_field1 )": 889}, {"SUM(DISTINCT decimal_field1 )": 1729}, {"SUM(DISTINCT decimal_field1 )": 3293}, {"SUM(DISTINCT decimal_field1 )": 2333}, {"SUM(DISTINCT decimal_field1 )": 4642}, {"SUM(DISTINCT decimal_field1 )": 510}, {"SUM(DISTINCT decimal_field1 )": 9333}, {"SUM(DISTINCT decimal_field1 )": 2547}, {"SUM(DISTINCT decimal_field1 )": 3468}, {"SUM(DISTINCT decimal_field1 )": 4659}, {"SUM(DISTINCT decimal_field1 )": 2819}, {"SUM(DISTINCT decimal_field1 )": 7728}, {"SUM(DISTINCT decimal_field1 )": 1934}, {"SUM(DISTINCT decimal_field1 )": 4820}, {"SUM(DISTINCT decimal_field1 )": 1071}, {"SUM(DISTINCT decimal_field1 )": 4183}, {"SUM(DISTINCT decimal_field1 )": 6106}, {"SUM(DISTINCT decimal_field1 )": 3036}, {"SUM(DISTINCT decimal_field1 )": 3298}, {"SUM(DISTINCT decimal_field1 )": 9213}, {"SUM(DISTINCT decimal_field1 )": 1681}, {"SUM(DISTINCT decimal_field1 )": 6156}, {"SUM(DISTINCT decimal_field1 )": 1939}, {"SUM(DISTINCT decimal_field1 )": 1385}, {"SUM(DISTINCT decimal_field1 )": 7969}, {"SUM(DISTINCT decimal_field1 )": 9898}, {"SUM(DISTINCT decimal_field1 )": 8551}, {"SUM(DISTINCT decimal_field1 )": 8554}, {"SUM(DISTINCT decimal_field1 )": 7815}, {"SUM(DISTINCT decimal_field1 )": 2785}, {"SUM(DISTINCT decimal_field1 )": 456}, {"SUM(DISTINCT decimal_field1 )": 6144}, {"SUM(DISTINCT decimal_field1 )": 747}, {"SUM(DISTINCT decimal_field1 )": 3265}, {"SUM(DISTINCT decimal_field1 )": 7811}, {"SUM(DISTINCT decimal_field1 )": 9493}, {"SUM(DISTINCT decimal_field1 )": 2029}, {"SUM(DISTINCT decimal_field1 )": 9888}, {"SUM(DISTINCT decimal_field1 )": 4657}, {"SUM(DISTINCT decimal_field1 )": 9483}, {"SUM(DISTINCT decimal_field1 )": 255}, {"SUM(DISTINCT decimal_field1 )": 1257}, {"SUM(DISTINCT decimal_field1 )": 7140}, {"SUM(DISTINCT decimal_field1 )": 7102}, {"SUM(DISTINCT decimal_field1 )": 5880}, {"SUM(DISTINCT decimal_field1 )": 8412}, {"SUM(DISTINCT decimal_field1 )": 5844}, {"SUM(DISTINCT decimal_field1 )": 8984}, {"SUM(DISTINCT decimal_field1 )": 9625}, {"SUM(DISTINCT decimal_field1 )": 4580}, {"SUM(DISTINCT decimal_field1 )": 6675}, {"SUM(DISTINCT decimal_field1 )": 1010}, {"SUM(DISTINCT decimal_field1 )": 2450}, {"SUM(DISTINCT decimal_field1 )": 4666}, {"SUM(DISTINCT decimal_field1 )": 4631}, {"SUM(DISTINCT decimal_field1 )": 7603}, {"SUM(DISTINCT decimal_field1 )": 4811}, {"SUM(DISTINCT decimal_field1 )": 9230}, {"SUM(DISTINCT decimal_field1 )": 8899}, {"SUM(DISTINCT decimal_field1 )": 7803}, {"SUM(DISTINCT decimal_field1 )": 7323}, {"SUM(DISTINCT decimal_field1 )": 9278}, {"SUM(DISTINCT decimal_field1 )": 3928}, {"SUM(DISTINCT decimal_field1 )": 6428}, {"SUM(DISTINCT decimal_field1 )": 6644}, {"SUM(DISTINCT decimal_field1 )": 8908}, {"SUM(DISTINCT decimal_field1 )": 3698}, {"SUM(DISTINCT decimal_field1 )": 2115}, {"SUM(DISTINCT decimal_field1 )": 3744}, {"SUM(DISTINCT decimal_field1 )": 7693}, {"SUM(DISTINCT decimal_field1 )": 1438}, {"SUM(DISTINCT decimal_field1 )": 946}, {"SUM(DISTINCT decimal_field1 )": 7447}, {"SUM(DISTINCT decimal_field1 )": 9911}, {"SUM(DISTINCT decimal_field1 )": 2689}, {"SUM(DISTINCT decimal_field1 )": 3309}, {"SUM(DISTINCT decimal_field1 )": 5157}, {"SUM(DISTINCT decimal_field1 )": 15}, {"SUM(DISTINCT decimal_field1 )": 7608}, {"SUM(DISTINCT decimal_field1 )": 5580}, {"SUM(DISTINCT decimal_field1 )": 9904}, {"SUM(DISTINCT decimal_field1 )": 6955}, {"SUM(DISTINCT decimal_field1 )": 3700}, {"SUM(DISTINCT decimal_field1 )": 4358}, {"SUM(DISTINCT decimal_field1 )": 6542}, {"SUM(DISTINCT decimal_field1 )": 345}, {"SUM(DISTINCT decimal_field1 )": 6399}, {"SUM(DISTINCT decimal_field1 )": 1863}, {"SUM(DISTINCT decimal_field1 )": 7191}, {"SUM(DISTINCT decimal_field1 )": 8064}, {"SUM(DISTINCT decimal_field1 )": 134}, {"SUM(DISTINCT decimal_field1 )": 323}, {"SUM(DISTINCT decimal_field1 )": 8498}, {"SUM(DISTINCT decimal_field1 )": 6853}, {"SUM(DISTINCT decimal_field1 )": 3148}, {"SUM(DISTINCT decimal_field1 )": 8570}, {"SUM(DISTINCT decimal_field1 )": 1346}, {"SUM(DISTINCT decimal_field1 )": 9128}, {"SUM(DISTINCT decimal_field1 )": 7734}, {"SUM(DISTINCT decimal_field1 )": 2370}, {"SUM(DISTINCT decimal_field1 )": 624}, {"SUM(DISTINCT decimal_field1 )": 2024}, {"SUM(DISTINCT decimal_field1 )": 6985}, {"SUM(DISTINCT decimal_field1 )": 1336}, {"SUM(DISTINCT decimal_field1 )": 5788}, {"SUM(DISTINCT decimal_field1 )": 4348}, {"SUM(DISTINCT decimal_field1 )": 2297}, {"SUM(DISTINCT decimal_field1 )": 101}, {"SUM(DISTINCT decimal_field1 )": 2094}, {"SUM(DISTINCT decimal_field1 )": 148}, {"SUM(DISTINCT decimal_field1 )": 3852}, {"SUM(DISTINCT decimal_field1 )": 1660}, {"SUM(DISTINCT decimal_field1 )": 5816}, {"SUM(DISTINCT decimal_field1 )": 3709}, {"SUM(DISTINCT decimal_field1 )": 5528}, {"SUM(DISTINCT decimal_field1 )": 4798}, {"SUM(DISTINCT decimal_field1 )": 9311}, {"SUM(DISTINCT decimal_field1 )": 2591}, {"SUM(DISTINCT decimal_field1 )": 2324}, {"SUM(DISTINCT decimal_field1 )": 4999}, {"SUM(DISTINCT decimal_field1 )": 7161}, {"SUM(DISTINCT decimal_field1 )": 6313}, {"SUM(DISTINCT decimal_field1 )": 1360}, {"SUM(DISTINCT decimal_field1 )": 7273}, {"SUM(DISTINCT decimal_field1 )": 5608}, {"SUM(DISTINCT decimal_field1 )": 5794}, {"SUM(DISTINCT decimal_field1 )": 4949}, {"SUM(DISTINCT decimal_field1 )": 8502}, {"SUM(DISTINCT decimal_field1 )": 471}, {"SUM(DISTINCT decimal_field1 )": 3967}, {"SUM(DISTINCT decimal_field1 )": 3169}, {"SUM(DISTINCT decimal_field1 )": 8551}, {"SUM(DISTINCT decimal_field1 )": 5475}, {"SUM(DISTINCT decimal_field1 )": 6658}, {"SUM(DISTINCT decimal_field1 )": 8841}, {"SUM(DISTINCT decimal_field1 )": 8345}, {"SUM(DISTINCT decimal_field1 )": 9633}, {"SUM(DISTINCT decimal_field1 )": 5121}, {"SUM(DISTINCT decimal_field1 )": 542}, {"SUM(DISTINCT decimal_field1 )": 6371}, {"SUM(DISTINCT decimal_field1 )": 6786}, {"SUM(DISTINCT decimal_field1 )": 4668}, {"SUM(DISTINCT decimal_field1 )": 5274}, {"SUM(DISTINCT decimal_field1 )": 9639}, {"SUM(DISTINCT decimal_field1 )": 6000}, {"SUM(DISTINCT decimal_field1 )": 955}, {"SUM(DISTINCT decimal_field1 )": 3721}, {"SUM(DISTINCT decimal_field1 )": 7060}, {"SUM(DISTINCT decimal_field1 )": 5083}, {"SUM(DISTINCT decimal_field1 )": 9299}, {"SUM(DISTINCT decimal_field1 )": 8358}, {"SUM(DISTINCT decimal_field1 )": 4443}, {"SUM(DISTINCT decimal_field1 )": 981}, {"SUM(DISTINCT decimal_field1 )": 95}, {"SUM(DISTINCT decimal_field1 )": 3967}, {"SUM(DISTINCT decimal_field1 )": 2863}, {"SUM(DISTINCT decimal_field1 )": 8653}, {"SUM(DISTINCT decimal_field1 )": 2037}, {"SUM(DISTINCT decimal_field1 )": 4201}, {"SUM(DISTINCT decimal_field1 )": 2663}, {"SUM(DISTINCT decimal_field1 )": 4303}, {"SUM(DISTINCT decimal_field1 )": 7529}, {"SUM(DISTINCT decimal_field1 )": 6905}, {"SUM(DISTINCT decimal_field1 )": 1934}, {"SUM(DISTINCT decimal_field1 )": 7857}, {"SUM(DISTINCT decimal_field1 )": 3006}, {"SUM(DISTINCT decimal_field1 )": 7524}, {"SUM(DISTINCT decimal_field1 )": 1971}, {"SUM(DISTINCT decimal_field1 )": 9896}, {"SUM(DISTINCT decimal_field1 )": 6861}, {"SUM(DISTINCT decimal_field1 )": 2401}, {"SUM(DISTINCT decimal_field1 )": 8683}, {"SUM(DISTINCT decimal_field1 )": 6191}, {"SUM(DISTINCT decimal_field1 )": 6940}, {"SUM(DISTINCT decimal_field1 )": 221}, {"SUM(DISTINCT decimal_field1 )": 9233}, {"SUM(DISTINCT decimal_field1 )": 3685}, {"SUM(DISTINCT decimal_field1 )": 9618}, {"SUM(DISTINCT decimal_field1 )": 786}, {"SUM(DISTINCT decimal_field1 )": 212}, {"SUM(DISTINCT decimal_field1 )": 8379}, {"SUM(DISTINCT decimal_field1 )": 5966}, {"SUM(DISTINCT decimal_field1 )": 7566}, {"SUM(DISTINCT decimal_field1 )": 4127}, {"SUM(DISTINCT decimal_field1 )": 2891}, {"SUM(DISTINCT decimal_field1 )": 2048}, {"SUM(DISTINCT decimal_field1 )": 4992}, {"SUM(DISTINCT decimal_field1 )": 7358}, {"SUM(DISTINCT decimal_field1 )": 9930}, {"SUM(DISTINCT decimal_field1 )": 5999}, {"SUM(DISTINCT decimal_field1 )": 274}, {"SUM(DISTINCT decimal_field1 )": 7953}, {"SUM(DISTINCT decimal_field1 )": 525}, {"SUM(DISTINCT decimal_field1 )": 1749}, {"SUM(DISTINCT decimal_field1 )": 672}, {"SUM(DISTINCT decimal_field1 )": 5005}, {"SUM(DISTINCT decimal_field1 )": 4411}, {"SUM(DISTINCT decimal_field1 )": 1232}, {"SUM(DISTINCT decimal_field1 )": 9948}, {"SUM(DISTINCT decimal_field1 )": 6838}, {"SUM(DISTINCT decimal_field1 )": 4916}, {"SUM(DISTINCT decimal_field1 )": 1346}, {"SUM(DISTINCT decimal_field1 )": 746}, {"SUM(DISTINCT decimal_field1 )": 3830}, {"SUM(DISTINCT decimal_field1 )": 1639}, {"SUM(DISTINCT decimal_field1 )": 6245}, {"SUM(DISTINCT decimal_field1 )": 5315}, {"SUM(DISTINCT decimal_field1 )": 5183}, {"SUM(DISTINCT decimal_field1 )": 7197}, {"SUM(DISTINCT decimal_field1 )": 8455}, {"SUM(DISTINCT decimal_field1 )": 7884}, {"SUM(DISTINCT decimal_field1 )": 8797}, {"SUM(DISTINCT decimal_field1 )": 636}, {"SUM(DISTINCT decimal_field1 )": 6017}, {"SUM(DISTINCT decimal_field1 )": 5995}, {"SUM(DISTINCT decimal_field1 )": 8308}, {"SUM(DISTINCT decimal_field1 )": 8090}, {"SUM(DISTINCT decimal_field1 )": 2156}, {"SUM(DISTINCT decimal_field1 )": 2255}, {"SUM(DISTINCT decimal_field1 )": 6473}, {"SUM(DISTINCT decimal_field1 )": 3292}, {"SUM(DISTINCT decimal_field1 )": 426}, {"SUM(DISTINCT decimal_field1 )": 2489}, {"SUM(DISTINCT decimal_field1 )": 9536}, {"SUM(DISTINCT decimal_field1 )": 5741}, {"SUM(DISTINCT decimal_field1 )": 6361}, {"SUM(DISTINCT decimal_field1 )": 9036}, {"SUM(DISTINCT decimal_field1 )": 2419}, {"SUM(DISTINCT decimal_field1 )": 1543}, {"SUM(DISTINCT decimal_field1 )": 5847}, {"SUM(DISTINCT decimal_field1 )": 1850}, {"SUM(DISTINCT decimal_field1 )": 3002}, {"SUM(DISTINCT decimal_field1 )": 6582}, {"SUM(DISTINCT decimal_field1 )": 3510}, {"SUM(DISTINCT decimal_field1 )": 5356}, {"SUM(DISTINCT decimal_field1 )": 7693}, {"SUM(DISTINCT decimal_field1 )": 8436}, {"SUM(DISTINCT decimal_field1 )": 5674}, {"SUM(DISTINCT decimal_field1 )": 1481}, {"SUM(DISTINCT decimal_field1 )": 230}, {"SUM(DISTINCT decimal_field1 )": 1946}, {"SUM(DISTINCT decimal_field1 )": 6388}, {"SUM(DISTINCT decimal_field1 )": 8468}, {"SUM(DISTINCT decimal_field1 )": 1265}, {"SUM(DISTINCT decimal_field1 )": 1945}, {"SUM(DISTINCT decimal_field1 )": 5978}, {"SUM(DISTINCT decimal_field1 )": 6420}, {"SUM(DISTINCT decimal_field1 )": 840}, {"SUM(DISTINCT decimal_field1 )": 7940}, {"SUM(DISTINCT decimal_field1 )": 7915}, {"SUM(DISTINCT decimal_field1 )": 6515}, {"SUM(DISTINCT decimal_field1 )": 3924}, {"SUM(DISTINCT decimal_field1 )": 1310}, {"SUM(DISTINCT decimal_field1 )": 1364}, {"SUM(DISTINCT decimal_field1 )": 7265}, {"SUM(DISTINCT decimal_field1 )": 5370}, {"SUM(DISTINCT decimal_field1 )": 3516}, {"SUM(DISTINCT decimal_field1 )": 5839}, {"SUM(DISTINCT decimal_field1 )": 9289}, {"SUM(DISTINCT decimal_field1 )": 1845}, {"SUM(DISTINCT decimal_field1 )": 765}, {"SUM(DISTINCT decimal_field1 )": 5330}, {"SUM(DISTINCT decimal_field1 )": 2909}, {"SUM(DISTINCT decimal_field1 )": 4238}, {"SUM(DISTINCT decimal_field1 )": 5}, {"SUM(DISTINCT decimal_field1 )": 7108}, {"SUM(DISTINCT decimal_field1 )": 1871}, {"SUM(DISTINCT decimal_field1 )": 868}, {"SUM(DISTINCT decimal_field1 )": 7763}, {"SUM(DISTINCT decimal_field1 )": 904}, {"SUM(DISTINCT decimal_field1 )": 3161}, {"SUM(DISTINCT decimal_field1 )": 344}, {"SUM(DISTINCT decimal_field1 )": 8427}, {"SUM(DISTINCT decimal_field1 )": 1359}, {"SUM(DISTINCT decimal_field1 )": 5172}, {"SUM(DISTINCT decimal_field1 )": 8016}, {"SUM(DISTINCT decimal_field1 )": 5228}, {"SUM(DISTINCT decimal_field1 )": 7114}, {"SUM(DISTINCT decimal_field1 )": 3035}, {"SUM(DISTINCT decimal_field1 )": 6003}, {"SUM(DISTINCT decimal_field1 )": 4065}, {"SUM(DISTINCT decimal_field1 )": 7044}, {"SUM(DISTINCT decimal_field1 )": 952}, {"SUM(DISTINCT decimal_field1 )": 7655}, {"SUM(DISTINCT decimal_field1 )": 9590}, {"SUM(DISTINCT decimal_field1 )": 9775}, {"SUM(DISTINCT decimal_field1 )": 1664}, {"SUM(DISTINCT decimal_field1 )": 8424}, {"SUM(DISTINCT decimal_field1 )": 4141}, {"SUM(DISTINCT decimal_field1 )": 1064}, {"SUM(DISTINCT decimal_field1 )": 3360}, {"SUM(DISTINCT decimal_field1 )": 7880}, {"SUM(DISTINCT decimal_field1 )": 4949}, {"SUM(DISTINCT decimal_field1 )": 3591}, {"SUM(DISTINCT decimal_field1 )": 4612}, {"SUM(DISTINCT decimal_field1 )": 9016}, {"SUM(DISTINCT decimal_field1 )": 7839}, {"SUM(DISTINCT decimal_field1 )": 3532}, {"SUM(DISTINCT decimal_field1 )": 976}, {"SUM(DISTINCT decimal_field1 )": 1998}, {"SUM(DISTINCT decimal_field1 )": 8574}, {"SUM(DISTINCT decimal_field1 )": 5156}, {"SUM(DISTINCT decimal_field1 )": 3819}, {"SUM(DISTINCT decimal_field1 )": 58}, {"SUM(DISTINCT decimal_field1 )": 6019}, {"SUM(DISTINCT decimal_field1 )": 1212}, {"SUM(DISTINCT decimal_field1 )": 3602}, {"SUM(DISTINCT decimal_field1 )": 3328}, {"SUM(DISTINCT decimal_field1 )": 6855}, {"SUM(DISTINCT decimal_field1 )": 2652}, {"SUM(DISTINCT decimal_field1 )": 4716}, {"SUM(DISTINCT decimal_field1 )": 1585}, {"SUM(DISTINCT decimal_field1 )": 3944}, {"SUM(DISTINCT decimal_field1 )": 2883}, {"SUM(DISTINCT decimal_field1 )": 5349}, {"SUM(DISTINCT decimal_field1 )": 7260}, {"SUM(DISTINCT decimal_field1 )": 7017}, {"SUM(DISTINCT decimal_field1 )": 7258}, {"SUM(DISTINCT decimal_field1 )": 4916}, {"SUM(DISTINCT decimal_field1 )": 2658}, {"SUM(DISTINCT decimal_field1 )": 1408}, {"SUM(DISTINCT decimal_field1 )": 1220}, {"SUM(DISTINCT decimal_field1 )": 823}, {"SUM(DISTINCT decimal_field1 )": 9778}, {"SUM(DISTINCT decimal_field1 )": 4189}, {"SUM(DISTINCT decimal_field1 )": 5531}, {"SUM(DISTINCT decimal_field1 )": 8826}, {"SUM(DISTINCT decimal_field1 )": 3821}, {"SUM(DISTINCT decimal_field1 )": 7434}, {"SUM(DISTINCT decimal_field1 )": 6596}, {"SUM(DISTINCT decimal_field1 )": 6571}, {"SUM(DISTINCT decimal_field1 )": 1900}, {"SUM(DISTINCT decimal_field1 )": 1684}, {"SUM(DISTINCT decimal_field1 )": 2993}, {"SUM(DISTINCT decimal_field1 )": 7411}, {"SUM(DISTINCT decimal_field1 )": 3205}, {"SUM(DISTINCT decimal_field1 )": 2781}, {"SUM(DISTINCT decimal_field1 )": 7059}, {"SUM(DISTINCT decimal_field1 )": 4484}, {"SUM(DISTINCT decimal_field1 )": 9137}, {"SUM(DISTINCT decimal_field1 )": 1443}, {"SUM(DISTINCT decimal_field1 )": 2809}, {"SUM(DISTINCT decimal_field1 )": 5492}, {"SUM(DISTINCT decimal_field1 )": 9425}, {"SUM(DISTINCT decimal_field1 )": 6566}, {"SUM(DISTINCT decimal_field1 )": 3785}, {"SUM(DISTINCT decimal_field1 )": 3939}, {"SUM(DISTINCT decimal_field1 )": 8635}, {"SUM(DISTINCT decimal_field1 )": 611}, {"SUM(DISTINCT decimal_field1 )": 5858}, {"SUM(DISTINCT decimal_field1 )": 9931}, {"SUM(DISTINCT decimal_field1 )": 2488}, {"SUM(DISTINCT decimal_field1 )": 3987}, {"SUM(DISTINCT decimal_field1 )": 1445}, {"SUM(DISTINCT decimal_field1 )": 7619}, {"SUM(DISTINCT decimal_field1 )": 6318}, {"SUM(DISTINCT decimal_field1 )": 6602}, {"SUM(DISTINCT decimal_field1 )": 8703}, {"SUM(DISTINCT decimal_field1 )": 4742}, {"SUM(DISTINCT decimal_field1 )": 7105}, {"SUM(DISTINCT decimal_field1 )": 379}, {"SUM(DISTINCT decimal_field1 )": 3596}, {"SUM(DISTINCT decimal_field1 )": 2801}, {"SUM(DISTINCT decimal_field1 )": 8603}, {"SUM(DISTINCT decimal_field1 )": 9069}, {"SUM(DISTINCT decimal_field1 )": 3499}, {"SUM(DISTINCT decimal_field1 )": 8917}, {"SUM(DISTINCT decimal_field1 )": 2185}, {"SUM(DISTINCT decimal_field1 )": 9540}, {"SUM(DISTINCT decimal_field1 )": 4036}, {"SUM(DISTINCT decimal_field1 )": 2894}, {"SUM(DISTINCT decimal_field1 )": 453}, {"SUM(DISTINCT decimal_field1 )": 699}, {"SUM(DISTINCT decimal_field1 )": 5431}, {"SUM(DISTINCT decimal_field1 )": 5545}, {"SUM(DISTINCT decimal_field1 )": 9209}, {"SUM(DISTINCT decimal_field1 )": 1376}, {"SUM(DISTINCT decimal_field1 )": 7180}, {"SUM(DISTINCT decimal_field1 )": 5534}, {"SUM(DISTINCT decimal_field1 )": 1516}, {"SUM(DISTINCT decimal_field1 )": 4308}, {"SUM(DISTINCT decimal_field1 )": 2652}, {"SUM(DISTINCT decimal_field1 )": 9665}, {"SUM(DISTINCT decimal_field1 )": 5878}, {"SUM(DISTINCT decimal_field1 )": 2426}, {"SUM(DISTINCT decimal_field1 )": 8465}, {"SUM(DISTINCT decimal_field1 )": 2455}, {"SUM(DISTINCT decimal_field1 )": 6022}, {"SUM(DISTINCT decimal_field1 )": 6739}, {"SUM(DISTINCT decimal_field1 )": 6729}, {"SUM(DISTINCT decimal_field1 )": 1712}, {"SUM(DISTINCT decimal_field1 )": 2304}, {"SUM(DISTINCT decimal_field1 )": 8139}, {"SUM(DISTINCT decimal_field1 )": 8544}, {"SUM(DISTINCT decimal_field1 )": 3967}, {"SUM(DISTINCT decimal_field1 )": 934}, {"SUM(DISTINCT decimal_field1 )": 9220}, {"SUM(DISTINCT decimal_field1 )": 8931}, {"SUM(DISTINCT decimal_field1 )": 771}, {"SUM(DISTINCT decimal_field1 )": 965}, {"SUM(DISTINCT decimal_field1 )": 8717}, {"SUM(DISTINCT decimal_field1 )": 563}, {"SUM(DISTINCT decimal_field1 )": 2046}, {"SUM(DISTINCT decimal_field1 )": 9135}, {"SUM(DISTINCT decimal_field1 )": 8986}, {"SUM(DISTINCT decimal_field1 )": 357}, {"SUM(DISTINCT decimal_field1 )": 2232}, {"SUM(DISTINCT decimal_field1 )": 2861}, {"SUM(DISTINCT decimal_field1 )": 3483}, {"SUM(DISTINCT decimal_field1 )": 9744}, {"SUM(DISTINCT decimal_field1 )": 5706}, {"SUM(DISTINCT decimal_field1 )": 3639}, {"SUM(DISTINCT decimal_field1 )": 5632}, {"SUM(DISTINCT decimal_field1 )": 1813}, {"SUM(DISTINCT decimal_field1 )": 5853}, {"SUM(DISTINCT decimal_field1 )": 6647}, {"SUM(DISTINCT decimal_field1 )": 1140}, {"SUM(DISTINCT decimal_field1 )": 4322}, {"SUM(DISTINCT decimal_field1 )": 2839}, {"SUM(DISTINCT decimal_field1 )": 9406}, {"SUM(DISTINCT decimal_field1 )": 3087}, {"SUM(DISTINCT decimal_field1 )": 1645}, {"SUM(DISTINCT decimal_field1 )": 718}, {"SUM(DISTINCT decimal_field1 )": 8217}, {"SUM(DISTINCT decimal_field1 )": 7076}, {"SUM(DISTINCT decimal_field1 )": 2836}, {"SUM(DISTINCT decimal_field1 )": 1119}, {"SUM(DISTINCT decimal_field1 )": 5725}, {"SUM(DISTINCT decimal_field1 )": 7941}, {"SUM(DISTINCT decimal_field1 )": 2636}, {"SUM(DISTINCT decimal_field1 )": 9233}, {"SUM(DISTINCT decimal_field1 )": 4319}, {"SUM(DISTINCT decimal_field1 )": 3940}, {"SUM(DISTINCT decimal_field1 )": 5039}, {"SUM(DISTINCT decimal_field1 )": 3692}, {"SUM(DISTINCT decimal_field1 )": 1547}, {"SUM(DISTINCT decimal_field1 )": 5382}, {"SUM(DISTINCT decimal_field1 )": 3314}, {"SUM(DISTINCT decimal_field1 )": 3139}, {"SUM(DISTINCT decimal_field1 )": 2418}, {"SUM(DISTINCT decimal_field1 )": 9493}, {"SUM(DISTINCT decimal_field1 )": 4461}, {"SUM(DISTINCT decimal_field1 )": 9612}, {"SUM(DISTINCT decimal_field1 )": 5184}, {"SUM(DISTINCT decimal_field1 )": 2127}, {"SUM(DISTINCT decimal_field1 )": 3535}, {"SUM(DISTINCT decimal_field1 )": 3176}, {"SUM(DISTINCT decimal_field1 )": 1769}, {"SUM(DISTINCT decimal_field1 )": 9977}, {"SUM(DISTINCT decimal_field1 )": 153}, {"SUM(DISTINCT decimal_field1 )": 2446}, {"SUM(DISTINCT decimal_field1 )": 2305}, {"SUM(DISTINCT decimal_field1 )": 3240}, {"SUM(DISTINCT decimal_field1 )": 2834}, {"SUM(DISTINCT decimal_field1 )": 3374}, {"SUM(DISTINCT decimal_field1 )": 2175}, {"SUM(DISTINCT decimal_field1 )": 2409}, {"SUM(DISTINCT decimal_field1 )": 7682}, {"SUM(DISTINCT decimal_field1 )": 5693}, {"SUM(DISTINCT decimal_field1 )": 4878}, {"SUM(DISTINCT decimal_field1 )": 9543}, {"SUM(DISTINCT decimal_field1 )": 2372}, {"SUM(DISTINCT decimal_field1 )": 2943}, {"SUM(DISTINCT decimal_field1 )": 2367}, {"SUM(DISTINCT decimal_field1 )": 71}, {"SUM(DISTINCT decimal_field1 )": 5089}, {"SUM(DISTINCT decimal_field1 )": 9919}, {"SUM(DISTINCT decimal_field1 )": 7722}, {"SUM(DISTINCT decimal_field1 )": 4283}, {"SUM(DISTINCT decimal_field1 )": 2802}, {"SUM(DISTINCT decimal_field1 )": 7934}, {"SUM(DISTINCT decimal_field1 )": 6846}, {"SUM(DISTINCT decimal_field1 )": 3759}, {"SUM(DISTINCT decimal_field1 )": 606}, {"SUM(DISTINCT decimal_field1 )": 2793}, {"SUM(DISTINCT decimal_field1 )": 2671}, {"SUM(DISTINCT decimal_field1 )": 1658}, {"SUM(DISTINCT decimal_field1 )": 7003}, {"SUM(DISTINCT decimal_field1 )": 4751}, {"SUM(DISTINCT decimal_field1 )": 9550}, {"SUM(DISTINCT decimal_field1 )": 3556}, {"SUM(DISTINCT decimal_field1 )": 8743}, {"SUM(DISTINCT decimal_field1 )": 5511}, {"SUM(DISTINCT decimal_field1 )": 3715}, {"SUM(DISTINCT decimal_field1 )": 4494}, {"SUM(DISTINCT decimal_field1 )": 6972}, {"SUM(DISTINCT decimal_field1 )": 228}, {"SUM(DISTINCT decimal_field1 )": 4636}, {"SUM(DISTINCT decimal_field1 )": 5778}, {"SUM(DISTINCT decimal_field1 )": 2109}, {"SUM(DISTINCT decimal_field1 )": 5757}, {"SUM(DISTINCT decimal_field1 )": 4319}, {"SUM(DISTINCT decimal_field1 )": 7524}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM(DISTINCT decimal_field1 ) FROM simple_table_1 WHERE NOT ((NOT (bool_field1) AND int_field1 < 4760)) GROUP BY int_field1 , decimal_field1 "} {"n1ql": "SELECT MIN( decimal_field1 ) FROM simple_table_1 WHERE NOT (((decimal_field1 = 4849) AND ((decimal_field1 > 4849) OR (int_field1 <= 4760)) AND char_field1 <= \"N\" AND bool_field1)) GROUP BY primary_key_id , varchar_field1 ", "expected_result": [{"MIN( decimal_field1 )": 9415}, {"MIN( decimal_field1 )": 9666}, {"MIN( decimal_field1 )": 7447}, {"MIN( decimal_field1 )": 4657}, {"MIN( decimal_field1 )": 2759}, {"MIN( decimal_field1 )": 6019}, {"MIN( decimal_field1 )": 5184}, {"MIN( decimal_field1 )": 8703}, {"MIN( decimal_field1 )": 1443}, {"MIN( decimal_field1 )": 2401}, {"MIN( decimal_field1 )": 4534}, {"MIN( decimal_field1 )": 6566}, {"MIN( decimal_field1 )": 5608}, {"MIN( decimal_field1 )": 3668}, {"MIN( decimal_field1 )": 6052}, {"MIN( decimal_field1 )": 8064}, {"MIN( decimal_field1 )": 3633}, {"MIN( decimal_field1 )": 7953}, {"MIN( decimal_field1 )": 6855}, {"MIN( decimal_field1 )": 5122}, {"MIN( decimal_field1 )": 1140}, {"MIN( decimal_field1 )": 5757}, {"MIN( decimal_field1 )": 7603}, {"MIN( decimal_field1 )": 9678}, {"MIN( decimal_field1 )": 2065}, {"MIN( decimal_field1 )": 8345}, {"MIN( decimal_field1 )": 3987}, {"MIN( decimal_field1 )": 1175}, {"MIN( decimal_field1 )": 5172}, {"MIN( decimal_field1 )": 5615}, {"MIN( decimal_field1 )": 6853}, {"MIN( decimal_field1 )": 4283}, {"MIN( decimal_field1 )": 796}, {"MIN( decimal_field1 )": 8455}, {"MIN( decimal_field1 )": 1645}, {"MIN( decimal_field1 )": 3169}, {"MIN( decimal_field1 )": 6144}, {"MIN( decimal_field1 )": 8551}, {"MIN( decimal_field1 )": 808}, {"MIN( decimal_field1 )": 8331}, {"MIN( decimal_field1 )": 1331}, {"MIN( decimal_field1 )": 8683}, {"MIN( decimal_field1 )": 8955}, {"MIN( decimal_field1 )": 8891}, {"MIN( decimal_field1 )": 5403}, {"MIN( decimal_field1 )": 3682}, {"MIN( decimal_field1 )": 9590}, {"MIN( decimal_field1 )": 1155}, {"MIN( decimal_field1 )": 1863}, {"MIN( decimal_field1 )": 868}, {"MIN( decimal_field1 )": 4688}, {"MIN( decimal_field1 )": 7558}, {"MIN( decimal_field1 )": 2835}, {"MIN( decimal_field1 )": 9803}, {"MIN( decimal_field1 )": 8440}, {"MIN( decimal_field1 )": 7407}, {"MIN( decimal_field1 )": 6675}, {"MIN( decimal_field1 )": 2836}, {"MIN( decimal_field1 )": 2933}, {"MIN( decimal_field1 )": 6079}, {"MIN( decimal_field1 )": 7931}, {"MIN( decimal_field1 )": 939}, {"MIN( decimal_field1 )": 3546}, {"MIN( decimal_field1 )": 6515}, {"MIN( decimal_field1 )": 1664}, {"MIN( decimal_field1 )": 3293}, {"MIN( decimal_field1 )": 2333}, {"MIN( decimal_field1 )": 2861}, {"MIN( decimal_field1 )": 654}, {"MIN( decimal_field1 )": 6022}, {"MIN( decimal_field1 )": 794}, {"MIN( decimal_field1 )": 168}, {"MIN( decimal_field1 )": 2082}, {"MIN( decimal_field1 )": 1810}, {"MIN( decimal_field1 )": 8717}, {"MIN( decimal_field1 )": 1736}, {"MIN( decimal_field1 )": 4195}, {"MIN( decimal_field1 )": 5284}, {"MIN( decimal_field1 )": 8047}, {"MIN( decimal_field1 )": 5228}, {"MIN( decimal_field1 )": 7583}, {"MIN( decimal_field1 )": 1360}, {"MIN( decimal_field1 )": 9260}, {"MIN( decimal_field1 )": 2652}, {"MIN( decimal_field1 )": 7915}, {"MIN( decimal_field1 )": 3483}, {"MIN( decimal_field1 )": 4580}, {"MIN( decimal_field1 )": 1917}, {"MIN( decimal_field1 )": 5382}, {"MIN( decimal_field1 )": 9230}, {"MIN( decimal_field1 )": 9406}, {"MIN( decimal_field1 )": 4036}, {"MIN( decimal_field1 )": 1701}, {"MIN( decimal_field1 )": 1585}, {"MIN( decimal_field1 )": 636}, {"MIN( decimal_field1 )": 5878}, {"MIN( decimal_field1 )": 3967}, {"MIN( decimal_field1 )": 7137}, {"MIN( decimal_field1 )": 3698}, {"MIN( decimal_field1 )": 2488}, {"MIN( decimal_field1 )": 1416}, {"MIN( decimal_field1 )": 6337}, {"MIN( decimal_field1 )": 3924}, {"MIN( decimal_field1 )": 3233}, {"MIN( decimal_field1 )": 4878}, {"MIN( decimal_field1 )": 6972}, {"MIN( decimal_field1 )": 4916}, {"MIN( decimal_field1 )": 2156}, {"MIN( decimal_field1 )": 8230}, {"MIN( decimal_field1 )": 9888}, {"MIN( decimal_field1 )": 4636}, {"MIN( decimal_field1 )": 1675}, {"MIN( decimal_field1 )": 4183}, {"MIN( decimal_field1 )": 7524}, {"MIN( decimal_field1 )": 6446}, {"MIN( decimal_field1 )": 6644}, {"MIN( decimal_field1 )": 786}, {"MIN( decimal_field1 )": 8353}, {"MIN( decimal_field1 )": 5005}, {"MIN( decimal_field1 )": 3100}, {"MIN( decimal_field1 )": 5572}, {"MIN( decimal_field1 )": 6388}, {"MIN( decimal_field1 )": 2305}, {"MIN( decimal_field1 )": 4659}, {"MIN( decimal_field1 )": 1204}, {"MIN( decimal_field1 )": 48}, {"MIN( decimal_field1 )": 4127}, {"MIN( decimal_field1 )": 4312}, {"MIN( decimal_field1 )": 5853}, {"MIN( decimal_field1 )": 9775}, {"MIN( decimal_field1 )": 3303}, {"MIN( decimal_field1 )": 9890}, {"MIN( decimal_field1 )": 128}, {"MIN( decimal_field1 )": 8424}, {"MIN( decimal_field1 )": 2012}, {"MIN( decimal_field1 )": 6866}, {"MIN( decimal_field1 )": 2321}, {"MIN( decimal_field1 )": 6106}, {"MIN( decimal_field1 )": 5065}, {"MIN( decimal_field1 )": 3785}, {"MIN( decimal_field1 )": 2302}, {"MIN( decimal_field1 )": 5459}, {"MIN( decimal_field1 )": 204}, {"MIN( decimal_field1 )": 9633}, {"MIN( decimal_field1 )": 7265}, {"MIN( decimal_field1 )": 7101}, {"MIN( decimal_field1 )": 6894}, {"MIN( decimal_field1 )": 9812}, {"MIN( decimal_field1 )": 2796}, {"MIN( decimal_field1 )": 7566}, {"MIN( decimal_field1 )": 4719}, {"MIN( decimal_field1 )": 5263}, {"MIN( decimal_field1 )": 2808}, {"MIN( decimal_field1 )": 3143}, {"MIN( decimal_field1 )": 3685}, {"MIN( decimal_field1 )": 3292}, {"MIN( decimal_field1 )": 814}, {"MIN( decimal_field1 )": 7972}, {"MIN( decimal_field1 )": 4642}, {"MIN( decimal_field1 )": 2094}, {"MIN( decimal_field1 )": 9375}, {"MIN( decimal_field1 )": 6003}, {"MIN( decimal_field1 )": 6308}, {"MIN( decimal_field1 )": 6146}, {"MIN( decimal_field1 )": 4814}, {"MIN( decimal_field1 )": 4100}, {"MIN( decimal_field1 )": 1630}, {"MIN( decimal_field1 )": 456}, {"MIN( decimal_field1 )": 1737}, {"MIN( decimal_field1 )": 9536}, {"MIN( decimal_field1 )": 7044}, {"MIN( decimal_field1 )": 5502}, {"MIN( decimal_field1 )": 7446}, {"MIN( decimal_field1 )": 5999}, {"MIN( decimal_field1 )": 9744}, {"MIN( decimal_field1 )": 7554}, {"MIN( decimal_field1 )": 255}, {"MIN( decimal_field1 )": 8812}, {"MIN( decimal_field1 )": 2809}, {"MIN( decimal_field1 )": 9220}, {"MIN( decimal_field1 )": 8090}, {"MIN( decimal_field1 )": 3066}, {"MIN( decimal_field1 )": 1863}, {"MIN( decimal_field1 )": 864}, {"MIN( decimal_field1 )": 1946}, {"MIN( decimal_field1 )": 3819}, {"MIN( decimal_field1 )": 2747}, {"MIN( decimal_field1 )": 7689}, {"MIN( decimal_field1 )": 5431}, {"MIN( decimal_field1 )": 5778}, {"MIN( decimal_field1 )": 5}, {"MIN( decimal_field1 )": 1018}, {"MIN( decimal_field1 )": 5266}, {"MIN( decimal_field1 )": 8733}, {"MIN( decimal_field1 )": 1346}, {"MIN( decimal_field1 )": 8117}, {"MIN( decimal_field1 )": 1114}, {"MIN( decimal_field1 )": 5089}, {"MIN( decimal_field1 )": 3778}, {"MIN( decimal_field1 )": 8412}, {"MIN( decimal_field1 )": 8498}, {"MIN( decimal_field1 )": 8708}, {"MIN( decimal_field1 )": 8608}, {"MIN( decimal_field1 )": 8875}, {"MIN( decimal_field1 )": 1971}, {"MIN( decimal_field1 )": 9091}, {"MIN( decimal_field1 )": 9388}, {"MIN( decimal_field1 )": 4674}, {"MIN( decimal_field1 )": 7826}, {"MIN( decimal_field1 )": 2838}, {"MIN( decimal_field1 )": 2901}, {"MIN( decimal_field1 )": 5156}, {"MIN( decimal_field1 )": 148}, {"MIN( decimal_field1 )": 9748}, {"MIN( decimal_field1 )": 5847}, {"MIN( decimal_field1 )": 2255}, {"MIN( decimal_field1 )": 8502}, {"MIN( decimal_field1 )": 8436}, {"MIN( decimal_field1 )": 3749}, {"MIN( decimal_field1 )": 4916}, {"MIN( decimal_field1 )": 765}, {"MIN( decimal_field1 )": 7757}, {"MIN( decimal_field1 )": 9543}, {"MIN( decimal_field1 )": 7913}, {"MIN( decimal_field1 )": 4246}, {"MIN( decimal_field1 )": 8390}, {"MIN( decimal_field1 )": 5039}, {"MIN( decimal_field1 )": 7619}, {"MIN( decimal_field1 )": 1547}, {"MIN( decimal_field1 )": 9272}, {"MIN( decimal_field1 )": 1071}, {"MIN( decimal_field1 )": 9896}, {"MIN( decimal_field1 )": 345}, {"MIN( decimal_field1 )": 228}, {"MIN( decimal_field1 )": 8421}, {"MIN( decimal_field1 )": 2883}, {"MIN( decimal_field1 )": 7076}, {"MIN( decimal_field1 )": 4500}, {"MIN( decimal_field1 )": 4696}, {"MIN( decimal_field1 )": 9948}, {"MIN( decimal_field1 )": 8791}, {"MIN( decimal_field1 )": 8893}, {"MIN( decimal_field1 )": 5978}, {"MIN( decimal_field1 )": 2121}, {"MIN( decimal_field1 )": 2853}, {"MIN( decimal_field1 )": 7701}, {"MIN( decimal_field1 )": 6399}, {"MIN( decimal_field1 )": 955}, {"MIN( decimal_field1 )": 5602}, {"MIN( decimal_field1 )": 5788}, {"MIN( decimal_field1 )": 7763}, {"MIN( decimal_field1 )": 5528}, {"MIN( decimal_field1 )": 5839}, {"MIN( decimal_field1 )": 2793}, {"MIN( decimal_field1 )": 4098}, {"MIN( decimal_field1 )": 8635}, {"MIN( decimal_field1 )": 2504}, {"MIN( decimal_field1 )": 1502}, {"MIN( decimal_field1 )": 7608}, {"MIN( decimal_field1 )": 7464}, {"MIN( decimal_field1 )": 147}, {"MIN( decimal_field1 )": 3359}, {"MIN( decimal_field1 )": 3556}, {"MIN( decimal_field1 )": 6157}, {"MIN( decimal_field1 )": 4068}, {"MIN( decimal_field1 )": 9278}, {"MIN( decimal_field1 )": 4201}, {"MIN( decimal_field1 )": 2239}, {"MIN( decimal_field1 )": 4484}, {"MIN( decimal_field1 )": 9847}, {"MIN( decimal_field1 )": 6259}, {"MIN( decimal_field1 )": 9565}, {"MIN( decimal_field1 )": 6838}, {"MIN( decimal_field1 )": 1438}, {"MIN( decimal_field1 )": 6843}, {"MIN( decimal_field1 )": 5880}, {"MIN( decimal_field1 )": 8845}, {"MIN( decimal_field1 )": 2046}, {"MIN( decimal_field1 )": 1257}, {"MIN( decimal_field1 )": 5896}, {"MIN( decimal_field1 )": 9911}, {"MIN( decimal_field1 )": 8570}, {"MIN( decimal_field1 )": 9069}, {"MIN( decimal_field1 )": 5844}, {"MIN( decimal_field1 )": 7005}, {"MIN( decimal_field1 )": 6128}, {"MIN( decimal_field1 )": 2758}, {"MIN( decimal_field1 )": 7722}, {"MIN( decimal_field1 )": 7260}, {"MIN( decimal_field1 )": 5995}, {"MIN( decimal_field1 )": 8653}, {"MIN( decimal_field1 )": 2997}, {"MIN( decimal_field1 )": 5794}, {"MIN( decimal_field1 )": 9730}, {"MIN( decimal_field1 )": 5598}, {"MIN( decimal_field1 )": 3139}, {"MIN( decimal_field1 )": 6846}, {"MIN( decimal_field1 )": 7857}, {"MIN( decimal_field1 )": 2667}, {"MIN( decimal_field1 )": 1064}, {"MIN( decimal_field1 )": 6191}, {"MIN( decimal_field1 )": 8544}, {"MIN( decimal_field1 )": 350}, {"MIN( decimal_field1 )": 1926}, {"MIN( decimal_field1 )": 9021}, {"MIN( decimal_field1 )": 9493}, {"MIN( decimal_field1 )": 5117}, {"MIN( decimal_field1 )": 672}, {"MIN( decimal_field1 )": 9930}, {"MIN( decimal_field1 )": 9932}, {"MIN( decimal_field1 )": 9665}, {"MIN( decimal_field1 )": 5157}, {"MIN( decimal_field1 )": 4801}, {"MIN( decimal_field1 )": 9550}, {"MIN( decimal_field1 )": 2354}, {"MIN( decimal_field1 )": 411}, {"MIN( decimal_field1 )": 153}, {"MIN( decimal_field1 )": 1364}, {"MIN( decimal_field1 )": 609}, {"MIN( decimal_field1 )": 531}, {"MIN( decimal_field1 )": 1376}, {"MIN( decimal_field1 )": 3562}, {"MIN( decimal_field1 )": 3715}, {"MIN( decimal_field1 )": 7803}, {"MIN( decimal_field1 )": 4322}, {"MIN( decimal_field1 )": 7769}, {"MIN( decimal_field1 )": 7811}, {"MIN( decimal_field1 )": 3808}, {"MIN( decimal_field1 )": 2633}, {"MIN( decimal_field1 )": 9931}, {"MIN( decimal_field1 )": 3639}, {"MIN( decimal_field1 )": 6901}, {"MIN( decimal_field1 )": 1237}, {"MIN( decimal_field1 )": 287}, {"MIN( decimal_field1 )": 4820}, {"MIN( decimal_field1 )": 8971}, {"MIN( decimal_field1 )": 2781}, {"MIN( decimal_field1 )": 590}, {"MIN( decimal_field1 )": 746}, {"MIN( decimal_field1 )": 1310}, {"MIN( decimal_field1 )": 8217}, {"MIN( decimal_field1 )": 2109}, {"MIN( decimal_field1 )": 2115}, {"MIN( decimal_field1 )": 5183}, {"MIN( decimal_field1 )": 2628}, {"MIN( decimal_field1 )": 1359}, {"MIN( decimal_field1 )": 3602}, {"MIN( decimal_field1 )": 7273}, {"MIN( decimal_field1 )": 611}, {"MIN( decimal_field1 )": 4562}, {"MIN( decimal_field1 )": 3975}, {"MIN( decimal_field1 )": 4632}, {"MIN( decimal_field1 )": 7037}, {"MIN( decimal_field1 )": 5668}, {"MIN( decimal_field1 )": 3722}, {"MIN( decimal_field1 )": 4838}, {"MIN( decimal_field1 )": 7197}, {"MIN( decimal_field1 )": 185}, {"MIN( decimal_field1 )": 6361}, {"MIN( decimal_field1 )": 3591}, {"MIN( decimal_field1 )": 9466}, {"MIN( decimal_field1 )": 9807}, {"MIN( decimal_field1 )": 2269}, {"MIN( decimal_field1 )": 4949}, {"MIN( decimal_field1 )": 355}, {"MIN( decimal_field1 )": 7821}, {"MIN( decimal_field1 )": 1660}, {"MIN( decimal_field1 )": 8314}, {"MIN( decimal_field1 )": 1927}, {"MIN( decimal_field1 )": 904}, {"MIN( decimal_field1 )": 8772}, {"MIN( decimal_field1 )": 7059}, {"MIN( decimal_field1 )": 3314}, {"MIN( decimal_field1 )": 5534}, {"MIN( decimal_field1 )": 3008}, {"MIN( decimal_field1 )": 2547}, {"MIN( decimal_field1 )": 6940}, {"MIN( decimal_field1 )": 1841}, {"MIN( decimal_field1 )": 9128}, {"MIN( decimal_field1 )": 840}, {"MIN( decimal_field1 )": 2819}, {"MIN( decimal_field1 )": 5811}, {"MIN( decimal_field1 )": 471}, {"MIN( decimal_field1 )": 212}, {"MIN( decimal_field1 )": 4999}, {"MIN( decimal_field1 )": 9311}, {"MIN( decimal_field1 )": 8574}, {"MIN( decimal_field1 )": 6266}, {"MIN( decimal_field1 )": 1426}, {"MIN( decimal_field1 )": 571}, {"MIN( decimal_field1 )": 3490}, {"MIN( decimal_field1 )": 9021}, {"MIN( decimal_field1 )": 8878}, {"MIN( decimal_field1 )": 5319}, {"MIN( decimal_field1 )": 3821}, {"MIN( decimal_field1 )": 3709}, {"MIN( decimal_field1 )": 4814}, {"MIN( decimal_field1 )": 5591}, {"MIN( decimal_field1 )": 996}, {"MIN( decimal_field1 )": 5638}, {"MIN( decimal_field1 )": 3298}, {"MIN( decimal_field1 )": 525}, {"MIN( decimal_field1 )": 8037}, {"MIN( decimal_field1 )": 3028}, {"MIN( decimal_field1 )": 5556}, {"MIN( decimal_field1 )": 7855}, {"MIN( decimal_field1 )": 2785}, {"MIN( decimal_field1 )": 6474}, {"MIN( decimal_field1 )": 6220}, {"MIN( decimal_field1 )": 8036}, {"MIN( decimal_field1 )": 3138}, {"MIN( decimal_field1 )": 5037}, {"MIN( decimal_field1 )": 6305}, {"MIN( decimal_field1 )": 7276}, {"MIN( decimal_field1 )": 7620}, {"MIN( decimal_field1 )": 7114}, {"MIN( decimal_field1 )": 4007}, {"MIN( decimal_field1 )": 9351}, {"MIN( decimal_field1 )": 9137}, {"MIN( decimal_field1 )": 2197}, {"MIN( decimal_field1 )": 5366}, {"MIN( decimal_field1 )": 934}, {"MIN( decimal_field1 )": 2909}, {"MIN( decimal_field1 )": 9904}, {"MIN( decimal_field1 )": 2324}, {"MIN( decimal_field1 )": 6283}, {"MIN( decimal_field1 )": 5553}, {"MIN( decimal_field1 )": 7734}, {"MIN( decimal_field1 )": 4628}, {"MIN( decimal_field1 )": 6151}, {"MIN( decimal_field1 )": 2993}, {"MIN( decimal_field1 )": 3319}, {"MIN( decimal_field1 )": 9209}, {"MIN( decimal_field1 )": 552}, {"MIN( decimal_field1 )": 1336}, {"MIN( decimal_field1 )": 4319}, {"MIN( decimal_field1 )": 1871}, {"MIN( decimal_field1 )": 1900}, {"MIN( decimal_field1 )": 9559}, {"MIN( decimal_field1 )": 1385}, {"MIN( decimal_field1 )": 8648}, {"MIN( decimal_field1 )": 3928}, {"MIN( decimal_field1 )": 8966}, {"MIN( decimal_field1 )": 2414}, {"MIN( decimal_field1 )": 5616}, {"MIN( decimal_field1 )": 5758}, {"MIN( decimal_field1 )": 496}, {"MIN( decimal_field1 )": 3191}, {"MIN( decimal_field1 )": 2370}, {"MIN( decimal_field1 )": 4065}, {"MIN( decimal_field1 )": 6516}, {"MIN( decimal_field1 )": 1191}, {"MIN( decimal_field1 )": 1681}, {"MIN( decimal_field1 )": 7097}, {"MIN( decimal_field1 )": 3835}, {"MIN( decimal_field1 )": 3148}, {"MIN( decimal_field1 )": 4614}, {"MIN( decimal_field1 )": 9322}, {"MIN( decimal_field1 )": 3002}, {"MIN( decimal_field1 )": 7784}, {"MIN( decimal_field1 )": 2839}, {"MIN( decimal_field1 )": 4716}, {"MIN( decimal_field1 )": 7708}, {"MIN( decimal_field1 )": 4668}, {"MIN( decimal_field1 )": 593}, {"MIN( decimal_field1 )": 6955}, {"MIN( decimal_field1 )": 5353}, {"MIN( decimal_field1 )": 7650}, {"MIN( decimal_field1 )": 9013}, {"MIN( decimal_field1 )": 3843}, {"MIN( decimal_field1 )": 8415}, {"MIN( decimal_field1 )": 6310}, {"MIN( decimal_field1 )": 2297}, {"MIN( decimal_field1 )": 1232}, {"MIN( decimal_field1 )": 2863}, {"MIN( decimal_field1 )": 8622}, {"MIN( decimal_field1 )": 1445}, {"MIN( decimal_field1 )": 4120}, {"MIN( decimal_field1 )": 4191}, {"MIN( decimal_field1 )": 2456}, {"MIN( decimal_field1 )": 9333}, {"MIN( decimal_field1 )": 6729}, {"MIN( decimal_field1 )": 7655}, {"MIN( decimal_field1 )": 101}, {"MIN( decimal_field1 )": 718}, {"MIN( decimal_field1 )": 9942}, {"MIN( decimal_field1 )": 3551}, {"MIN( decimal_field1 )": 2037}, {"MIN( decimal_field1 )": 8139}, {"MIN( decimal_field1 )": 2632}, {"MIN( decimal_field1 )": 2834}, {"MIN( decimal_field1 )": 8421}, {"MIN( decimal_field1 )": 9856}, {"MIN( decimal_field1 )": 5160}, {"MIN( decimal_field1 )": 2316}, {"MIN( decimal_field1 )": 3763}, {"MIN( decimal_field1 )": 6819}, {"MIN( decimal_field1 )": 3036}, {"MIN( decimal_field1 )": 8007}, {"MIN( decimal_field1 )": 3759}, {"MIN( decimal_field1 )": 3587}, {"MIN( decimal_field1 )": 1813}, {"MIN( decimal_field1 )": 3939}, {"MIN( decimal_field1 )": 6318}, {"MIN( decimal_field1 )": 7102}, {"MIN( decimal_field1 )": 6564}, {"MIN( decimal_field1 )": 4755}, {"MIN( decimal_field1 )": 6676}, {"MIN( decimal_field1 )": 9902}, {"MIN( decimal_field1 )": 3852}, {"MIN( decimal_field1 )": 8792}, {"MIN( decimal_field1 )": 453}, {"MIN( decimal_field1 )": 8654}, {"MIN( decimal_field1 )": 3360}, {"MIN( decimal_field1 )": 952}, {"MIN( decimal_field1 )": 2637}, {"MIN( decimal_field1 )": 6542}, {"MIN( decimal_field1 )": 2589}, {"MIN( decimal_field1 )": 3831}, {"MIN( decimal_field1 )": 7003}, {"MIN( decimal_field1 )": 8060}, {"MIN( decimal_field1 )": 7434}, {"MIN( decimal_field1 )": 8027}, {"MIN( decimal_field1 )": 2548}, {"MIN( decimal_field1 )": 15}, {"MIN( decimal_field1 )": 6455}, {"MIN( decimal_field1 )": 3070}, {"MIN( decimal_field1 )": 2894}, {"MIN( decimal_field1 )": 9}, {"MIN( decimal_field1 )": 7583}, {"MIN( decimal_field1 )": 8986}, {"MIN( decimal_field1 )": 6428}, {"MIN( decimal_field1 )": 5816}, {"MIN( decimal_field1 )": 3572}, {"MIN( decimal_field1 )": 6861}, {"MIN( decimal_field1 )": 5511}, {"MIN( decimal_field1 )": 6457}, {"MIN( decimal_field1 )": 7650}, {"MIN( decimal_field1 )": 123}, {"MIN( decimal_field1 )": 7105}, {"MIN( decimal_field1 )": 9154}, {"MIN( decimal_field1 )": 8984}, {"MIN( decimal_field1 )": 3349}, {"MIN( decimal_field1 )": 6501}, {"MIN( decimal_field1 )": 510}, {"MIN( decimal_field1 )": 3240}, {"MIN( decimal_field1 )": 379}, {"MIN( decimal_field1 )": 946}, {"MIN( decimal_field1 )": 5515}, {"MIN( decimal_field1 )": 6473}, {"MIN( decimal_field1 )": 8931}, {"MIN( decimal_field1 )": 7983}, {"MIN( decimal_field1 )": 1516}, {"MIN( decimal_field1 )": 221}, {"MIN( decimal_field1 )": 5492}, {"MIN( decimal_field1 )": 2426}, {"MIN( decimal_field1 )": 4742}, {"MIN( decimal_field1 )": 6739}, {"MIN( decimal_field1 )": 7060}, {"MIN( decimal_field1 )": 7722}, {"MIN( decimal_field1 )": 1526}, {"MIN( decimal_field1 )": 4358}, {"MIN( decimal_field1 )": 3888}, {"MIN( decimal_field1 )": 6420}, {"MIN( decimal_field1 )": 235}, {"MIN( decimal_field1 )": 4084}, {"MIN( decimal_field1 )": 2683}, {"MIN( decimal_field1 )": 606}, {"MIN( decimal_field1 )": 9233}, {"MIN( decimal_field1 )": 8893}, {"MIN( decimal_field1 )": 2024}, {"MIN( decimal_field1 )": 4751}, {"MIN( decimal_field1 )": 3374}, {"MIN( decimal_field1 )": 610}, {"MIN( decimal_field1 )": 1408}, {"MIN( decimal_field1 )": 4401}, {"MIN( decimal_field1 )": 3161}, {"MIN( decimal_field1 )": 3700}, {"MIN( decimal_field1 )": 541}, {"MIN( decimal_field1 )": 3039}, {"MIN( decimal_field1 )": 7258}, {"MIN( decimal_field1 )": 7379}, {"MIN( decimal_field1 )": 5885}, {"MIN( decimal_field1 )": 3479}, {"MIN( decimal_field1 )": 823}, {"MIN( decimal_field1 )": 3536}, {"MIN( decimal_field1 )": 4238}, {"MIN( decimal_field1 )": 7105}, {"MIN( decimal_field1 )": 3265}, {"MIN( decimal_field1 )": 9771}, {"MIN( decimal_field1 )": 6164}, {"MIN( decimal_field1 )": 7066}, {"MIN( decimal_field1 )": 8247}, {"MIN( decimal_field1 )": 3499}, {"MIN( decimal_field1 )": 9919}, {"MIN( decimal_field1 )": 6647}, {"MIN( decimal_field1 )": 7682}, {"MIN( decimal_field1 )": 9355}, {"MIN( decimal_field1 )": 5966}, {"MIN( decimal_field1 )": 9244}, {"MIN( decimal_field1 )": 1059}, {"MIN( decimal_field1 )": 7774}, {"MIN( decimal_field1 )": 1346}, {"MIN( decimal_field1 )": 1162}, {"MIN( decimal_field1 )": 926}, {"MIN( decimal_field1 )": 6371}, {"MIN( decimal_field1 )": 3176}, {"MIN( decimal_field1 )": 7941}, {"MIN( decimal_field1 )": 7017}, {"MIN( decimal_field1 )": 3569}, {"MIN( decimal_field1 )": 7815}, {"MIN( decimal_field1 )": 981}, {"MIN( decimal_field1 )": 1116}, {"MIN( decimal_field1 )": 2909}, {"MIN( decimal_field1 )": 5841}, {"MIN( decimal_field1 )": 4134}, {"MIN( decimal_field1 )": 9213}, {"MIN( decimal_field1 )": 3596}, {"MIN( decimal_field1 )": 2489}, {"MIN( decimal_field1 )": 9442}, {"MIN( decimal_field1 )": 3401}, {"MIN( decimal_field1 )": 3981}, {"MIN( decimal_field1 )": 4178}, {"MIN( decimal_field1 )": 3940}, {"MIN( decimal_field1 )": 2398}, {"MIN( decimal_field1 )": 6490}, {"MIN( decimal_field1 )": 1499}, {"MIN( decimal_field1 )": 5531}, {"MIN( decimal_field1 )": 1794}, {"MIN( decimal_field1 )": 9425}, {"MIN( decimal_field1 )": 587}, {"MIN( decimal_field1 )": 2689}, {"MIN( decimal_field1 )": 2409}, {"MIN( decimal_field1 )": 8899}, {"MIN( decimal_field1 )": 3006}, {"MIN( decimal_field1 )": 2652}, {"MIN( decimal_field1 )": 8427}, {"MIN( decimal_field1 )": 4348}, {"MIN( decimal_field1 )": 9406}, {"MIN( decimal_field1 )": 5274}, {"MIN( decimal_field1 )": 1749}, {"MIN( decimal_field1 )": 3426}, {"MIN( decimal_field1 )": 3035}, {"MIN( decimal_field1 )": 1483}, {"MIN( decimal_field1 )": 8301}, {"MIN( decimal_field1 )": 4873}, {"MIN( decimal_field1 )": 7948}, {"MIN( decimal_field1 )": 7325}, {"MIN( decimal_field1 )": 3223}, {"MIN( decimal_field1 )": 7323}, {"MIN( decimal_field1 )": 2671}, {"MIN( decimal_field1 )": 1481}, {"MIN( decimal_field1 )": 8908}, {"MIN( decimal_field1 )": 2127}, {"MIN( decimal_field1 )": 2367}, {"MIN( decimal_field1 )": 7358}, {"MIN( decimal_field1 )": 4189}, {"MIN( decimal_field1 )": 1658}, {"MIN( decimal_field1 )": 7348}, {"MIN( decimal_field1 )": 1775}, {"MIN( decimal_field1 )": 1934}, {"MIN( decimal_field1 )": 8175}, {"MIN( decimal_field1 )": 9639}, {"MIN( decimal_field1 )": 4319}, {"MIN( decimal_field1 )": 1945}, {"MIN( decimal_field1 )": 7529}, {"MIN( decimal_field1 )": 7839}, {"MIN( decimal_field1 )": 8016}, {"MIN( decimal_field1 )": 4141}, {"MIN( decimal_field1 )": 4370}, {"MIN( decimal_field1 )": 8826}, {"MIN( decimal_field1 )": 8539}, {"MIN( decimal_field1 )": 1998}, {"MIN( decimal_field1 )": 9113}, {"MIN( decimal_field1 )": 7650}, {"MIN( decimal_field1 )": 4081}, {"MIN( decimal_field1 )": 7669}, {"MIN( decimal_field1 )": 2201}, {"MIN( decimal_field1 )": 7161}, {"MIN( decimal_field1 )": 1163}, {"MIN( decimal_field1 )": 3087}, {"MIN( decimal_field1 )": 7759}, {"MIN( decimal_field1 )": 7880}, {"MIN( decimal_field1 )": 13}, {"MIN( decimal_field1 )": 3516}, {"MIN( decimal_field1 )": 230}, {"MIN( decimal_field1 )": 6602}, {"MIN( decimal_field1 )": 3532}, {"MIN( decimal_field1 )": 3721}, {"MIN( decimal_field1 )": 9198}, {"MIN( decimal_field1 )": 5706}, {"MIN( decimal_field1 )": 948}, {"MIN( decimal_field1 )": 7411}, {"MIN( decimal_field1 )": 1166}, {"MIN( decimal_field1 )": 3328}, {"MIN( decimal_field1 )": 3830}, {"MIN( decimal_field1 )": 4798}, {"MIN( decimal_field1 )": 2286}, {"MIN( decimal_field1 )": 3306}, {"MIN( decimal_field1 )": 3967}, {"MIN( decimal_field1 )": 5382}, {"MIN( decimal_field1 )": 1119}, {"MIN( decimal_field1 )": 5080}, {"MIN( decimal_field1 )": 2802}, {"MIN( decimal_field1 )": 976}, {"MIN( decimal_field1 )": 8286}, {"MIN( decimal_field1 )": 6905}, {"MIN( decimal_field1 )": 4238}, {"MIN( decimal_field1 )": 4849}, {"MIN( decimal_field1 )": 7693}, {"MIN( decimal_field1 )": 9338}, {"MIN( decimal_field1 )": 1912}, {"MIN( decimal_field1 )": 5632}, {"MIN( decimal_field1 )": 4212}, {"MIN( decimal_field1 )": 3896}, {"MIN( decimal_field1 )": 7332}, {"MIN( decimal_field1 )": 3535}, {"MIN( decimal_field1 )": 1265}, {"MIN( decimal_field1 )": 5873}, {"MIN( decimal_field1 )": 473}, {"MIN( decimal_field1 )": 3944}, {"MIN( decimal_field1 )": 4992}, {"MIN( decimal_field1 )": 6582}, {"MIN( decimal_field1 )": 7423}, {"MIN( decimal_field1 )": 2372}, {"MIN( decimal_field1 )": 9948}, {"MIN( decimal_field1 )": 741}, {"MIN( decimal_field1 )": 9289}, {"MIN( decimal_field1 )": 6651}, {"MIN( decimal_field1 )": 9493}, {"MIN( decimal_field1 )": 5742}, {"MIN( decimal_field1 )": 2185}, {"MIN( decimal_field1 )": 2465}, {"MIN( decimal_field1 )": 947}, {"MIN( decimal_field1 )": 8031}, {"MIN( decimal_field1 )": 6814}, {"MIN( decimal_field1 )": 6678}, {"MIN( decimal_field1 )": 7332}, {"MIN( decimal_field1 )": 403}, {"MIN( decimal_field1 )": 8943}, {"MIN( decimal_field1 )": 5315}, {"MIN( decimal_field1 )": 4494}, {"MIN( decimal_field1 )": 6571}, {"MIN( decimal_field1 )": 9574}, {"MIN( decimal_field1 )": 7934}, {"MIN( decimal_field1 )": 1188}, {"MIN( decimal_field1 )": 4308}, {"MIN( decimal_field1 )": 7191}, {"MIN( decimal_field1 )": 1939}, {"MIN( decimal_field1 )": 9977}, {"MIN( decimal_field1 )": 5349}, {"MIN( decimal_field1 )": 4612}, {"MIN( decimal_field1 )": 965}, {"MIN( decimal_field1 )": 1319}, {"MIN( decimal_field1 )": 5792}, {"MIN( decimal_field1 )": 3510}, {"MIN( decimal_field1 )": 7301}, {"MIN( decimal_field1 )": 3468}, {"MIN( decimal_field1 )": 2801}, {"MIN( decimal_field1 )": 1434}, {"MIN( decimal_field1 )": 1545}, {"MIN( decimal_field1 )": 4475}, {"MIN( decimal_field1 )": 5401}, {"MIN( decimal_field1 )": 5356}, {"MIN( decimal_field1 )": 8826}, {"MIN( decimal_field1 )": 7274}, {"MIN( decimal_field1 )": 5574}, {"MIN( decimal_field1 )": 9293}, {"MIN( decimal_field1 )": 274}, {"MIN( decimal_field1 )": 4811}, {"MIN( decimal_field1 )": 9881}, {"MIN( decimal_field1 )": 95}, {"MIN( decimal_field1 )": 6147}, {"MIN( decimal_field1 )": 8743}, {"MIN( decimal_field1 )": 5643}, {"MIN( decimal_field1 )": 7522}, {"MIN( decimal_field1 )": 3201}, {"MIN( decimal_field1 )": 3179}, {"MIN( decimal_field1 )": 2667}, {"MIN( decimal_field1 )": 2943}, {"MIN( decimal_field1 )": 8358}, {"MIN( decimal_field1 )": 1780}, {"MIN( decimal_field1 )": 2663}, {"MIN( decimal_field1 )": 71}, {"MIN( decimal_field1 )": 2365}, {"MIN( decimal_field1 )": 5121}, {"MIN( decimal_field1 )": 9233}, {"MIN( decimal_field1 )": 7884}, {"MIN( decimal_field1 )": 237}, {"MIN( decimal_field1 )": 6067}, {"MIN( decimal_field1 )": 5475}, {"MIN( decimal_field1 )": 5725}, {"MIN( decimal_field1 )": 9612}, {"MIN( decimal_field1 )": 3744}, {"MIN( decimal_field1 )": 6844}, {"MIN( decimal_field1 )": 2471}, {"MIN( decimal_field1 )": 9778}, {"MIN( decimal_field1 )": 2891}, {"MIN( decimal_field1 )": 5045}, {"MIN( decimal_field1 )": 2450}, {"MIN( decimal_field1 )": 8468}, {"MIN( decimal_field1 )": 8383}, {"MIN( decimal_field1 )": 969}, {"MIN( decimal_field1 )": 624}, {"MIN( decimal_field1 )": 5085}, {"MIN( decimal_field1 )": 5314}, {"MIN( decimal_field1 )": 5391}, {"MIN( decimal_field1 )": 357}, {"MIN( decimal_field1 )": 6000}, {"MIN( decimal_field1 )": 5858}, {"MIN( decimal_field1 )": 328}, {"MIN( decimal_field1 )": 5632}, {"MIN( decimal_field1 )": 2636}, {"MIN( decimal_field1 )": 6435}, {"MIN( decimal_field1 )": 4949}, {"MIN( decimal_field1 )": 7230}, {"MIN( decimal_field1 )": 2048}, {"MIN( decimal_field1 )": 344}, {"MIN( decimal_field1 )": 5580}, {"MIN( decimal_field1 )": 8603}, {"MIN( decimal_field1 )": 8289}, {"MIN( decimal_field1 )": 9299}, {"MIN( decimal_field1 )": 8554}, {"MIN( decimal_field1 )": 5684}, {"MIN( decimal_field1 )": 134}, {"MIN( decimal_field1 )": 6985}, {"MIN( decimal_field1 )": 7693}, {"MIN( decimal_field1 )": 1969}, {"MIN( decimal_field1 )": 3692}, {"MIN( decimal_field1 )": 4786}, {"MIN( decimal_field1 )": 5885}, {"MIN( decimal_field1 )": 1850}, {"MIN( decimal_field1 )": 2029}, {"MIN( decimal_field1 )": 8917}, {"MIN( decimal_field1 )": 9919}, {"MIN( decimal_field1 )": 7728}, {"MIN( decimal_field1 )": 6039}, {"MIN( decimal_field1 )": 5741}, {"MIN( decimal_field1 )": 6245}, {"MIN( decimal_field1 )": 4518}, {"MIN( decimal_field1 )": 6420}, {"MIN( decimal_field1 )": 6968}, {"MIN( decimal_field1 )": 7969}, {"MIN( decimal_field1 )": 3429}, {"MIN( decimal_field1 )": 8613}, {"MIN( decimal_field1 )": 1673}, {"MIN( decimal_field1 )": 5616}, {"MIN( decimal_field1 )": 7755}, {"MIN( decimal_field1 )": 6674}, {"MIN( decimal_field1 )": 8379}, {"MIN( decimal_field1 )": 2239}, {"MIN( decimal_field1 )": 9898}, {"MIN( decimal_field1 )": 1504}, {"MIN( decimal_field1 )": 7039}, {"MIN( decimal_field1 )": 3313}, {"MIN( decimal_field1 )": 8570}, {"MIN( decimal_field1 )": 973}, {"MIN( decimal_field1 )": 1089}, {"MIN( decimal_field1 )": 8308}, {"MIN( decimal_field1 )": 5370}, {"MIN( decimal_field1 )": 7140}, {"MIN( decimal_field1 )": 6156}, {"MIN( decimal_field1 )": 9666}, {"MIN( decimal_field1 )": 1625}, {"MIN( decimal_field1 )": 9483}, {"MIN( decimal_field1 )": 3205}, {"MIN( decimal_field1 )": 9386}, {"MIN( decimal_field1 )": 3552}, {"MIN( decimal_field1 )": 7524}, {"MIN( decimal_field1 )": 563}, {"MIN( decimal_field1 )": 2046}, {"MIN( decimal_field1 )": 8615}, {"MIN( decimal_field1 )": 4443}, {"MIN( decimal_field1 )": 6019}, {"MIN( decimal_field1 )": 2446}, {"MIN( decimal_field1 )": 7940}, {"MIN( decimal_field1 )": 5918}, {"MIN( decimal_field1 )": 771}, {"MIN( decimal_field1 )": 1934}, {"MIN( decimal_field1 )": 5050}, {"MIN( decimal_field1 )": 3966}, {"MIN( decimal_field1 )": 1779}, {"MIN( decimal_field1 )": 426}, {"MIN( decimal_field1 )": 2232}, {"MIN( decimal_field1 )": 5797}, {"MIN( decimal_field1 )": 9036}, {"MIN( decimal_field1 )": 9135}, {"MIN( decimal_field1 )": 4411}, {"MIN( decimal_field1 )": 1220}, {"MIN( decimal_field1 )": 6596}, {"MIN( decimal_field1 )": 7884}, {"MIN( decimal_field1 )": 5327}, {"MIN( decimal_field1 )": 7411}, {"MIN( decimal_field1 )": 6017}, {"MIN( decimal_field1 )": 9493}, {"MIN( decimal_field1 )": 6658}, {"MIN( decimal_field1 )": 5197}, {"MIN( decimal_field1 )": 542}, {"MIN( decimal_field1 )": 9625}, {"MIN( decimal_field1 )": 3696}, {"MIN( decimal_field1 )": 8889}, {"MIN( decimal_field1 )": 7251}, {"MIN( decimal_field1 )": 3182}, {"MIN( decimal_field1 )": 58}, {"MIN( decimal_field1 )": 1658}, {"MIN( decimal_field1 )": 5281}, {"MIN( decimal_field1 )": 7108}, {"MIN( decimal_field1 )": 747}, {"MIN( decimal_field1 )": 4631}, {"MIN( decimal_field1 )": 9414}, {"MIN( decimal_field1 )": 7440}, {"MIN( decimal_field1 )": 5765}, {"MIN( decimal_field1 )": 8797}, {"MIN( decimal_field1 )": 6313}, {"MIN( decimal_field1 )": 814}, {"MIN( decimal_field1 )": 5674}, {"MIN( decimal_field1 )": 9579}, {"MIN( decimal_field1 )": 5952}, {"MIN( decimal_field1 )": 2304}, {"MIN( decimal_field1 )": 5677}, {"MIN( decimal_field1 )": 8262}, {"MIN( decimal_field1 )": 1212}, {"MIN( decimal_field1 )": 8002}, {"MIN( decimal_field1 )": 4586}, {"MIN( decimal_field1 )": 3268}, {"MIN( decimal_field1 )": 3097}, {"MIN( decimal_field1 )": 9618}, {"MIN( decimal_field1 )": 3309}, {"MIN( decimal_field1 )": 8368}, {"MIN( decimal_field1 )": 8246}, {"MIN( decimal_field1 )": 1639}, {"MIN( decimal_field1 )": 2658}, {"MIN( decimal_field1 )": 3169}, {"MIN( decimal_field1 )": 7749}, {"MIN( decimal_field1 )": 1384}, {"MIN( decimal_field1 )": 889}, {"MIN( decimal_field1 )": 9835}, {"MIN( decimal_field1 )": 8806}, {"MIN( decimal_field1 )": 2591}, {"MIN( decimal_field1 )": 8465}, {"MIN( decimal_field1 )": 3967}, {"MIN( decimal_field1 )": 2418}, {"MIN( decimal_field1 )": 1769}, {"MIN( decimal_field1 )": 6992}, {"MIN( decimal_field1 )": 4688}, {"MIN( decimal_field1 )": 896}, {"MIN( decimal_field1 )": 1071}, {"MIN( decimal_field1 )": 1845}, {"MIN( decimal_field1 )": 9457}, {"MIN( decimal_field1 )": 8175}, {"MIN( decimal_field1 )": 1712}, {"MIN( decimal_field1 )": 9016}, {"MIN( decimal_field1 )": 2419}, {"MIN( decimal_field1 )": 5693}, {"MIN( decimal_field1 )": 4461}, {"MIN( decimal_field1 )": 6786}, {"MIN( decimal_field1 )": 3816}, {"MIN( decimal_field1 )": 9578}, {"MIN( decimal_field1 )": 3772}, {"MIN( decimal_field1 )": 348}, {"MIN( decimal_field1 )": 2383}, {"MIN( decimal_field1 )": 2455}, {"MIN( decimal_field1 )": 751}, {"MIN( decimal_field1 )": 8369}, {"MIN( decimal_field1 )": 3215}, {"MIN( decimal_field1 )": 5545}, {"MIN( decimal_field1 )": 5083}, {"MIN( decimal_field1 )": 1010}, {"MIN( decimal_field1 )": 4303}, {"MIN( decimal_field1 )": 6803}, {"MIN( decimal_field1 )": 7920}, {"MIN( decimal_field1 )": 8841}, {"MIN( decimal_field1 )": 7080}, {"MIN( decimal_field1 )": 4904}, {"MIN( decimal_field1 )": 77}, {"MIN( decimal_field1 )": 2175}, {"MIN( decimal_field1 )": 5330}, {"MIN( decimal_field1 )": 1543}, {"MIN( decimal_field1 )": 8789}, {"MIN( decimal_field1 )": 2431}, {"MIN( decimal_field1 )": 1729}, {"MIN( decimal_field1 )": 2450}, {"MIN( decimal_field1 )": 5728}, {"MIN( decimal_field1 )": 279}, {"MIN( decimal_field1 )": 9963}, {"MIN( decimal_field1 )": 2688}, {"MIN( decimal_field1 )": 8551}, {"MIN( decimal_field1 )": 9540}, {"MIN( decimal_field1 )": 1684}, {"MIN( decimal_field1 )": 7180}, {"MIN( decimal_field1 )": 7080}, {"MIN( decimal_field1 )": 2670}, {"MIN( decimal_field1 )": 8932}, {"MIN( decimal_field1 )": 699}, {"MIN( decimal_field1 )": 9629}, {"MIN( decimal_field1 )": 4666}, {"MIN( decimal_field1 )": 9778}, {"MIN( decimal_field1 )": 5181}, {"MIN( decimal_field1 )": 323}, {"MIN( decimal_field1 )": 2892}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT MIN( decimal_field1 ) FROM simple_table_1 WHERE NOT (((decimal_field1 = 4849) AND ((decimal_field1 > 4849) OR (int_field1 <= 4760)) AND char_field1 <= \"N\" AND bool_field1)) GROUP BY primary_key_id , varchar_field1 "} {"n1ql": "SELECT AVG( DISTINCT int_field1 ) FROM simple_table_1 WHERE NOT ((primary_key_id = \"549\" AND int_field1 >= 4760)) GROUP BY int_field1 , decimal_field1 ", "expected_result": [{"AVG( DISTINCT int_field1 )": 9}, {"AVG( DISTINCT int_field1 )": 29}, {"AVG( DISTINCT int_field1 )": 37}, {"AVG( DISTINCT int_field1 )": 44}, {"AVG( DISTINCT int_field1 )": 50}, {"AVG( DISTINCT int_field1 )": 52}, {"AVG( DISTINCT int_field1 )": 55}, {"AVG( DISTINCT int_field1 )": 58}, {"AVG( DISTINCT int_field1 )": 60}, {"AVG( DISTINCT int_field1 )": 65}, {"AVG( DISTINCT int_field1 )": 101}, {"AVG( DISTINCT int_field1 )": 104}, {"AVG( DISTINCT int_field1 )": 108}, {"AVG( DISTINCT int_field1 )": 133}, {"AVG( DISTINCT int_field1 )": 161}, {"AVG( DISTINCT int_field1 )": 177}, {"AVG( DISTINCT int_field1 )": 181}, {"AVG( DISTINCT int_field1 )": 195}, {"AVG( DISTINCT int_field1 )": 200}, {"AVG( DISTINCT int_field1 )": 205}, {"AVG( DISTINCT int_field1 )": 228}, {"AVG( DISTINCT int_field1 )": 234}, {"AVG( DISTINCT int_field1 )": 248}, {"AVG( DISTINCT int_field1 )": 261}, {"AVG( DISTINCT int_field1 )": 270}, {"AVG( DISTINCT int_field1 )": 277}, {"AVG( DISTINCT int_field1 )": 292}, {"AVG( DISTINCT int_field1 )": 301}, {"AVG( DISTINCT int_field1 )": 301}, {"AVG( DISTINCT int_field1 )": 319}, {"AVG( DISTINCT int_field1 )": 325}, {"AVG( DISTINCT int_field1 )": 326}, {"AVG( DISTINCT int_field1 )": 326}, {"AVG( DISTINCT int_field1 )": 332}, {"AVG( DISTINCT int_field1 )": 338}, {"AVG( DISTINCT int_field1 )": 343}, {"AVG( DISTINCT int_field1 )": 353}, {"AVG( DISTINCT int_field1 )": 364}, {"AVG( DISTINCT int_field1 )": 364}, {"AVG( DISTINCT int_field1 )": 369}, {"AVG( DISTINCT int_field1 )": 376}, {"AVG( DISTINCT int_field1 )": 390}, {"AVG( DISTINCT int_field1 )": 411}, {"AVG( DISTINCT int_field1 )": 413}, {"AVG( DISTINCT int_field1 )": 422}, {"AVG( DISTINCT int_field1 )": 450}, {"AVG( DISTINCT int_field1 )": 467}, {"AVG( DISTINCT int_field1 )": 468}, {"AVG( DISTINCT int_field1 )": 487}, {"AVG( DISTINCT int_field1 )": 505}, {"AVG( DISTINCT int_field1 )": 506}, {"AVG( DISTINCT int_field1 )": 516}, {"AVG( DISTINCT int_field1 )": 517}, {"AVG( DISTINCT int_field1 )": 530}, {"AVG( DISTINCT int_field1 )": 535}, {"AVG( DISTINCT int_field1 )": 543}, {"AVG( DISTINCT int_field1 )": 553}, {"AVG( DISTINCT int_field1 )": 555}, {"AVG( DISTINCT int_field1 )": 556}, {"AVG( DISTINCT int_field1 )": 566}, {"AVG( DISTINCT int_field1 )": 583}, {"AVG( DISTINCT int_field1 )": 586}, {"AVG( DISTINCT int_field1 )": 597}, {"AVG( DISTINCT int_field1 )": 599}, {"AVG( DISTINCT int_field1 )": 619}, {"AVG( DISTINCT int_field1 )": 621}, {"AVG( DISTINCT int_field1 )": 622}, {"AVG( DISTINCT int_field1 )": 625}, {"AVG( DISTINCT int_field1 )": 628}, {"AVG( DISTINCT int_field1 )": 680}, {"AVG( DISTINCT int_field1 )": 683}, {"AVG( DISTINCT int_field1 )": 700}, {"AVG( DISTINCT int_field1 )": 715}, {"AVG( DISTINCT int_field1 )": 721}, {"AVG( DISTINCT int_field1 )": 722}, {"AVG( DISTINCT int_field1 )": 723}, {"AVG( DISTINCT int_field1 )": 732}, {"AVG( DISTINCT int_field1 )": 734}, {"AVG( DISTINCT int_field1 )": 752}, {"AVG( DISTINCT int_field1 )": 759}, {"AVG( DISTINCT int_field1 )": 761}, {"AVG( DISTINCT int_field1 )": 762}, {"AVG( DISTINCT int_field1 )": 764}, {"AVG( DISTINCT int_field1 )": 777}, {"AVG( DISTINCT int_field1 )": 779}, {"AVG( DISTINCT int_field1 )": 782}, {"AVG( DISTINCT int_field1 )": 793}, {"AVG( DISTINCT int_field1 )": 797}, {"AVG( DISTINCT int_field1 )": 797}, {"AVG( DISTINCT int_field1 )": 811}, {"AVG( DISTINCT int_field1 )": 820}, {"AVG( DISTINCT int_field1 )": 821}, {"AVG( DISTINCT int_field1 )": 821}, {"AVG( DISTINCT int_field1 )": 821}, {"AVG( DISTINCT int_field1 )": 833}, {"AVG( DISTINCT int_field1 )": 835}, {"AVG( DISTINCT int_field1 )": 836}, {"AVG( DISTINCT int_field1 )": 847}, {"AVG( DISTINCT int_field1 )": 851}, {"AVG( DISTINCT int_field1 )": 869}, {"AVG( DISTINCT int_field1 )": 869}, {"AVG( DISTINCT int_field1 )": 874}, {"AVG( DISTINCT int_field1 )": 898}, {"AVG( DISTINCT int_field1 )": 907}, {"AVG( DISTINCT int_field1 )": 910}, {"AVG( DISTINCT int_field1 )": 927}, {"AVG( DISTINCT int_field1 )": 927}, {"AVG( DISTINCT int_field1 )": 931}, {"AVG( DISTINCT int_field1 )": 947}, {"AVG( DISTINCT int_field1 )": 966}, {"AVG( DISTINCT int_field1 )": 986}, {"AVG( DISTINCT int_field1 )": 989}, {"AVG( DISTINCT int_field1 )": 1008}, {"AVG( DISTINCT int_field1 )": 1015}, {"AVG( DISTINCT int_field1 )": 1016}, {"AVG( DISTINCT int_field1 )": 1035}, {"AVG( DISTINCT int_field1 )": 1062}, {"AVG( DISTINCT int_field1 )": 1079}, {"AVG( DISTINCT int_field1 )": 1086}, {"AVG( DISTINCT int_field1 )": 1091}, {"AVG( DISTINCT int_field1 )": 1102}, {"AVG( DISTINCT int_field1 )": 1113}, {"AVG( DISTINCT int_field1 )": 1115}, {"AVG( DISTINCT int_field1 )": 1117}, {"AVG( DISTINCT int_field1 )": 1119}, {"AVG( DISTINCT int_field1 )": 1141}, {"AVG( DISTINCT int_field1 )": 1174}, {"AVG( DISTINCT int_field1 )": 1175}, {"AVG( DISTINCT int_field1 )": 1183}, {"AVG( DISTINCT int_field1 )": 1185}, {"AVG( DISTINCT int_field1 )": 1188}, {"AVG( DISTINCT int_field1 )": 1214}, {"AVG( DISTINCT int_field1 )": 1249}, {"AVG( DISTINCT int_field1 )": 1275}, {"AVG( DISTINCT int_field1 )": 1332}, {"AVG( DISTINCT int_field1 )": 1333}, {"AVG( DISTINCT int_field1 )": 1343}, {"AVG( DISTINCT int_field1 )": 1343}, {"AVG( DISTINCT int_field1 )": 1350}, {"AVG( DISTINCT int_field1 )": 1354}, {"AVG( DISTINCT int_field1 )": 1355}, {"AVG( DISTINCT int_field1 )": 1361}, {"AVG( DISTINCT int_field1 )": 1366}, {"AVG( DISTINCT int_field1 )": 1385}, {"AVG( DISTINCT int_field1 )": 1391}, {"AVG( DISTINCT int_field1 )": 1395}, {"AVG( DISTINCT int_field1 )": 1407}, {"AVG( DISTINCT int_field1 )": 1407}, {"AVG( DISTINCT int_field1 )": 1411}, {"AVG( DISTINCT int_field1 )": 1414}, {"AVG( DISTINCT int_field1 )": 1423}, {"AVG( DISTINCT int_field1 )": 1427}, {"AVG( DISTINCT int_field1 )": 1434}, {"AVG( DISTINCT int_field1 )": 1451}, {"AVG( DISTINCT int_field1 )": 1456}, {"AVG( DISTINCT int_field1 )": 1456}, {"AVG( DISTINCT int_field1 )": 1458}, {"AVG( DISTINCT int_field1 )": 1460}, {"AVG( DISTINCT int_field1 )": 1463}, {"AVG( DISTINCT int_field1 )": 1479}, {"AVG( DISTINCT int_field1 )": 1488}, {"AVG( DISTINCT int_field1 )": 1491}, {"AVG( DISTINCT int_field1 )": 1492}, {"AVG( DISTINCT int_field1 )": 1501}, {"AVG( DISTINCT int_field1 )": 1510}, {"AVG( DISTINCT int_field1 )": 1521}, {"AVG( DISTINCT int_field1 )": 1524}, {"AVG( DISTINCT int_field1 )": 1531}, {"AVG( DISTINCT int_field1 )": 1535}, {"AVG( DISTINCT int_field1 )": 1535}, {"AVG( DISTINCT int_field1 )": 1543}, {"AVG( DISTINCT int_field1 )": 1552}, {"AVG( DISTINCT int_field1 )": 1560}, {"AVG( DISTINCT int_field1 )": 1574}, {"AVG( DISTINCT int_field1 )": 1578}, {"AVG( DISTINCT int_field1 )": 1581}, {"AVG( DISTINCT int_field1 )": 1584}, {"AVG( DISTINCT int_field1 )": 1647}, {"AVG( DISTINCT int_field1 )": 1658}, {"AVG( DISTINCT int_field1 )": 1671}, {"AVG( DISTINCT int_field1 )": 1673}, {"AVG( DISTINCT int_field1 )": 1679}, {"AVG( DISTINCT int_field1 )": 1680}, {"AVG( DISTINCT int_field1 )": 1682}, {"AVG( DISTINCT int_field1 )": 1685}, {"AVG( DISTINCT int_field1 )": 1716}, {"AVG( DISTINCT int_field1 )": 1720}, {"AVG( DISTINCT int_field1 )": 1722}, {"AVG( DISTINCT int_field1 )": 1741}, {"AVG( DISTINCT int_field1 )": 1741}, {"AVG( DISTINCT int_field1 )": 1755}, {"AVG( DISTINCT int_field1 )": 1757}, {"AVG( DISTINCT int_field1 )": 1757}, {"AVG( DISTINCT int_field1 )": 1779}, {"AVG( DISTINCT int_field1 )": 1792}, {"AVG( DISTINCT int_field1 )": 1794}, {"AVG( DISTINCT int_field1 )": 1797}, {"AVG( DISTINCT int_field1 )": 1803}, {"AVG( DISTINCT int_field1 )": 1812}, {"AVG( DISTINCT int_field1 )": 1814}, {"AVG( DISTINCT int_field1 )": 1819}, {"AVG( DISTINCT int_field1 )": 1835}, {"AVG( DISTINCT int_field1 )": 1877}, {"AVG( DISTINCT int_field1 )": 1877}, {"AVG( DISTINCT int_field1 )": 1911}, {"AVG( DISTINCT int_field1 )": 1937}, {"AVG( DISTINCT int_field1 )": 1940}, {"AVG( DISTINCT int_field1 )": 1944}, {"AVG( DISTINCT int_field1 )": 1960}, {"AVG( DISTINCT int_field1 )": 1961}, {"AVG( DISTINCT int_field1 )": 1971}, {"AVG( DISTINCT int_field1 )": 1973}, {"AVG( DISTINCT int_field1 )": 1980}, {"AVG( DISTINCT int_field1 )": 1980}, {"AVG( DISTINCT int_field1 )": 1981}, {"AVG( DISTINCT int_field1 )": 1985}, {"AVG( DISTINCT int_field1 )": 1989}, {"AVG( DISTINCT int_field1 )": 2018}, {"AVG( DISTINCT int_field1 )": 2028}, {"AVG( DISTINCT int_field1 )": 2033}, {"AVG( DISTINCT int_field1 )": 2046}, {"AVG( DISTINCT int_field1 )": 2047}, {"AVG( DISTINCT int_field1 )": 2066}, {"AVG( DISTINCT int_field1 )": 2078}, {"AVG( DISTINCT int_field1 )": 2089}, {"AVG( DISTINCT int_field1 )": 2108}, {"AVG( DISTINCT int_field1 )": 2109}, {"AVG( DISTINCT int_field1 )": 2118}, {"AVG( DISTINCT int_field1 )": 2122}, {"AVG( DISTINCT int_field1 )": 2124}, {"AVG( DISTINCT int_field1 )": 2131}, {"AVG( DISTINCT int_field1 )": 2132}, {"AVG( DISTINCT int_field1 )": 2149}, {"AVG( DISTINCT int_field1 )": 2155}, {"AVG( DISTINCT int_field1 )": 2155}, {"AVG( DISTINCT int_field1 )": 2168}, {"AVG( DISTINCT int_field1 )": 2175}, {"AVG( DISTINCT int_field1 )": 2176}, {"AVG( DISTINCT int_field1 )": 2189}, {"AVG( DISTINCT int_field1 )": 2222}, {"AVG( DISTINCT int_field1 )": 2223}, {"AVG( DISTINCT int_field1 )": 2224}, {"AVG( DISTINCT int_field1 )": 2230}, {"AVG( DISTINCT int_field1 )": 2236}, {"AVG( DISTINCT int_field1 )": 2238}, {"AVG( DISTINCT int_field1 )": 2249}, {"AVG( DISTINCT int_field1 )": 2270}, {"AVG( DISTINCT int_field1 )": 2272}, {"AVG( DISTINCT int_field1 )": 2273}, {"AVG( DISTINCT int_field1 )": 2288}, {"AVG( DISTINCT int_field1 )": 2289}, {"AVG( DISTINCT int_field1 )": 2290}, {"AVG( DISTINCT int_field1 )": 2291}, {"AVG( DISTINCT int_field1 )": 2293}, {"AVG( DISTINCT int_field1 )": 2306}, {"AVG( DISTINCT int_field1 )": 2340}, {"AVG( DISTINCT int_field1 )": 2354}, {"AVG( DISTINCT int_field1 )": 2371}, {"AVG( DISTINCT int_field1 )": 2383}, {"AVG( DISTINCT int_field1 )": 2387}, {"AVG( DISTINCT int_field1 )": 2395}, {"AVG( DISTINCT int_field1 )": 2397}, {"AVG( DISTINCT int_field1 )": 2397}, {"AVG( DISTINCT int_field1 )": 2399}, {"AVG( DISTINCT int_field1 )": 2428}, {"AVG( DISTINCT int_field1 )": 2430}, {"AVG( DISTINCT int_field1 )": 2445}, {"AVG( DISTINCT int_field1 )": 2445}, {"AVG( DISTINCT int_field1 )": 2447}, {"AVG( DISTINCT int_field1 )": 2485}, {"AVG( DISTINCT int_field1 )": 2488}, {"AVG( DISTINCT int_field1 )": 2493}, {"AVG( DISTINCT int_field1 )": 2503}, {"AVG( DISTINCT int_field1 )": 2504}, {"AVG( DISTINCT int_field1 )": 2506}, {"AVG( DISTINCT int_field1 )": 2509}, {"AVG( DISTINCT int_field1 )": 2542}, {"AVG( DISTINCT int_field1 )": 2549}, {"AVG( DISTINCT int_field1 )": 2555}, {"AVG( DISTINCT int_field1 )": 2558}, {"AVG( DISTINCT int_field1 )": 2566}, {"AVG( DISTINCT int_field1 )": 2592}, {"AVG( DISTINCT int_field1 )": 2594}, {"AVG( DISTINCT int_field1 )": 2600}, {"AVG( DISTINCT int_field1 )": 2620}, {"AVG( DISTINCT int_field1 )": 2635}, {"AVG( DISTINCT int_field1 )": 2637}, {"AVG( DISTINCT int_field1 )": 2637}, {"AVG( DISTINCT int_field1 )": 2643}, {"AVG( DISTINCT int_field1 )": 2650}, {"AVG( DISTINCT int_field1 )": 2651}, {"AVG( DISTINCT int_field1 )": 2655}, {"AVG( DISTINCT int_field1 )": 2661}, {"AVG( DISTINCT int_field1 )": 2665}, {"AVG( DISTINCT int_field1 )": 2665}, {"AVG( DISTINCT int_field1 )": 2677}, {"AVG( DISTINCT int_field1 )": 2693}, {"AVG( DISTINCT int_field1 )": 2727}, {"AVG( DISTINCT int_field1 )": 2740}, {"AVG( DISTINCT int_field1 )": 2758}, {"AVG( DISTINCT int_field1 )": 2759}, {"AVG( DISTINCT int_field1 )": 2760}, {"AVG( DISTINCT int_field1 )": 2769}, {"AVG( DISTINCT int_field1 )": 2783}, {"AVG( DISTINCT int_field1 )": 2789}, {"AVG( DISTINCT int_field1 )": 2797}, {"AVG( DISTINCT int_field1 )": 2800}, {"AVG( DISTINCT int_field1 )": 2879}, {"AVG( DISTINCT int_field1 )": 2900}, {"AVG( DISTINCT int_field1 )": 2920}, {"AVG( DISTINCT int_field1 )": 2937}, {"AVG( DISTINCT int_field1 )": 2947}, {"AVG( DISTINCT int_field1 )": 2959}, {"AVG( DISTINCT int_field1 )": 2968}, {"AVG( DISTINCT int_field1 )": 2976}, {"AVG( DISTINCT int_field1 )": 2977}, {"AVG( DISTINCT int_field1 )": 2978}, {"AVG( DISTINCT int_field1 )": 2999}, {"AVG( DISTINCT int_field1 )": 3019}, {"AVG( DISTINCT int_field1 )": 3026}, {"AVG( DISTINCT int_field1 )": 3029}, {"AVG( DISTINCT int_field1 )": 3036}, {"AVG( DISTINCT int_field1 )": 3048}, {"AVG( DISTINCT int_field1 )": 3056}, {"AVG( DISTINCT int_field1 )": 3064}, {"AVG( DISTINCT int_field1 )": 3094}, {"AVG( DISTINCT int_field1 )": 3096}, {"AVG( DISTINCT int_field1 )": 3096}, {"AVG( DISTINCT int_field1 )": 3097}, {"AVG( DISTINCT int_field1 )": 3107}, {"AVG( DISTINCT int_field1 )": 3108}, {"AVG( DISTINCT int_field1 )": 3114}, {"AVG( DISTINCT int_field1 )": 3128}, {"AVG( DISTINCT int_field1 )": 3129}, {"AVG( DISTINCT int_field1 )": 3137}, {"AVG( DISTINCT int_field1 )": 3143}, {"AVG( DISTINCT int_field1 )": 3144}, {"AVG( DISTINCT int_field1 )": 3144}, {"AVG( DISTINCT int_field1 )": 3148}, {"AVG( DISTINCT int_field1 )": 3152}, {"AVG( DISTINCT int_field1 )": 3154}, {"AVG( DISTINCT int_field1 )": 3155}, {"AVG( DISTINCT int_field1 )": 3170}, {"AVG( DISTINCT int_field1 )": 3171}, {"AVG( DISTINCT int_field1 )": 3173}, {"AVG( DISTINCT int_field1 )": 3177}, {"AVG( DISTINCT int_field1 )": 3191}, {"AVG( DISTINCT int_field1 )": 3201}, {"AVG( DISTINCT int_field1 )": 3216}, {"AVG( DISTINCT int_field1 )": 3219}, {"AVG( DISTINCT int_field1 )": 3237}, {"AVG( DISTINCT int_field1 )": 3240}, {"AVG( DISTINCT int_field1 )": 3259}, {"AVG( DISTINCT int_field1 )": 3259}, {"AVG( DISTINCT int_field1 )": 3261}, {"AVG( DISTINCT int_field1 )": 3288}, {"AVG( DISTINCT int_field1 )": 3358}, {"AVG( DISTINCT int_field1 )": 3364}, {"AVG( DISTINCT int_field1 )": 3369}, {"AVG( DISTINCT int_field1 )": 3380}, {"AVG( DISTINCT int_field1 )": 3380}, {"AVG( DISTINCT int_field1 )": 3391}, {"AVG( DISTINCT int_field1 )": 3393}, {"AVG( DISTINCT int_field1 )": 3403}, {"AVG( DISTINCT int_field1 )": 3406}, {"AVG( DISTINCT int_field1 )": 3416}, {"AVG( DISTINCT int_field1 )": 3433}, {"AVG( DISTINCT int_field1 )": 3439}, {"AVG( DISTINCT int_field1 )": 3445}, {"AVG( DISTINCT int_field1 )": 3448}, {"AVG( DISTINCT int_field1 )": 3452}, {"AVG( DISTINCT int_field1 )": 3459}, {"AVG( DISTINCT int_field1 )": 3460}, {"AVG( DISTINCT int_field1 )": 3461}, {"AVG( DISTINCT int_field1 )": 3463}, {"AVG( DISTINCT int_field1 )": 3483}, {"AVG( DISTINCT int_field1 )": 3486}, {"AVG( DISTINCT int_field1 )": 3516}, {"AVG( DISTINCT int_field1 )": 3525}, {"AVG( DISTINCT int_field1 )": 3536}, {"AVG( DISTINCT int_field1 )": 3549}, {"AVG( DISTINCT int_field1 )": 3557}, {"AVG( DISTINCT int_field1 )": 3559}, {"AVG( DISTINCT int_field1 )": 3567}, {"AVG( DISTINCT int_field1 )": 3580}, {"AVG( DISTINCT int_field1 )": 3589}, {"AVG( DISTINCT int_field1 )": 3593}, {"AVG( DISTINCT int_field1 )": 3605}, {"AVG( DISTINCT int_field1 )": 3621}, {"AVG( DISTINCT int_field1 )": 3633}, {"AVG( DISTINCT int_field1 )": 3670}, {"AVG( DISTINCT int_field1 )": 3675}, {"AVG( DISTINCT int_field1 )": 3681}, {"AVG( DISTINCT int_field1 )": 3691}, {"AVG( DISTINCT int_field1 )": 3703}, {"AVG( DISTINCT int_field1 )": 3707}, {"AVG( DISTINCT int_field1 )": 3709}, {"AVG( DISTINCT int_field1 )": 3720}, {"AVG( DISTINCT int_field1 )": 3737}, {"AVG( DISTINCT int_field1 )": 3745}, {"AVG( DISTINCT int_field1 )": 3746}, {"AVG( DISTINCT int_field1 )": 3756}, {"AVG( DISTINCT int_field1 )": 3764}, {"AVG( DISTINCT int_field1 )": 3776}, {"AVG( DISTINCT int_field1 )": 3791}, {"AVG( DISTINCT int_field1 )": 3794}, {"AVG( DISTINCT int_field1 )": 3799}, {"AVG( DISTINCT int_field1 )": 3800}, {"AVG( DISTINCT int_field1 )": 3813}, {"AVG( DISTINCT int_field1 )": 3828}, {"AVG( DISTINCT int_field1 )": 3829}, {"AVG( DISTINCT int_field1 )": 3831}, {"AVG( DISTINCT int_field1 )": 3866}, {"AVG( DISTINCT int_field1 )": 3868}, {"AVG( DISTINCT int_field1 )": 3870}, {"AVG( DISTINCT int_field1 )": 3873}, {"AVG( DISTINCT int_field1 )": 3878}, {"AVG( DISTINCT int_field1 )": 3881}, {"AVG( DISTINCT int_field1 )": 3882}, {"AVG( DISTINCT int_field1 )": 3892}, {"AVG( DISTINCT int_field1 )": 3902}, {"AVG( DISTINCT int_field1 )": 3906}, {"AVG( DISTINCT int_field1 )": 3908}, {"AVG( DISTINCT int_field1 )": 3913}, {"AVG( DISTINCT int_field1 )": 3914}, {"AVG( DISTINCT int_field1 )": 3924}, {"AVG( DISTINCT int_field1 )": 3936}, {"AVG( DISTINCT int_field1 )": 3941}, {"AVG( DISTINCT int_field1 )": 3951}, {"AVG( DISTINCT int_field1 )": 3956}, {"AVG( DISTINCT int_field1 )": 3959}, {"AVG( DISTINCT int_field1 )": 3980}, {"AVG( DISTINCT int_field1 )": 3981}, {"AVG( DISTINCT int_field1 )": 3985}, {"AVG( DISTINCT int_field1 )": 3991}, {"AVG( DISTINCT int_field1 )": 4002}, {"AVG( DISTINCT int_field1 )": 4017}, {"AVG( DISTINCT int_field1 )": 4042}, {"AVG( DISTINCT int_field1 )": 4043}, {"AVG( DISTINCT int_field1 )": 4045}, {"AVG( DISTINCT int_field1 )": 4048}, {"AVG( DISTINCT int_field1 )": 4054}, {"AVG( DISTINCT int_field1 )": 4060}, {"AVG( DISTINCT int_field1 )": 4065}, {"AVG( DISTINCT int_field1 )": 4089}, {"AVG( DISTINCT int_field1 )": 4094}, {"AVG( DISTINCT int_field1 )": 4097}, {"AVG( DISTINCT int_field1 )": 4100}, {"AVG( DISTINCT int_field1 )": 4115}, {"AVG( DISTINCT int_field1 )": 4121}, {"AVG( DISTINCT int_field1 )": 4128}, {"AVG( DISTINCT int_field1 )": 4128}, {"AVG( DISTINCT int_field1 )": 4153}, {"AVG( DISTINCT int_field1 )": 4162}, {"AVG( DISTINCT int_field1 )": 4170}, {"AVG( DISTINCT int_field1 )": 4190}, {"AVG( DISTINCT int_field1 )": 4209}, {"AVG( DISTINCT int_field1 )": 4212}, {"AVG( DISTINCT int_field1 )": 4237}, {"AVG( DISTINCT int_field1 )": 4240}, {"AVG( DISTINCT int_field1 )": 4258}, {"AVG( DISTINCT int_field1 )": 4260}, {"AVG( DISTINCT int_field1 )": 4262}, {"AVG( DISTINCT int_field1 )": 4283}, {"AVG( DISTINCT int_field1 )": 4286}, {"AVG( DISTINCT int_field1 )": 4325}, {"AVG( DISTINCT int_field1 )": 4333}, {"AVG( DISTINCT int_field1 )": 4336}, {"AVG( DISTINCT int_field1 )": 4345}, {"AVG( DISTINCT int_field1 )": 4398}, {"AVG( DISTINCT int_field1 )": 4404}, {"AVG( DISTINCT int_field1 )": 4417}, {"AVG( DISTINCT int_field1 )": 4451}, {"AVG( DISTINCT int_field1 )": 4467}, {"AVG( DISTINCT int_field1 )": 4468}, {"AVG( DISTINCT int_field1 )": 4485}, {"AVG( DISTINCT int_field1 )": 4505}, {"AVG( DISTINCT int_field1 )": 4532}, {"AVG( DISTINCT int_field1 )": 4538}, {"AVG( DISTINCT int_field1 )": 4564}, {"AVG( DISTINCT int_field1 )": 4568}, {"AVG( DISTINCT int_field1 )": 4568}, {"AVG( DISTINCT int_field1 )": 4569}, {"AVG( DISTINCT int_field1 )": 4578}, {"AVG( DISTINCT int_field1 )": 4597}, {"AVG( DISTINCT int_field1 )": 4601}, {"AVG( DISTINCT int_field1 )": 4613}, {"AVG( DISTINCT int_field1 )": 4615}, {"AVG( DISTINCT int_field1 )": 4620}, {"AVG( DISTINCT int_field1 )": 4651}, {"AVG( DISTINCT int_field1 )": 4658}, {"AVG( DISTINCT int_field1 )": 4672}, {"AVG( DISTINCT int_field1 )": 4680}, {"AVG( DISTINCT int_field1 )": 4684}, {"AVG( DISTINCT int_field1 )": 4686}, {"AVG( DISTINCT int_field1 )": 4726}, {"AVG( DISTINCT int_field1 )": 4728}, {"AVG( DISTINCT int_field1 )": 4748}, {"AVG( DISTINCT int_field1 )": 4760}, {"AVG( DISTINCT int_field1 )": 4770}, {"AVG( DISTINCT int_field1 )": 4776}, {"AVG( DISTINCT int_field1 )": 4786}, {"AVG( DISTINCT int_field1 )": 4790}, {"AVG( DISTINCT int_field1 )": 4795}, {"AVG( DISTINCT int_field1 )": 4810}, {"AVG( DISTINCT int_field1 )": 4816}, {"AVG( DISTINCT int_field1 )": 4833}, {"AVG( DISTINCT int_field1 )": 4835}, {"AVG( DISTINCT int_field1 )": 4841}, {"AVG( DISTINCT int_field1 )": 4842}, {"AVG( DISTINCT int_field1 )": 4854}, {"AVG( DISTINCT int_field1 )": 4866}, {"AVG( DISTINCT int_field1 )": 4879}, {"AVG( DISTINCT int_field1 )": 4889}, {"AVG( DISTINCT int_field1 )": 4908}, {"AVG( DISTINCT int_field1 )": 4909}, {"AVG( DISTINCT int_field1 )": 4920}, {"AVG( DISTINCT int_field1 )": 4921}, {"AVG( DISTINCT int_field1 )": 4959}, {"AVG( DISTINCT int_field1 )": 4962}, {"AVG( DISTINCT int_field1 )": 4966}, {"AVG( DISTINCT int_field1 )": 4967}, {"AVG( DISTINCT int_field1 )": 4996}, {"AVG( DISTINCT int_field1 )": 5004}, {"AVG( DISTINCT int_field1 )": 5021}, {"AVG( DISTINCT int_field1 )": 5041}, {"AVG( DISTINCT int_field1 )": 5042}, {"AVG( DISTINCT int_field1 )": 5055}, {"AVG( DISTINCT int_field1 )": 5068}, {"AVG( DISTINCT int_field1 )": 5095}, {"AVG( DISTINCT int_field1 )": 5109}, {"AVG( DISTINCT int_field1 )": 5115}, {"AVG( DISTINCT int_field1 )": 5119}, {"AVG( DISTINCT int_field1 )": 5131}, {"AVG( DISTINCT int_field1 )": 5133}, {"AVG( DISTINCT int_field1 )": 5138}, {"AVG( DISTINCT int_field1 )": 5152}, {"AVG( DISTINCT int_field1 )": 5174}, {"AVG( DISTINCT int_field1 )": 5193}, {"AVG( DISTINCT int_field1 )": 5215}, {"AVG( DISTINCT int_field1 )": 5222}, {"AVG( DISTINCT int_field1 )": 5231}, {"AVG( DISTINCT int_field1 )": 5237}, {"AVG( DISTINCT int_field1 )": 5253}, {"AVG( DISTINCT int_field1 )": 5257}, {"AVG( DISTINCT int_field1 )": 5263}, {"AVG( DISTINCT int_field1 )": 5263}, {"AVG( DISTINCT int_field1 )": 5267}, {"AVG( DISTINCT int_field1 )": 5267}, {"AVG( DISTINCT int_field1 )": 5272}, {"AVG( DISTINCT int_field1 )": 5273}, {"AVG( DISTINCT int_field1 )": 5278}, {"AVG( DISTINCT int_field1 )": 5282}, {"AVG( DISTINCT int_field1 )": 5285}, {"AVG( DISTINCT int_field1 )": 5289}, {"AVG( DISTINCT int_field1 )": 5289}, {"AVG( DISTINCT int_field1 )": 5291}, {"AVG( DISTINCT int_field1 )": 5303}, {"AVG( DISTINCT int_field1 )": 5307}, {"AVG( DISTINCT int_field1 )": 5320}, {"AVG( DISTINCT int_field1 )": 5323}, {"AVG( DISTINCT int_field1 )": 5326}, {"AVG( DISTINCT int_field1 )": 5328}, {"AVG( DISTINCT int_field1 )": 5338}, {"AVG( DISTINCT int_field1 )": 5378}, {"AVG( DISTINCT int_field1 )": 5399}, {"AVG( DISTINCT int_field1 )": 5402}, {"AVG( DISTINCT int_field1 )": 5406}, {"AVG( DISTINCT int_field1 )": 5406}, {"AVG( DISTINCT int_field1 )": 5418}, {"AVG( DISTINCT int_field1 )": 5435}, {"AVG( DISTINCT int_field1 )": 5436}, {"AVG( DISTINCT int_field1 )": 5461}, {"AVG( DISTINCT int_field1 )": 5467}, {"AVG( DISTINCT int_field1 )": 5468}, {"AVG( DISTINCT int_field1 )": 5488}, {"AVG( DISTINCT int_field1 )": 5508}, {"AVG( DISTINCT int_field1 )": 5510}, {"AVG( DISTINCT int_field1 )": 5545}, {"AVG( DISTINCT int_field1 )": 5545}, {"AVG( DISTINCT int_field1 )": 5548}, {"AVG( DISTINCT int_field1 )": 5549}, {"AVG( DISTINCT int_field1 )": 5568}, {"AVG( DISTINCT int_field1 )": 5575}, {"AVG( DISTINCT int_field1 )": 5599}, {"AVG( DISTINCT int_field1 )": 5619}, {"AVG( DISTINCT int_field1 )": 5626}, {"AVG( DISTINCT int_field1 )": 5638}, {"AVG( DISTINCT int_field1 )": 5658}, {"AVG( DISTINCT int_field1 )": 5670}, {"AVG( DISTINCT int_field1 )": 5673}, {"AVG( DISTINCT int_field1 )": 5676}, {"AVG( DISTINCT int_field1 )": 5677}, {"AVG( DISTINCT int_field1 )": 5679}, {"AVG( DISTINCT int_field1 )": 5681}, {"AVG( DISTINCT int_field1 )": 5689}, {"AVG( DISTINCT int_field1 )": 5690}, {"AVG( DISTINCT int_field1 )": 5696}, {"AVG( DISTINCT int_field1 )": 5700}, {"AVG( DISTINCT int_field1 )": 5704}, {"AVG( DISTINCT int_field1 )": 5705}, {"AVG( DISTINCT int_field1 )": 5711}, {"AVG( DISTINCT int_field1 )": 5720}, {"AVG( DISTINCT int_field1 )": 5725}, {"AVG( DISTINCT int_field1 )": 5728}, {"AVG( DISTINCT int_field1 )": 5734}, {"AVG( DISTINCT int_field1 )": 5737}, {"AVG( DISTINCT int_field1 )": 5750}, {"AVG( DISTINCT int_field1 )": 5759}, {"AVG( DISTINCT int_field1 )": 5762}, {"AVG( DISTINCT int_field1 )": 5775}, {"AVG( DISTINCT int_field1 )": 5777}, {"AVG( DISTINCT int_field1 )": 5790}, {"AVG( DISTINCT int_field1 )": 5794}, {"AVG( DISTINCT int_field1 )": 5796}, {"AVG( DISTINCT int_field1 )": 5798}, {"AVG( DISTINCT int_field1 )": 5819}, {"AVG( DISTINCT int_field1 )": 5819}, {"AVG( DISTINCT int_field1 )": 5829}, {"AVG( DISTINCT int_field1 )": 5834}, {"AVG( DISTINCT int_field1 )": 5836}, {"AVG( DISTINCT int_field1 )": 5851}, {"AVG( DISTINCT int_field1 )": 5854}, {"AVG( DISTINCT int_field1 )": 5859}, {"AVG( DISTINCT int_field1 )": 5892}, {"AVG( DISTINCT int_field1 )": 5900}, {"AVG( DISTINCT int_field1 )": 5903}, {"AVG( DISTINCT int_field1 )": 5904}, {"AVG( DISTINCT int_field1 )": 5905}, {"AVG( DISTINCT int_field1 )": 5907}, {"AVG( DISTINCT int_field1 )": 5930}, {"AVG( DISTINCT int_field1 )": 5934}, {"AVG( DISTINCT int_field1 )": 5942}, {"AVG( DISTINCT int_field1 )": 5947}, {"AVG( DISTINCT int_field1 )": 5956}, {"AVG( DISTINCT int_field1 )": 5965}, {"AVG( DISTINCT int_field1 )": 5977}, {"AVG( DISTINCT int_field1 )": 5985}, {"AVG( DISTINCT int_field1 )": 5988}, {"AVG( DISTINCT int_field1 )": 5993}, {"AVG( DISTINCT int_field1 )": 5997}, {"AVG( DISTINCT int_field1 )": 6000}, {"AVG( DISTINCT int_field1 )": 6001}, {"AVG( DISTINCT int_field1 )": 6004}, {"AVG( DISTINCT int_field1 )": 6005}, {"AVG( DISTINCT int_field1 )": 6016}, {"AVG( DISTINCT int_field1 )": 6017}, {"AVG( DISTINCT int_field1 )": 6028}, {"AVG( DISTINCT int_field1 )": 6055}, {"AVG( DISTINCT int_field1 )": 6105}, {"AVG( DISTINCT int_field1 )": 6107}, {"AVG( DISTINCT int_field1 )": 6119}, {"AVG( DISTINCT int_field1 )": 6152}, {"AVG( DISTINCT int_field1 )": 6178}, {"AVG( DISTINCT int_field1 )": 6178}, {"AVG( DISTINCT int_field1 )": 6180}, {"AVG( DISTINCT int_field1 )": 6187}, {"AVG( DISTINCT int_field1 )": 6189}, {"AVG( DISTINCT int_field1 )": 6197}, {"AVG( DISTINCT int_field1 )": 6200}, {"AVG( DISTINCT int_field1 )": 6210}, {"AVG( DISTINCT int_field1 )": 6215}, {"AVG( DISTINCT int_field1 )": 6235}, {"AVG( DISTINCT int_field1 )": 6238}, {"AVG( DISTINCT int_field1 )": 6240}, {"AVG( DISTINCT int_field1 )": 6248}, {"AVG( DISTINCT int_field1 )": 6249}, {"AVG( DISTINCT int_field1 )": 6251}, {"AVG( DISTINCT int_field1 )": 6256}, {"AVG( DISTINCT int_field1 )": 6276}, {"AVG( DISTINCT int_field1 )": 6281}, {"AVG( DISTINCT int_field1 )": 6281}, {"AVG( DISTINCT int_field1 )": 6304}, {"AVG( DISTINCT int_field1 )": 6328}, {"AVG( DISTINCT int_field1 )": 6331}, {"AVG( DISTINCT int_field1 )": 6369}, {"AVG( DISTINCT int_field1 )": 6374}, {"AVG( DISTINCT int_field1 )": 6384}, {"AVG( DISTINCT int_field1 )": 6412}, {"AVG( DISTINCT int_field1 )": 6413}, {"AVG( DISTINCT int_field1 )": 6424}, {"AVG( DISTINCT int_field1 )": 6428}, {"AVG( DISTINCT int_field1 )": 6453}, {"AVG( DISTINCT int_field1 )": 6464}, {"AVG( DISTINCT int_field1 )": 6470}, {"AVG( DISTINCT int_field1 )": 6483}, {"AVG( DISTINCT int_field1 )": 6489}, {"AVG( DISTINCT int_field1 )": 6494}, {"AVG( DISTINCT int_field1 )": 6510}, {"AVG( DISTINCT int_field1 )": 6511}, {"AVG( DISTINCT int_field1 )": 6522}, {"AVG( DISTINCT int_field1 )": 6526}, {"AVG( DISTINCT int_field1 )": 6527}, {"AVG( DISTINCT int_field1 )": 6534}, {"AVG( DISTINCT int_field1 )": 6536}, {"AVG( DISTINCT int_field1 )": 6565}, {"AVG( DISTINCT int_field1 )": 6568}, {"AVG( DISTINCT int_field1 )": 6578}, {"AVG( DISTINCT int_field1 )": 6584}, {"AVG( DISTINCT int_field1 )": 6587}, {"AVG( DISTINCT int_field1 )": 6593}, {"AVG( DISTINCT int_field1 )": 6623}, {"AVG( DISTINCT int_field1 )": 6623}, {"AVG( DISTINCT int_field1 )": 6650}, {"AVG( DISTINCT int_field1 )": 6652}, {"AVG( DISTINCT int_field1 )": 6654}, {"AVG( DISTINCT int_field1 )": 6660}, {"AVG( DISTINCT int_field1 )": 6663}, {"AVG( DISTINCT int_field1 )": 6664}, {"AVG( DISTINCT int_field1 )": 6665}, {"AVG( DISTINCT int_field1 )": 6671}, {"AVG( DISTINCT int_field1 )": 6676}, {"AVG( DISTINCT int_field1 )": 6690}, {"AVG( DISTINCT int_field1 )": 6734}, {"AVG( DISTINCT int_field1 )": 6735}, {"AVG( DISTINCT int_field1 )": 6741}, {"AVG( DISTINCT int_field1 )": 6753}, {"AVG( DISTINCT int_field1 )": 6762}, {"AVG( DISTINCT int_field1 )": 6792}, {"AVG( DISTINCT int_field1 )": 6795}, {"AVG( DISTINCT int_field1 )": 6817}, {"AVG( DISTINCT int_field1 )": 6828}, {"AVG( DISTINCT int_field1 )": 6829}, {"AVG( DISTINCT int_field1 )": 6840}, {"AVG( DISTINCT int_field1 )": 6851}, {"AVG( DISTINCT int_field1 )": 6855}, {"AVG( DISTINCT int_field1 )": 6867}, {"AVG( DISTINCT int_field1 )": 6872}, {"AVG( DISTINCT int_field1 )": 6880}, {"AVG( DISTINCT int_field1 )": 6885}, {"AVG( DISTINCT int_field1 )": 6892}, {"AVG( DISTINCT int_field1 )": 6894}, {"AVG( DISTINCT int_field1 )": 6904}, {"AVG( DISTINCT int_field1 )": 6918}, {"AVG( DISTINCT int_field1 )": 6922}, {"AVG( DISTINCT int_field1 )": 6964}, {"AVG( DISTINCT int_field1 )": 6991}, {"AVG( DISTINCT int_field1 )": 7006}, {"AVG( DISTINCT int_field1 )": 7012}, {"AVG( DISTINCT int_field1 )": 7028}, {"AVG( DISTINCT int_field1 )": 7029}, {"AVG( DISTINCT int_field1 )": 7036}, {"AVG( DISTINCT int_field1 )": 7056}, {"AVG( DISTINCT int_field1 )": 7068}, {"AVG( DISTINCT int_field1 )": 7078}, {"AVG( DISTINCT int_field1 )": 7081}, {"AVG( DISTINCT int_field1 )": 7092}, {"AVG( DISTINCT int_field1 )": 7095}, {"AVG( DISTINCT int_field1 )": 7098}, {"AVG( DISTINCT int_field1 )": 7110}, {"AVG( DISTINCT int_field1 )": 7127}, {"AVG( DISTINCT int_field1 )": 7127}, {"AVG( DISTINCT int_field1 )": 7128}, {"AVG( DISTINCT int_field1 )": 7143}, {"AVG( DISTINCT int_field1 )": 7149}, {"AVG( DISTINCT int_field1 )": 7152}, {"AVG( DISTINCT int_field1 )": 7162}, {"AVG( DISTINCT int_field1 )": 7165}, {"AVG( DISTINCT int_field1 )": 7192}, {"AVG( DISTINCT int_field1 )": 7195}, {"AVG( DISTINCT int_field1 )": 7206}, {"AVG( DISTINCT int_field1 )": 7207}, {"AVG( DISTINCT int_field1 )": 7223}, {"AVG( DISTINCT int_field1 )": 7230}, {"AVG( DISTINCT int_field1 )": 7233}, {"AVG( DISTINCT int_field1 )": 7256}, {"AVG( DISTINCT int_field1 )": 7261}, {"AVG( DISTINCT int_field1 )": 7266}, {"AVG( DISTINCT int_field1 )": 7270}, {"AVG( DISTINCT int_field1 )": 7276}, {"AVG( DISTINCT int_field1 )": 7278}, {"AVG( DISTINCT int_field1 )": 7281}, {"AVG( DISTINCT int_field1 )": 7281}, {"AVG( DISTINCT int_field1 )": 7312}, {"AVG( DISTINCT int_field1 )": 7321}, {"AVG( DISTINCT int_field1 )": 7323}, {"AVG( DISTINCT int_field1 )": 7330}, {"AVG( DISTINCT int_field1 )": 7330}, {"AVG( DISTINCT int_field1 )": 7335}, {"AVG( DISTINCT int_field1 )": 7336}, {"AVG( DISTINCT int_field1 )": 7340}, {"AVG( DISTINCT int_field1 )": 7360}, {"AVG( DISTINCT int_field1 )": 7363}, {"AVG( DISTINCT int_field1 )": 7364}, {"AVG( DISTINCT int_field1 )": 7370}, {"AVG( DISTINCT int_field1 )": 7373}, {"AVG( DISTINCT int_field1 )": 7387}, {"AVG( DISTINCT int_field1 )": 7396}, {"AVG( DISTINCT int_field1 )": 7423}, {"AVG( DISTINCT int_field1 )": 7437}, {"AVG( DISTINCT int_field1 )": 7456}, {"AVG( DISTINCT int_field1 )": 7465}, {"AVG( DISTINCT int_field1 )": 7483}, {"AVG( DISTINCT int_field1 )": 7517}, {"AVG( DISTINCT int_field1 )": 7517}, {"AVG( DISTINCT int_field1 )": 7542}, {"AVG( DISTINCT int_field1 )": 7549}, {"AVG( DISTINCT int_field1 )": 7564}, {"AVG( DISTINCT int_field1 )": 7594}, {"AVG( DISTINCT int_field1 )": 7603}, {"AVG( DISTINCT int_field1 )": 7612}, {"AVG( DISTINCT int_field1 )": 7614}, {"AVG( DISTINCT int_field1 )": 7623}, {"AVG( DISTINCT int_field1 )": 7658}, {"AVG( DISTINCT int_field1 )": 7687}, {"AVG( DISTINCT int_field1 )": 7688}, {"AVG( DISTINCT int_field1 )": 7697}, {"AVG( DISTINCT int_field1 )": 7698}, {"AVG( DISTINCT int_field1 )": 7706}, {"AVG( DISTINCT int_field1 )": 7709}, {"AVG( DISTINCT int_field1 )": 7710}, {"AVG( DISTINCT int_field1 )": 7734}, {"AVG( DISTINCT int_field1 )": 7742}, {"AVG( DISTINCT int_field1 )": 7776}, {"AVG( DISTINCT int_field1 )": 7789}, {"AVG( DISTINCT int_field1 )": 7789}, {"AVG( DISTINCT int_field1 )": 7790}, {"AVG( DISTINCT int_field1 )": 7791}, {"AVG( DISTINCT int_field1 )": 7799}, {"AVG( DISTINCT int_field1 )": 7817}, {"AVG( DISTINCT int_field1 )": 7823}, {"AVG( DISTINCT int_field1 )": 7823}, {"AVG( DISTINCT int_field1 )": 7823}, {"AVG( DISTINCT int_field1 )": 7831}, {"AVG( DISTINCT int_field1 )": 7855}, {"AVG( DISTINCT int_field1 )": 7874}, {"AVG( DISTINCT int_field1 )": 7884}, {"AVG( DISTINCT int_field1 )": 7891}, {"AVG( DISTINCT int_field1 )": 7933}, {"AVG( DISTINCT int_field1 )": 7940}, {"AVG( DISTINCT int_field1 )": 7949}, {"AVG( DISTINCT int_field1 )": 7963}, {"AVG( DISTINCT int_field1 )": 7963}, {"AVG( DISTINCT int_field1 )": 7972}, {"AVG( DISTINCT int_field1 )": 7983}, {"AVG( DISTINCT int_field1 )": 7999}, {"AVG( DISTINCT int_field1 )": 8029}, {"AVG( DISTINCT int_field1 )": 8069}, {"AVG( DISTINCT int_field1 )": 8076}, {"AVG( DISTINCT int_field1 )": 8086}, {"AVG( DISTINCT int_field1 )": 8101}, {"AVG( DISTINCT int_field1 )": 8126}, {"AVG( DISTINCT int_field1 )": 8129}, {"AVG( DISTINCT int_field1 )": 8137}, {"AVG( DISTINCT int_field1 )": 8141}, {"AVG( DISTINCT int_field1 )": 8171}, {"AVG( DISTINCT int_field1 )": 8180}, {"AVG( DISTINCT int_field1 )": 8183}, {"AVG( DISTINCT int_field1 )": 8205}, {"AVG( DISTINCT int_field1 )": 8218}, {"AVG( DISTINCT int_field1 )": 8220}, {"AVG( DISTINCT int_field1 )": 8252}, {"AVG( DISTINCT int_field1 )": 8272}, {"AVG( DISTINCT int_field1 )": 8283}, {"AVG( DISTINCT int_field1 )": 8290}, {"AVG( DISTINCT int_field1 )": 8292}, {"AVG( DISTINCT int_field1 )": 8306}, {"AVG( DISTINCT int_field1 )": 8306}, {"AVG( DISTINCT int_field1 )": 8326}, {"AVG( DISTINCT int_field1 )": 8342}, {"AVG( DISTINCT int_field1 )": 8362}, {"AVG( DISTINCT int_field1 )": 8376}, {"AVG( DISTINCT int_field1 )": 8387}, {"AVG( DISTINCT int_field1 )": 8446}, {"AVG( DISTINCT int_field1 )": 8455}, {"AVG( DISTINCT int_field1 )": 8465}, {"AVG( DISTINCT int_field1 )": 8467}, {"AVG( DISTINCT int_field1 )": 8475}, {"AVG( DISTINCT int_field1 )": 8482}, {"AVG( DISTINCT int_field1 )": 8519}, {"AVG( DISTINCT int_field1 )": 8528}, {"AVG( DISTINCT int_field1 )": 8540}, {"AVG( DISTINCT int_field1 )": 8555}, {"AVG( DISTINCT int_field1 )": 8556}, {"AVG( DISTINCT int_field1 )": 8570}, {"AVG( DISTINCT int_field1 )": 8580}, {"AVG( DISTINCT int_field1 )": 8584}, {"AVG( DISTINCT int_field1 )": 8589}, {"AVG( DISTINCT int_field1 )": 8620}, {"AVG( DISTINCT int_field1 )": 8620}, {"AVG( DISTINCT int_field1 )": 8621}, {"AVG( DISTINCT int_field1 )": 8627}, {"AVG( DISTINCT int_field1 )": 8628}, {"AVG( DISTINCT int_field1 )": 8629}, {"AVG( DISTINCT int_field1 )": 8635}, {"AVG( DISTINCT int_field1 )": 8638}, {"AVG( DISTINCT int_field1 )": 8651}, {"AVG( DISTINCT int_field1 )": 8662}, {"AVG( DISTINCT int_field1 )": 8665}, {"AVG( DISTINCT int_field1 )": 8665}, {"AVG( DISTINCT int_field1 )": 8666}, {"AVG( DISTINCT int_field1 )": 8705}, {"AVG( DISTINCT int_field1 )": 8707}, {"AVG( DISTINCT int_field1 )": 8710}, {"AVG( DISTINCT int_field1 )": 8718}, {"AVG( DISTINCT int_field1 )": 8728}, {"AVG( DISTINCT int_field1 )": 8729}, {"AVG( DISTINCT int_field1 )": 8755}, {"AVG( DISTINCT int_field1 )": 8757}, {"AVG( DISTINCT int_field1 )": 8790}, {"AVG( DISTINCT int_field1 )": 8792}, {"AVG( DISTINCT int_field1 )": 8808}, {"AVG( DISTINCT int_field1 )": 8819}, {"AVG( DISTINCT int_field1 )": 8827}, {"AVG( DISTINCT int_field1 )": 8853}, {"AVG( DISTINCT int_field1 )": 8860}, {"AVG( DISTINCT int_field1 )": 8860}, {"AVG( DISTINCT int_field1 )": 8871}, {"AVG( DISTINCT int_field1 )": 8877}, {"AVG( DISTINCT int_field1 )": 8877}, {"AVG( DISTINCT int_field1 )": 8877}, {"AVG( DISTINCT int_field1 )": 8907}, {"AVG( DISTINCT int_field1 )": 8911}, {"AVG( DISTINCT int_field1 )": 8911}, {"AVG( DISTINCT int_field1 )": 8912}, {"AVG( DISTINCT int_field1 )": 8933}, {"AVG( DISTINCT int_field1 )": 8937}, {"AVG( DISTINCT int_field1 )": 8945}, {"AVG( DISTINCT int_field1 )": 8978}, {"AVG( DISTINCT int_field1 )": 8978}, {"AVG( DISTINCT int_field1 )": 8988}, {"AVG( DISTINCT int_field1 )": 9005}, {"AVG( DISTINCT int_field1 )": 9051}, {"AVG( DISTINCT int_field1 )": 9057}, {"AVG( DISTINCT int_field1 )": 9061}, {"AVG( DISTINCT int_field1 )": 9074}, {"AVG( DISTINCT int_field1 )": 9091}, {"AVG( DISTINCT int_field1 )": 9100}, {"AVG( DISTINCT int_field1 )": 9101}, {"AVG( DISTINCT int_field1 )": 9112}, {"AVG( DISTINCT int_field1 )": 9189}, {"AVG( DISTINCT int_field1 )": 9217}, {"AVG( DISTINCT int_field1 )": 9241}, {"AVG( DISTINCT int_field1 )": 9249}, {"AVG( DISTINCT int_field1 )": 9252}, {"AVG( DISTINCT int_field1 )": 9271}, {"AVG( DISTINCT int_field1 )": 9293}, {"AVG( DISTINCT int_field1 )": 9293}, {"AVG( DISTINCT int_field1 )": 9297}, {"AVG( DISTINCT int_field1 )": 9314}, {"AVG( DISTINCT int_field1 )": 9329}, {"AVG( DISTINCT int_field1 )": 9331}, {"AVG( DISTINCT int_field1 )": 9381}, {"AVG( DISTINCT int_field1 )": 9416}, {"AVG( DISTINCT int_field1 )": 9422}, {"AVG( DISTINCT int_field1 )": 9428}, {"AVG( DISTINCT int_field1 )": 9432}, {"AVG( DISTINCT int_field1 )": 9435}, {"AVG( DISTINCT int_field1 )": 9451}, {"AVG( DISTINCT int_field1 )": 9451}, {"AVG( DISTINCT int_field1 )": 9479}, {"AVG( DISTINCT int_field1 )": 9485}, {"AVG( DISTINCT int_field1 )": 9496}, {"AVG( DISTINCT int_field1 )": 9499}, {"AVG( DISTINCT int_field1 )": 9520}, {"AVG( DISTINCT int_field1 )": 9532}, {"AVG( DISTINCT int_field1 )": 9542}, {"AVG( DISTINCT int_field1 )": 9543}, {"AVG( DISTINCT int_field1 )": 9544}, {"AVG( DISTINCT int_field1 )": 9545}, {"AVG( DISTINCT int_field1 )": 9593}, {"AVG( DISTINCT int_field1 )": 9593}, {"AVG( DISTINCT int_field1 )": 9599}, {"AVG( DISTINCT int_field1 )": 9601}, {"AVG( DISTINCT int_field1 )": 9604}, {"AVG( DISTINCT int_field1 )": 9607}, {"AVG( DISTINCT int_field1 )": 9611}, {"AVG( DISTINCT int_field1 )": 9618}, {"AVG( DISTINCT int_field1 )": 9636}, {"AVG( DISTINCT int_field1 )": 9654}, {"AVG( DISTINCT int_field1 )": 9659}, {"AVG( DISTINCT int_field1 )": 9668}, {"AVG( DISTINCT int_field1 )": 9670}, {"AVG( DISTINCT int_field1 )": 9677}, {"AVG( DISTINCT int_field1 )": 9717}, {"AVG( DISTINCT int_field1 )": 9722}, {"AVG( DISTINCT int_field1 )": 9730}, {"AVG( DISTINCT int_field1 )": 9754}, {"AVG( DISTINCT int_field1 )": 9755}, {"AVG( DISTINCT int_field1 )": 9797}, {"AVG( DISTINCT int_field1 )": 9805}, {"AVG( DISTINCT int_field1 )": 9812}, {"AVG( DISTINCT int_field1 )": 9867}, {"AVG( DISTINCT int_field1 )": 9871}, {"AVG( DISTINCT int_field1 )": 9883}, {"AVG( DISTINCT int_field1 )": 9896}, {"AVG( DISTINCT int_field1 )": 9898}, {"AVG( DISTINCT int_field1 )": 9906}, {"AVG( DISTINCT int_field1 )": 9936}, {"AVG( DISTINCT int_field1 )": 9937}, {"AVG( DISTINCT int_field1 )": 9941}, {"AVG( DISTINCT int_field1 )": 9950}, {"AVG( DISTINCT int_field1 )": 9950}, {"AVG( DISTINCT int_field1 )": 9952}, {"AVG( DISTINCT int_field1 )": 9957}, {"AVG( DISTINCT int_field1 )": 9957}, {"AVG( DISTINCT int_field1 )": 9964}, {"AVG( DISTINCT int_field1 )": 9974}, {"AVG( DISTINCT int_field1 )": 9981}, {"AVG( DISTINCT int_field1 )": 9992}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT AVG( DISTINCT int_field1 ) FROM simple_table_1 WHERE NOT ((primary_key_id = \"549\" AND int_field1 >= 4760)) GROUP BY int_field1 , decimal_field1 "} {"n1ql": "SELECT MIN( decimal_field1 ) FROM simple_table_10 WHERE ((NOT (bool_field1) OR varchar_field1 < \"ZWjEXagolJ\")) AND (decimal_field1 != 5082) OR ((bool_field1 OR decimal_field1 IS NULL)) AND ((NOT (bool_field1) OR int_field1 IS NULL)) GROUP BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 , bool_field1 ", "expected_result": [{"MIN( decimal_field1 )": 7218}, {"MIN( decimal_field1 )": 4353}, {"MIN( decimal_field1 )": 7802}, {"MIN( decimal_field1 )": 1641}, {"MIN( decimal_field1 )": 7452}, {"MIN( decimal_field1 )": 9934}, {"MIN( decimal_field1 )": 844}, {"MIN( decimal_field1 )": 7714}, {"MIN( decimal_field1 )": 5624}, {"MIN( decimal_field1 )": 5099}, {"MIN( decimal_field1 )": 62}, {"MIN( decimal_field1 )": 4719}, {"MIN( decimal_field1 )": 7372}, {"MIN( decimal_field1 )": 5185}, {"MIN( decimal_field1 )": 6774}, {"MIN( decimal_field1 )": 3587}, {"MIN( decimal_field1 )": 6951}, {"MIN( decimal_field1 )": 9352}, {"MIN( decimal_field1 )": 516}, {"MIN( decimal_field1 )": 9165}, {"MIN( decimal_field1 )": 7274}, {"MIN( decimal_field1 )": 7053}, {"MIN( decimal_field1 )": 470}, {"MIN( decimal_field1 )": 5742}, {"MIN( decimal_field1 )": 8862}, {"MIN( decimal_field1 )": 6752}, {"MIN( decimal_field1 )": 1087}, {"MIN( decimal_field1 )": 599}, {"MIN( decimal_field1 )": 9721}, {"MIN( decimal_field1 )": 2517}, {"MIN( decimal_field1 )": 3037}, {"MIN( decimal_field1 )": 7798}, {"MIN( decimal_field1 )": 6222}, {"MIN( decimal_field1 )": 1766}, {"MIN( decimal_field1 )": 6519}, {"MIN( decimal_field1 )": 5232}, {"MIN( decimal_field1 )": 3538}, {"MIN( decimal_field1 )": 5247}, {"MIN( decimal_field1 )": 1795}, {"MIN( decimal_field1 )": 6048}, {"MIN( decimal_field1 )": 9224}, {"MIN( decimal_field1 )": 3542}, {"MIN( decimal_field1 )": 7720}, {"MIN( decimal_field1 )": 2664}, {"MIN( decimal_field1 )": 1801}, {"MIN( decimal_field1 )": 6881}, {"MIN( decimal_field1 )": 2364}, {"MIN( decimal_field1 )": 9008}, {"MIN( decimal_field1 )": 9881}, {"MIN( decimal_field1 )": 4308}, {"MIN( decimal_field1 )": 2839}, {"MIN( decimal_field1 )": 4193}, {"MIN( decimal_field1 )": 9448}, {"MIN( decimal_field1 )": 858}, {"MIN( decimal_field1 )": 9139}, {"MIN( decimal_field1 )": 1966}, {"MIN( decimal_field1 )": 4338}, {"MIN( decimal_field1 )": 9891}, {"MIN( decimal_field1 )": 8791}, {"MIN( decimal_field1 )": 9392}, {"MIN( decimal_field1 )": 4724}, {"MIN( decimal_field1 )": 7445}, {"MIN( decimal_field1 )": 8045}, {"MIN( decimal_field1 )": 7149}, {"MIN( decimal_field1 )": 1874}, {"MIN( decimal_field1 )": 8647}, {"MIN( decimal_field1 )": 4616}, {"MIN( decimal_field1 )": 9476}, {"MIN( decimal_field1 )": 8453}, {"MIN( decimal_field1 )": 6250}, {"MIN( decimal_field1 )": 5220}, {"MIN( decimal_field1 )": 8542}, {"MIN( decimal_field1 )": 2508}, {"MIN( decimal_field1 )": 1819}, {"MIN( decimal_field1 )": 4062}, {"MIN( decimal_field1 )": 3996}, {"MIN( decimal_field1 )": 6835}, {"MIN( decimal_field1 )": 5934}, {"MIN( decimal_field1 )": 5773}, {"MIN( decimal_field1 )": 2140}, {"MIN( decimal_field1 )": 2849}, {"MIN( decimal_field1 )": 5367}, {"MIN( decimal_field1 )": 5892}, {"MIN( decimal_field1 )": 7909}, {"MIN( decimal_field1 )": 4743}, {"MIN( decimal_field1 )": 6817}, {"MIN( decimal_field1 )": 686}, {"MIN( decimal_field1 )": 2051}, {"MIN( decimal_field1 )": 177}, {"MIN( decimal_field1 )": 7991}, {"MIN( decimal_field1 )": 8553}, {"MIN( decimal_field1 )": 3765}, {"MIN( decimal_field1 )": 5204}, {"MIN( decimal_field1 )": 3404}, {"MIN( decimal_field1 )": 3347}, {"MIN( decimal_field1 )": 8920}, {"MIN( decimal_field1 )": 9631}, {"MIN( decimal_field1 )": 4512}, {"MIN( decimal_field1 )": 4598}, {"MIN( decimal_field1 )": 1583}, {"MIN( decimal_field1 )": 4544}, {"MIN( decimal_field1 )": 5162}, {"MIN( decimal_field1 )": 4542}, {"MIN( decimal_field1 )": 6767}, {"MIN( decimal_field1 )": 6185}, {"MIN( decimal_field1 )": 9212}, {"MIN( decimal_field1 )": 4339}, {"MIN( decimal_field1 )": 2014}, {"MIN( decimal_field1 )": 6993}, {"MIN( decimal_field1 )": 6028}, {"MIN( decimal_field1 )": 98}, {"MIN( decimal_field1 )": 5093}, {"MIN( decimal_field1 )": 3127}, {"MIN( decimal_field1 )": 9856}, {"MIN( decimal_field1 )": 8689}, {"MIN( decimal_field1 )": 558}, {"MIN( decimal_field1 )": 2427}, {"MIN( decimal_field1 )": 9457}, {"MIN( decimal_field1 )": 5497}, {"MIN( decimal_field1 )": 8034}, {"MIN( decimal_field1 )": 4580}, {"MIN( decimal_field1 )": 9427}, {"MIN( decimal_field1 )": 1378}, {"MIN( decimal_field1 )": 9684}, {"MIN( decimal_field1 )": 2855}, {"MIN( decimal_field1 )": 8483}, {"MIN( decimal_field1 )": 2097}, {"MIN( decimal_field1 )": 6781}, {"MIN( decimal_field1 )": 1241}, {"MIN( decimal_field1 )": 2287}, {"MIN( decimal_field1 )": 6616}, {"MIN( decimal_field1 )": 8685}, {"MIN( decimal_field1 )": 7215}, {"MIN( decimal_field1 )": 5376}, {"MIN( decimal_field1 )": 3932}, {"MIN( decimal_field1 )": 6119}, {"MIN( decimal_field1 )": 2298}, {"MIN( decimal_field1 )": 3335}, {"MIN( decimal_field1 )": 1129}, {"MIN( decimal_field1 )": 1592}, {"MIN( decimal_field1 )": 7106}, {"MIN( decimal_field1 )": 383}, {"MIN( decimal_field1 )": 8693}, {"MIN( decimal_field1 )": 9279}, {"MIN( decimal_field1 )": 4897}, {"MIN( decimal_field1 )": 6617}, {"MIN( decimal_field1 )": 3478}, {"MIN( decimal_field1 )": 1094}, {"MIN( decimal_field1 )": 5053}, {"MIN( decimal_field1 )": 7047}, {"MIN( decimal_field1 )": 7140}, {"MIN( decimal_field1 )": 8995}, {"MIN( decimal_field1 )": 1013}, {"MIN( decimal_field1 )": 9583}, {"MIN( decimal_field1 )": 2664}, {"MIN( decimal_field1 )": 6190}, {"MIN( decimal_field1 )": 3956}, {"MIN( decimal_field1 )": 4996}, {"MIN( decimal_field1 )": 3954}, {"MIN( decimal_field1 )": 7479}, {"MIN( decimal_field1 )": 1401}, {"MIN( decimal_field1 )": 3228}, {"MIN( decimal_field1 )": 1095}, {"MIN( decimal_field1 )": 8686}, {"MIN( decimal_field1 )": 5067}, {"MIN( decimal_field1 )": 541}, {"MIN( decimal_field1 )": 6047}, {"MIN( decimal_field1 )": 2513}, {"MIN( decimal_field1 )": 5002}, {"MIN( decimal_field1 )": 2399}, {"MIN( decimal_field1 )": 419}, {"MIN( decimal_field1 )": 171}, {"MIN( decimal_field1 )": 357}, {"MIN( decimal_field1 )": 153}, {"MIN( decimal_field1 )": 3140}, {"MIN( decimal_field1 )": 8766}, {"MIN( decimal_field1 )": 1639}, {"MIN( decimal_field1 )": 5019}, {"MIN( decimal_field1 )": 5373}, {"MIN( decimal_field1 )": 7065}, {"MIN( decimal_field1 )": 1259}, {"MIN( decimal_field1 )": 496}, {"MIN( decimal_field1 )": 4079}, {"MIN( decimal_field1 )": 5437}, {"MIN( decimal_field1 )": 5847}, {"MIN( decimal_field1 )": 8784}, {"MIN( decimal_field1 )": 2958}, {"MIN( decimal_field1 )": 6652}, {"MIN( decimal_field1 )": 6293}, {"MIN( decimal_field1 )": 6405}, {"MIN( decimal_field1 )": 1749}, {"MIN( decimal_field1 )": 1539}, {"MIN( decimal_field1 )": 9989}, {"MIN( decimal_field1 )": 7239}, {"MIN( decimal_field1 )": 1941}, {"MIN( decimal_field1 )": 3791}, {"MIN( decimal_field1 )": 2720}, {"MIN( decimal_field1 )": 3939}, {"MIN( decimal_field1 )": 8180}, {"MIN( decimal_field1 )": 1754}, {"MIN( decimal_field1 )": 4310}, {"MIN( decimal_field1 )": 7883}, {"MIN( decimal_field1 )": 5609}, {"MIN( decimal_field1 )": 5589}, {"MIN( decimal_field1 )": 7508}, {"MIN( decimal_field1 )": 1453}, {"MIN( decimal_field1 )": 5504}, {"MIN( decimal_field1 )": 2399}, {"MIN( decimal_field1 )": 1468}, {"MIN( decimal_field1 )": 9287}, {"MIN( decimal_field1 )": 839}, {"MIN( decimal_field1 )": 6235}, {"MIN( decimal_field1 )": 4076}, {"MIN( decimal_field1 )": 7644}, {"MIN( decimal_field1 )": 2573}, {"MIN( decimal_field1 )": 5434}, {"MIN( decimal_field1 )": 8938}, {"MIN( decimal_field1 )": 4659}, {"MIN( decimal_field1 )": 1619}, {"MIN( decimal_field1 )": 9884}, {"MIN( decimal_field1 )": 8129}, {"MIN( decimal_field1 )": 7010}, {"MIN( decimal_field1 )": 6584}, {"MIN( decimal_field1 )": 7648}, {"MIN( decimal_field1 )": 2642}, {"MIN( decimal_field1 )": 8428}, {"MIN( decimal_field1 )": 1329}, {"MIN( decimal_field1 )": 2146}, {"MIN( decimal_field1 )": 7247}, {"MIN( decimal_field1 )": 5411}, {"MIN( decimal_field1 )": 246}, {"MIN( decimal_field1 )": 5439}, {"MIN( decimal_field1 )": 4587}, {"MIN( decimal_field1 )": 8222}, {"MIN( decimal_field1 )": 2159}, {"MIN( decimal_field1 )": 2454}, {"MIN( decimal_field1 )": 2077}, {"MIN( decimal_field1 )": 2065}, {"MIN( decimal_field1 )": 4565}, {"MIN( decimal_field1 )": 2591}, {"MIN( decimal_field1 )": 5450}, {"MIN( decimal_field1 )": 1007}, {"MIN( decimal_field1 )": 8937}, {"MIN( decimal_field1 )": 5736}, {"MIN( decimal_field1 )": 2480}, {"MIN( decimal_field1 )": 5311}, {"MIN( decimal_field1 )": 3796}, {"MIN( decimal_field1 )": 7697}, {"MIN( decimal_field1 )": 1527}, {"MIN( decimal_field1 )": 5945}, {"MIN( decimal_field1 )": 4621}, {"MIN( decimal_field1 )": 9085}, {"MIN( decimal_field1 )": 5415}, {"MIN( decimal_field1 )": 8064}, {"MIN( decimal_field1 )": 5709}, {"MIN( decimal_field1 )": 8455}, {"MIN( decimal_field1 )": 475}, {"MIN( decimal_field1 )": 4118}, {"MIN( decimal_field1 )": 2847}, {"MIN( decimal_field1 )": 327}, {"MIN( decimal_field1 )": 4812}, {"MIN( decimal_field1 )": 2377}, {"MIN( decimal_field1 )": 9221}, {"MIN( decimal_field1 )": 9748}, {"MIN( decimal_field1 )": 4242}, {"MIN( decimal_field1 )": 3094}, {"MIN( decimal_field1 )": 4176}, {"MIN( decimal_field1 )": 710}, {"MIN( decimal_field1 )": 4912}, {"MIN( decimal_field1 )": 9964}, {"MIN( decimal_field1 )": 1074}, {"MIN( decimal_field1 )": 427}, {"MIN( decimal_field1 )": 3701}, {"MIN( decimal_field1 )": 8681}, {"MIN( decimal_field1 )": 2141}, {"MIN( decimal_field1 )": 8884}, {"MIN( decimal_field1 )": 9650}, {"MIN( decimal_field1 )": 8689}, {"MIN( decimal_field1 )": 9381}, {"MIN( decimal_field1 )": 3432}, {"MIN( decimal_field1 )": 4602}, {"MIN( decimal_field1 )": 9711}, {"MIN( decimal_field1 )": 2326}, {"MIN( decimal_field1 )": 2200}, {"MIN( decimal_field1 )": 4180}, {"MIN( decimal_field1 )": 4560}, {"MIN( decimal_field1 )": 7237}, {"MIN( decimal_field1 )": 4598}, {"MIN( decimal_field1 )": 7310}, {"MIN( decimal_field1 )": 4491}, {"MIN( decimal_field1 )": 4124}, {"MIN( decimal_field1 )": 7160}, {"MIN( decimal_field1 )": 389}, {"MIN( decimal_field1 )": 6022}, {"MIN( decimal_field1 )": 6193}, {"MIN( decimal_field1 )": 7005}, {"MIN( decimal_field1 )": 4012}, {"MIN( decimal_field1 )": 4111}, {"MIN( decimal_field1 )": 588}, {"MIN( decimal_field1 )": 2958}, {"MIN( decimal_field1 )": 7986}, {"MIN( decimal_field1 )": 7766}, {"MIN( decimal_field1 )": 6728}, {"MIN( decimal_field1 )": 6783}, {"MIN( decimal_field1 )": 179}, {"MIN( decimal_field1 )": 7677}, {"MIN( decimal_field1 )": 2530}, {"MIN( decimal_field1 )": 9808}, {"MIN( decimal_field1 )": 9570}, {"MIN( decimal_field1 )": 370}, {"MIN( decimal_field1 )": 917}, {"MIN( decimal_field1 )": 9528}, {"MIN( decimal_field1 )": 5907}, {"MIN( decimal_field1 )": 3604}, {"MIN( decimal_field1 )": 210}, {"MIN( decimal_field1 )": 619}, {"MIN( decimal_field1 )": 6933}, {"MIN( decimal_field1 )": 6407}, {"MIN( decimal_field1 )": 7432}, {"MIN( decimal_field1 )": 2082}, {"MIN( decimal_field1 )": 4173}, {"MIN( decimal_field1 )": 5006}, {"MIN( decimal_field1 )": 4573}, {"MIN( decimal_field1 )": 3200}, {"MIN( decimal_field1 )": 8386}, {"MIN( decimal_field1 )": 207}, {"MIN( decimal_field1 )": 6961}, {"MIN( decimal_field1 )": 839}, {"MIN( decimal_field1 )": 7156}, {"MIN( decimal_field1 )": 3339}, {"MIN( decimal_field1 )": 6422}, {"MIN( decimal_field1 )": 2330}, {"MIN( decimal_field1 )": 7316}, {"MIN( decimal_field1 )": 3621}, {"MIN( decimal_field1 )": 6661}, {"MIN( decimal_field1 )": 8685}, {"MIN( decimal_field1 )": 7598}, {"MIN( decimal_field1 )": 1010}, {"MIN( decimal_field1 )": 412}, {"MIN( decimal_field1 )": 5714}, {"MIN( decimal_field1 )": 9502}, {"MIN( decimal_field1 )": 7239}, {"MIN( decimal_field1 )": 54}, {"MIN( decimal_field1 )": 823}, {"MIN( decimal_field1 )": 8277}, {"MIN( decimal_field1 )": 3332}, {"MIN( decimal_field1 )": 9488}, {"MIN( decimal_field1 )": 2477}, {"MIN( decimal_field1 )": 6422}, {"MIN( decimal_field1 )": 638}, {"MIN( decimal_field1 )": 5407}, {"MIN( decimal_field1 )": 1533}, {"MIN( decimal_field1 )": 5571}, {"MIN( decimal_field1 )": 5104}, {"MIN( decimal_field1 )": 7596}, {"MIN( decimal_field1 )": 2639}, {"MIN( decimal_field1 )": 4339}, {"MIN( decimal_field1 )": 3675}, {"MIN( decimal_field1 )": 3492}, {"MIN( decimal_field1 )": 3518}, {"MIN( decimal_field1 )": 4752}, {"MIN( decimal_field1 )": 1689}, {"MIN( decimal_field1 )": 8577}, {"MIN( decimal_field1 )": 4421}, {"MIN( decimal_field1 )": 3473}, {"MIN( decimal_field1 )": 2006}, {"MIN( decimal_field1 )": 721}, {"MIN( decimal_field1 )": 3587}, {"MIN( decimal_field1 )": 230}, {"MIN( decimal_field1 )": 1044}, {"MIN( decimal_field1 )": 6728}, {"MIN( decimal_field1 )": 6263}, {"MIN( decimal_field1 )": 8833}, {"MIN( decimal_field1 )": 4002}, {"MIN( decimal_field1 )": 3101}, {"MIN( decimal_field1 )": 2885}, {"MIN( decimal_field1 )": 1823}, {"MIN( decimal_field1 )": 6276}, {"MIN( decimal_field1 )": 4121}, {"MIN( decimal_field1 )": 7979}, {"MIN( decimal_field1 )": 8436}, {"MIN( decimal_field1 )": 7794}, {"MIN( decimal_field1 )": 9266}, {"MIN( decimal_field1 )": 2356}, {"MIN( decimal_field1 )": 8572}, {"MIN( decimal_field1 )": 2309}, {"MIN( decimal_field1 )": 4576}, {"MIN( decimal_field1 )": 6533}, {"MIN( decimal_field1 )": 7730}, {"MIN( decimal_field1 )": 8372}, {"MIN( decimal_field1 )": 7117}, {"MIN( decimal_field1 )": 5620}, {"MIN( decimal_field1 )": 9766}, {"MIN( decimal_field1 )": 1240}, {"MIN( decimal_field1 )": 4811}, {"MIN( decimal_field1 )": 7927}, {"MIN( decimal_field1 )": 9676}, {"MIN( decimal_field1 )": 5073}, {"MIN( decimal_field1 )": 1282}, {"MIN( decimal_field1 )": 5177}, {"MIN( decimal_field1 )": 3311}, {"MIN( decimal_field1 )": 5110}, {"MIN( decimal_field1 )": 1740}, {"MIN( decimal_field1 )": 1032}, {"MIN( decimal_field1 )": 3391}, {"MIN( decimal_field1 )": 9735}, {"MIN( decimal_field1 )": 978}, {"MIN( decimal_field1 )": 2122}, {"MIN( decimal_field1 )": 4333}, {"MIN( decimal_field1 )": 5301}, {"MIN( decimal_field1 )": 7393}, {"MIN( decimal_field1 )": 8419}, {"MIN( decimal_field1 )": 1161}, {"MIN( decimal_field1 )": 5145}, {"MIN( decimal_field1 )": 7023}, {"MIN( decimal_field1 )": 3716}, {"MIN( decimal_field1 )": 7155}, {"MIN( decimal_field1 )": 327}, {"MIN( decimal_field1 )": 6764}, {"MIN( decimal_field1 )": 7192}, {"MIN( decimal_field1 )": 8560}, {"MIN( decimal_field1 )": 7020}, {"MIN( decimal_field1 )": 1202}, {"MIN( decimal_field1 )": 6754}, {"MIN( decimal_field1 )": 2709}, {"MIN( decimal_field1 )": 2131}, {"MIN( decimal_field1 )": 7597}, {"MIN( decimal_field1 )": 8773}, {"MIN( decimal_field1 )": 6151}, {"MIN( decimal_field1 )": 6133}, {"MIN( decimal_field1 )": 4515}, {"MIN( decimal_field1 )": 8571}, {"MIN( decimal_field1 )": 6062}, {"MIN( decimal_field1 )": 7655}, {"MIN( decimal_field1 )": 4307}, {"MIN( decimal_field1 )": 6888}, {"MIN( decimal_field1 )": 1044}, {"MIN( decimal_field1 )": 2039}, {"MIN( decimal_field1 )": 4778}, {"MIN( decimal_field1 )": 867}, {"MIN( decimal_field1 )": 1193}, {"MIN( decimal_field1 )": 3982}, {"MIN( decimal_field1 )": 2874}, {"MIN( decimal_field1 )": 8031}, {"MIN( decimal_field1 )": 8045}, {"MIN( decimal_field1 )": 453}, {"MIN( decimal_field1 )": 5703}, {"MIN( decimal_field1 )": 405}, {"MIN( decimal_field1 )": 513}, {"MIN( decimal_field1 )": 3}, {"MIN( decimal_field1 )": 6876}, {"MIN( decimal_field1 )": 3128}, {"MIN( decimal_field1 )": 3555}, {"MIN( decimal_field1 )": 5101}, {"MIN( decimal_field1 )": 257}, {"MIN( decimal_field1 )": 4197}, {"MIN( decimal_field1 )": 8850}, {"MIN( decimal_field1 )": 1429}, {"MIN( decimal_field1 )": 6243}, {"MIN( decimal_field1 )": 712}, {"MIN( decimal_field1 )": 1903}, {"MIN( decimal_field1 )": 8660}, {"MIN( decimal_field1 )": 9770}, {"MIN( decimal_field1 )": 5919}, {"MIN( decimal_field1 )": 5794}, {"MIN( decimal_field1 )": 8857}, {"MIN( decimal_field1 )": 4289}, {"MIN( decimal_field1 )": 13}, {"MIN( decimal_field1 )": 4250}, {"MIN( decimal_field1 )": 2076}, {"MIN( decimal_field1 )": 8072}, {"MIN( decimal_field1 )": 4382}, {"MIN( decimal_field1 )": 6792}, {"MIN( decimal_field1 )": 7977}, {"MIN( decimal_field1 )": 2095}, {"MIN( decimal_field1 )": 1002}, {"MIN( decimal_field1 )": 8213}, {"MIN( decimal_field1 )": 8661}, {"MIN( decimal_field1 )": 2595}, {"MIN( decimal_field1 )": 4959}, {"MIN( decimal_field1 )": 6246}, {"MIN( decimal_field1 )": 9780}, {"MIN( decimal_field1 )": 5599}, {"MIN( decimal_field1 )": 5316}, {"MIN( decimal_field1 )": 899}, {"MIN( decimal_field1 )": 7620}, {"MIN( decimal_field1 )": 5959}, {"MIN( decimal_field1 )": 653}, {"MIN( decimal_field1 )": 6574}, {"MIN( decimal_field1 )": 2099}, {"MIN( decimal_field1 )": 8755}, {"MIN( decimal_field1 )": 6732}, {"MIN( decimal_field1 )": 7289}, {"MIN( decimal_field1 )": 8}, {"MIN( decimal_field1 )": 5466}, {"MIN( decimal_field1 )": 6649}, {"MIN( decimal_field1 )": 9873}, {"MIN( decimal_field1 )": 7933}, {"MIN( decimal_field1 )": 4526}, {"MIN( decimal_field1 )": 4692}, {"MIN( decimal_field1 )": 2883}, {"MIN( decimal_field1 )": 7100}, {"MIN( decimal_field1 )": 7988}, {"MIN( decimal_field1 )": 4934}, {"MIN( decimal_field1 )": 9526}, {"MIN( decimal_field1 )": 8800}, {"MIN( decimal_field1 )": 8486}, {"MIN( decimal_field1 )": 4632}, {"MIN( decimal_field1 )": 3319}, {"MIN( decimal_field1 )": 3631}, {"MIN( decimal_field1 )": 3469}, {"MIN( decimal_field1 )": 1836}, {"MIN( decimal_field1 )": 479}, {"MIN( decimal_field1 )": 2466}, {"MIN( decimal_field1 )": 8507}, {"MIN( decimal_field1 )": 9633}, {"MIN( decimal_field1 )": 5777}, {"MIN( decimal_field1 )": 27}, {"MIN( decimal_field1 )": 7062}, {"MIN( decimal_field1 )": 1312}, {"MIN( decimal_field1 )": 671}, {"MIN( decimal_field1 )": 5784}, {"MIN( decimal_field1 )": 8340}, {"MIN( decimal_field1 )": 7159}, {"MIN( decimal_field1 )": 6643}, {"MIN( decimal_field1 )": 8006}, {"MIN( decimal_field1 )": 6554}, {"MIN( decimal_field1 )": 3078}, {"MIN( decimal_field1 )": 5503}, {"MIN( decimal_field1 )": 6823}, {"MIN( decimal_field1 )": 1230}, {"MIN( decimal_field1 )": 4292}, {"MIN( decimal_field1 )": 9814}, {"MIN( decimal_field1 )": 1153}, {"MIN( decimal_field1 )": 9239}, {"MIN( decimal_field1 )": 9681}, {"MIN( decimal_field1 )": 8686}, {"MIN( decimal_field1 )": 7310}, {"MIN( decimal_field1 )": 6450}, {"MIN( decimal_field1 )": 8157}, {"MIN( decimal_field1 )": 1434}, {"MIN( decimal_field1 )": 8221}, {"MIN( decimal_field1 )": 9252}, {"MIN( decimal_field1 )": 4448}, {"MIN( decimal_field1 )": 8816}, {"MIN( decimal_field1 )": 3492}, {"MIN( decimal_field1 )": 6671}, {"MIN( decimal_field1 )": 4788}, {"MIN( decimal_field1 )": 6086}, {"MIN( decimal_field1 )": 8207}, {"MIN( decimal_field1 )": 5213}, {"MIN( decimal_field1 )": 5269}, {"MIN( decimal_field1 )": 4833}, {"MIN( decimal_field1 )": 2775}, {"MIN( decimal_field1 )": 8565}, {"MIN( decimal_field1 )": 3192}, {"MIN( decimal_field1 )": 1421}, {"MIN( decimal_field1 )": 9087}, {"MIN( decimal_field1 )": 5213}, {"MIN( decimal_field1 )": 6323}, {"MIN( decimal_field1 )": 3532}, {"MIN( decimal_field1 )": 1383}, {"MIN( decimal_field1 )": 5968}, {"MIN( decimal_field1 )": 6515}, {"MIN( decimal_field1 )": 8501}, {"MIN( decimal_field1 )": 1917}, {"MIN( decimal_field1 )": 6128}, {"MIN( decimal_field1 )": 5120}, {"MIN( decimal_field1 )": 5027}, {"MIN( decimal_field1 )": 9941}, {"MIN( decimal_field1 )": 714}, {"MIN( decimal_field1 )": 8998}, {"MIN( decimal_field1 )": 7716}, {"MIN( decimal_field1 )": 261}, {"MIN( decimal_field1 )": 4576}, {"MIN( decimal_field1 )": 2458}, {"MIN( decimal_field1 )": 151}, {"MIN( decimal_field1 )": 406}, {"MIN( decimal_field1 )": 4771}, {"MIN( decimal_field1 )": 8499}, {"MIN( decimal_field1 )": 3854}, {"MIN( decimal_field1 )": 8890}, {"MIN( decimal_field1 )": 7475}, {"MIN( decimal_field1 )": 2160}, {"MIN( decimal_field1 )": 1573}, {"MIN( decimal_field1 )": 1021}, {"MIN( decimal_field1 )": 3256}, {"MIN( decimal_field1 )": 9120}, {"MIN( decimal_field1 )": 4024}, {"MIN( decimal_field1 )": 8394}, {"MIN( decimal_field1 )": 4574}, {"MIN( decimal_field1 )": 4541}, {"MIN( decimal_field1 )": 9440}, {"MIN( decimal_field1 )": 6432}, {"MIN( decimal_field1 )": 7589}, {"MIN( decimal_field1 )": 9016}, {"MIN( decimal_field1 )": 116}, {"MIN( decimal_field1 )": 5249}, {"MIN( decimal_field1 )": 8453}, {"MIN( decimal_field1 )": 8458}, {"MIN( decimal_field1 )": 2584}, {"MIN( decimal_field1 )": 8629}, {"MIN( decimal_field1 )": 2825}, {"MIN( decimal_field1 )": 4600}, {"MIN( decimal_field1 )": 9644}, {"MIN( decimal_field1 )": 375}, {"MIN( decimal_field1 )": 6973}, {"MIN( decimal_field1 )": 1183}, {"MIN( decimal_field1 )": 4585}, {"MIN( decimal_field1 )": 6060}, {"MIN( decimal_field1 )": 8364}, {"MIN( decimal_field1 )": 4074}, {"MIN( decimal_field1 )": 5468}, {"MIN( decimal_field1 )": 1250}, {"MIN( decimal_field1 )": 9461}, {"MIN( decimal_field1 )": 9303}, {"MIN( decimal_field1 )": 4441}, {"MIN( decimal_field1 )": 1252}, {"MIN( decimal_field1 )": 5695}, {"MIN( decimal_field1 )": 5469}, {"MIN( decimal_field1 )": 7577}, {"MIN( decimal_field1 )": 7646}, {"MIN( decimal_field1 )": 7856}, {"MIN( decimal_field1 )": 1768}, {"MIN( decimal_field1 )": 9513}, {"MIN( decimal_field1 )": 1013}, {"MIN( decimal_field1 )": 3514}, {"MIN( decimal_field1 )": 8137}, {"MIN( decimal_field1 )": 6427}, {"MIN( decimal_field1 )": 7270}, {"MIN( decimal_field1 )": 6020}, {"MIN( decimal_field1 )": 7695}, {"MIN( decimal_field1 )": 2481}, {"MIN( decimal_field1 )": 7449}, {"MIN( decimal_field1 )": 2168}, {"MIN( decimal_field1 )": 326}, {"MIN( decimal_field1 )": 3498}, {"MIN( decimal_field1 )": 8382}, {"MIN( decimal_field1 )": 7578}, {"MIN( decimal_field1 )": 5359}, {"MIN( decimal_field1 )": 7201}, {"MIN( decimal_field1 )": 5989}, {"MIN( decimal_field1 )": 4526}, {"MIN( decimal_field1 )": 5716}, {"MIN( decimal_field1 )": 7027}, {"MIN( decimal_field1 )": 4784}, {"MIN( decimal_field1 )": 6933}, {"MIN( decimal_field1 )": 3493}, {"MIN( decimal_field1 )": 8253}, {"MIN( decimal_field1 )": 7707}, {"MIN( decimal_field1 )": 2255}, {"MIN( decimal_field1 )": 4199}, {"MIN( decimal_field1 )": 6665}, {"MIN( decimal_field1 )": 2395}, {"MIN( decimal_field1 )": 8217}, {"MIN( decimal_field1 )": 9505}, {"MIN( decimal_field1 )": 5759}, {"MIN( decimal_field1 )": 3354}, {"MIN( decimal_field1 )": 7900}, {"MIN( decimal_field1 )": 5202}, {"MIN( decimal_field1 )": 4755}, {"MIN( decimal_field1 )": 2364}, {"MIN( decimal_field1 )": 6253}, {"MIN( decimal_field1 )": 2849}, {"MIN( decimal_field1 )": 412}, {"MIN( decimal_field1 )": 5066}, {"MIN( decimal_field1 )": 3494}, {"MIN( decimal_field1 )": 6517}, {"MIN( decimal_field1 )": 5734}, {"MIN( decimal_field1 )": 4241}, {"MIN( decimal_field1 )": 4020}, {"MIN( decimal_field1 )": 252}, {"MIN( decimal_field1 )": 5866}, {"MIN( decimal_field1 )": 8816}, {"MIN( decimal_field1 )": 2202}, {"MIN( decimal_field1 )": 7179}, {"MIN( decimal_field1 )": 6280}, {"MIN( decimal_field1 )": 4856}, {"MIN( decimal_field1 )": 8829}, {"MIN( decimal_field1 )": 7266}, {"MIN( decimal_field1 )": 370}, {"MIN( decimal_field1 )": 2765}, {"MIN( decimal_field1 )": 1337}, {"MIN( decimal_field1 )": 7453}, {"MIN( decimal_field1 )": 3108}, {"MIN( decimal_field1 )": 9977}, {"MIN( decimal_field1 )": 2752}, {"MIN( decimal_field1 )": 9682}, {"MIN( decimal_field1 )": 2576}, {"MIN( decimal_field1 )": 3578}, {"MIN( decimal_field1 )": 3203}, {"MIN( decimal_field1 )": 6027}, {"MIN( decimal_field1 )": 7924}, {"MIN( decimal_field1 )": 9839}, {"MIN( decimal_field1 )": 5338}, {"MIN( decimal_field1 )": 8124}, {"MIN( decimal_field1 )": 5123}, {"MIN( decimal_field1 )": 8676}, {"MIN( decimal_field1 )": 5435}, {"MIN( decimal_field1 )": 4722}, {"MIN( decimal_field1 )": 822}, {"MIN( decimal_field1 )": 5835}, {"MIN( decimal_field1 )": 8777}, {"MIN( decimal_field1 )": 3822}, {"MIN( decimal_field1 )": 4292}, {"MIN( decimal_field1 )": 5802}, {"MIN( decimal_field1 )": 4091}, {"MIN( decimal_field1 )": 1444}, {"MIN( decimal_field1 )": 2491}, {"MIN( decimal_field1 )": 172}, {"MIN( decimal_field1 )": 7588}, {"MIN( decimal_field1 )": 2635}, {"MIN( decimal_field1 )": 6645}, {"MIN( decimal_field1 )": 3512}, {"MIN( decimal_field1 )": 4052}, {"MIN( decimal_field1 )": 4333}, {"MIN( decimal_field1 )": 403}, {"MIN( decimal_field1 )": 4680}, {"MIN( decimal_field1 )": 3654}, {"MIN( decimal_field1 )": 3606}, {"MIN( decimal_field1 )": 2821}, {"MIN( decimal_field1 )": 9155}, {"MIN( decimal_field1 )": 4134}, {"MIN( decimal_field1 )": 8391}, {"MIN( decimal_field1 )": 1784}, {"MIN( decimal_field1 )": 9385}, {"MIN( decimal_field1 )": 5198}, {"MIN( decimal_field1 )": 2418}, {"MIN( decimal_field1 )": 9208}, {"MIN( decimal_field1 )": 6510}, {"MIN( decimal_field1 )": 9811}, {"MIN( decimal_field1 )": 5415}, {"MIN( decimal_field1 )": 6340}, {"MIN( decimal_field1 )": 9422}, {"MIN( decimal_field1 )": 1158}, {"MIN( decimal_field1 )": 1036}, {"MIN( decimal_field1 )": 3814}, {"MIN( decimal_field1 )": 9196}, {"MIN( decimal_field1 )": 3020}, {"MIN( decimal_field1 )": 2929}, {"MIN( decimal_field1 )": 1570}, {"MIN( decimal_field1 )": 4479}, {"MIN( decimal_field1 )": 1149}, {"MIN( decimal_field1 )": 1432}, {"MIN( decimal_field1 )": 8097}, {"MIN( decimal_field1 )": 1569}, {"MIN( decimal_field1 )": 6151}, {"MIN( decimal_field1 )": 7780}, {"MIN( decimal_field1 )": 604}, {"MIN( decimal_field1 )": 847}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT MIN( decimal_field1 ) FROM simple_table_10 WHERE ((NOT (bool_field1) OR varchar_field1 < \"ZWjEXagolJ\")) AND (decimal_field1 != 5082) OR ((bool_field1 OR decimal_field1 IS NULL)) AND ((NOT (bool_field1) OR int_field1 IS NULL)) GROUP BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 , bool_field1 "} {"n1ql": "SELECT AVG( DISTINCT decimal_field1 ) FROM simple_table_10 WHERE ((bool_field1 != true AND (int_field1 >= 5069) OR (decimal_field1 >= 5082))) OR ((bool_field1 != true AND decimal_field1 != 5082)) GROUP BY int_field1 ", "expected_result": [{"AVG( DISTINCT decimal_field1 )": 7218}, {"AVG( DISTINCT decimal_field1 )": 4353}, {"AVG( DISTINCT decimal_field1 )": 7802}, {"AVG( DISTINCT decimal_field1 )": 1641}, {"AVG( DISTINCT decimal_field1 )": 7452}, {"AVG( DISTINCT decimal_field1 )": 9934}, {"AVG( DISTINCT decimal_field1 )": 6575}, {"AVG( DISTINCT decimal_field1 )": 844}, {"AVG( DISTINCT decimal_field1 )": 7714}, {"AVG( DISTINCT decimal_field1 )": 5624}, {"AVG( DISTINCT decimal_field1 )": 5099}, {"AVG( DISTINCT decimal_field1 )": 9890}, {"AVG( DISTINCT decimal_field1 )": 7372}, {"AVG( DISTINCT decimal_field1 )": 5185}, {"AVG( DISTINCT decimal_field1 )": 6774}, {"AVG( DISTINCT decimal_field1 )": 3587}, {"AVG( DISTINCT decimal_field1 )": 6951}, {"AVG( DISTINCT decimal_field1 )": 9352}, {"AVG( DISTINCT decimal_field1 )": 7587}, {"AVG( DISTINCT decimal_field1 )": 516}, {"AVG( DISTINCT decimal_field1 )": 5968}, {"AVG( DISTINCT decimal_field1 )": 9165}, {"AVG( DISTINCT decimal_field1 )": 7274}, {"AVG( DISTINCT decimal_field1 )": 7053}, {"AVG( DISTINCT decimal_field1 )": 470}, {"AVG( DISTINCT decimal_field1 )": 5742}, {"AVG( DISTINCT decimal_field1 )": 8862}, {"AVG( DISTINCT decimal_field1 )": 6752}, {"AVG( DISTINCT decimal_field1 )": 1087}, {"AVG( DISTINCT decimal_field1 )": 599}, {"AVG( DISTINCT decimal_field1 )": 9721}, {"AVG( DISTINCT decimal_field1 )": 2517}, {"AVG( DISTINCT decimal_field1 )": 9681}, {"AVG( DISTINCT decimal_field1 )": 8191}, {"AVG( DISTINCT decimal_field1 )": 7798}, {"AVG( DISTINCT decimal_field1 )": 6222}, {"AVG( DISTINCT decimal_field1 )": 6519}, {"AVG( DISTINCT decimal_field1 )": 5232}, {"AVG( DISTINCT decimal_field1 )": 9730}, {"AVG( DISTINCT decimal_field1 )": 3538}, {"AVG( DISTINCT decimal_field1 )": 5247}, {"AVG( DISTINCT decimal_field1 )": 1795}, {"AVG( DISTINCT decimal_field1 )": 6048}, {"AVG( DISTINCT decimal_field1 )": 9224}, {"AVG( DISTINCT decimal_field1 )": 7720}, {"AVG( DISTINCT decimal_field1 )": 2664}, {"AVG( DISTINCT decimal_field1 )": 6881}, {"AVG( DISTINCT decimal_field1 )": 5686}, {"AVG( DISTINCT decimal_field1 )": 9881}, {"AVG( DISTINCT decimal_field1 )": 4308}, {"AVG( DISTINCT decimal_field1 )": 2839}, {"AVG( DISTINCT decimal_field1 )": 4193}, {"AVG( DISTINCT decimal_field1 )": 9448}, {"AVG( DISTINCT decimal_field1 )": 858}, {"AVG( DISTINCT decimal_field1 )": 9418}, {"AVG( DISTINCT decimal_field1 )": 9139}, {"AVG( DISTINCT decimal_field1 )": 1966}, {"AVG( DISTINCT decimal_field1 )": 9903}, {"AVG( DISTINCT decimal_field1 )": 9891}, {"AVG( DISTINCT decimal_field1 )": 8791}, {"AVG( DISTINCT decimal_field1 )": 9392}, {"AVG( DISTINCT decimal_field1 )": 4724}, {"AVG( DISTINCT decimal_field1 )": 7445}, {"AVG( DISTINCT decimal_field1 )": 8045}, {"AVG( DISTINCT decimal_field1 )": 6628}, {"AVG( DISTINCT decimal_field1 )": 7149}, {"AVG( DISTINCT decimal_field1 )": 1874}, {"AVG( DISTINCT decimal_field1 )": 8108}, {"AVG( DISTINCT decimal_field1 )": 8647}, {"AVG( DISTINCT decimal_field1 )": 4616}, {"AVG( DISTINCT decimal_field1 )": 8789}, {"AVG( DISTINCT decimal_field1 )": 8981}, {"AVG( DISTINCT decimal_field1 )": 7626}, {"AVG( DISTINCT decimal_field1 )": 9476}, {"AVG( DISTINCT decimal_field1 )": 8453}, {"AVG( DISTINCT decimal_field1 )": 6250}, {"AVG( DISTINCT decimal_field1 )": 5220}, {"AVG( DISTINCT decimal_field1 )": 8542}, {"AVG( DISTINCT decimal_field1 )": 2508}, {"AVG( DISTINCT decimal_field1 )": 6693}, {"AVG( DISTINCT decimal_field1 )": 6835}, {"AVG( DISTINCT decimal_field1 )": 5934}, {"AVG( DISTINCT decimal_field1 )": 5773}, {"AVG( DISTINCT decimal_field1 )": 2849}, {"AVG( DISTINCT decimal_field1 )": 6268}, {"AVG( DISTINCT decimal_field1 )": 7909}, {"AVG( DISTINCT decimal_field1 )": 4743}, {"AVG( DISTINCT decimal_field1 )": 6817}, {"AVG( DISTINCT decimal_field1 )": 686}, {"AVG( DISTINCT decimal_field1 )": 2051}, {"AVG( DISTINCT decimal_field1 )": 177}, {"AVG( DISTINCT decimal_field1 )": 7991}, {"AVG( DISTINCT decimal_field1 )": 8553}, {"AVG( DISTINCT decimal_field1 )": 3765}, {"AVG( DISTINCT decimal_field1 )": 5204}, {"AVG( DISTINCT decimal_field1 )": 3404}, {"AVG( DISTINCT decimal_field1 )": 8920}, {"AVG( DISTINCT decimal_field1 )": 9631}, {"AVG( DISTINCT decimal_field1 )": 4512}, {"AVG( DISTINCT decimal_field1 )": 4598}, {"AVG( DISTINCT decimal_field1 )": 4544}, {"AVG( DISTINCT decimal_field1 )": 5162}, {"AVG( DISTINCT decimal_field1 )": 4542}, {"AVG( DISTINCT decimal_field1 )": 6767}, {"AVG( DISTINCT decimal_field1 )": 9841}, {"AVG( DISTINCT decimal_field1 )": 6185}, {"AVG( DISTINCT decimal_field1 )": 9212}, {"AVG( DISTINCT decimal_field1 )": 4339}, {"AVG( DISTINCT decimal_field1 )": 2014}, {"AVG( DISTINCT decimal_field1 )": 6993}, {"AVG( DISTINCT decimal_field1 )": 6028}, {"AVG( DISTINCT decimal_field1 )": 6034}, {"AVG( DISTINCT decimal_field1 )": 9955}, {"AVG( DISTINCT decimal_field1 )": 2596}, {"AVG( DISTINCT decimal_field1 )": 9856}, {"AVG( DISTINCT decimal_field1 )": 8689}, {"AVG( DISTINCT decimal_field1 )": 558}, {"AVG( DISTINCT decimal_field1 )": 9457}, {"AVG( DISTINCT decimal_field1 )": 5497}, {"AVG( DISTINCT decimal_field1 )": 8034}, {"AVG( DISTINCT decimal_field1 )": 9427}, {"AVG( DISTINCT decimal_field1 )": 9684}, {"AVG( DISTINCT decimal_field1 )": 8483}, {"AVG( DISTINCT decimal_field1 )": 4439}, {"AVG( DISTINCT decimal_field1 )": 1241}, {"AVG( DISTINCT decimal_field1 )": 2287}, {"AVG( DISTINCT decimal_field1 )": 6616}, {"AVG( DISTINCT decimal_field1 )": 8685}, {"AVG( DISTINCT decimal_field1 )": 7215}, {"AVG( DISTINCT decimal_field1 )": 5376}, {"AVG( DISTINCT decimal_field1 )": 6119}, {"AVG( DISTINCT decimal_field1 )": 3335}, {"AVG( DISTINCT decimal_field1 )": 1129}, {"AVG( DISTINCT decimal_field1 )": 1592}, {"AVG( DISTINCT decimal_field1 )": 7106}, {"AVG( DISTINCT decimal_field1 )": 383}, {"AVG( DISTINCT decimal_field1 )": 8693}, {"AVG( DISTINCT decimal_field1 )": 9279}, {"AVG( DISTINCT decimal_field1 )": 6076}, {"AVG( DISTINCT decimal_field1 )": 6617}, {"AVG( DISTINCT decimal_field1 )": 8939}, {"AVG( DISTINCT decimal_field1 )": 3478}, {"AVG( DISTINCT decimal_field1 )": 7094}, {"AVG( DISTINCT decimal_field1 )": 8995}, {"AVG( DISTINCT decimal_field1 )": 7982}, {"AVG( DISTINCT decimal_field1 )": 7657}, {"AVG( DISTINCT decimal_field1 )": 9583}, {"AVG( DISTINCT decimal_field1 )": 7674}, {"AVG( DISTINCT decimal_field1 )": 2664}, {"AVG( DISTINCT decimal_field1 )": 6190}, {"AVG( DISTINCT decimal_field1 )": 3956}, {"AVG( DISTINCT decimal_field1 )": 4996}, {"AVG( DISTINCT decimal_field1 )": 3954}, {"AVG( DISTINCT decimal_field1 )": 7479}, {"AVG( DISTINCT decimal_field1 )": 1401}, {"AVG( DISTINCT decimal_field1 )": 8686}, {"AVG( DISTINCT decimal_field1 )": 5067}, {"AVG( DISTINCT decimal_field1 )": 6047}, {"AVG( DISTINCT decimal_field1 )": 2513}, {"AVG( DISTINCT decimal_field1 )": 5002}, {"AVG( DISTINCT decimal_field1 )": 419}, {"AVG( DISTINCT decimal_field1 )": 171}, {"AVG( DISTINCT decimal_field1 )": 357}, {"AVG( DISTINCT decimal_field1 )": 8985}, {"AVG( DISTINCT decimal_field1 )": 7959}, {"AVG( DISTINCT decimal_field1 )": 8766}, {"AVG( DISTINCT decimal_field1 )": 1639}, {"AVG( DISTINCT decimal_field1 )": 7966}, {"AVG( DISTINCT decimal_field1 )": 5373}, {"AVG( DISTINCT decimal_field1 )": 7065}, {"AVG( DISTINCT decimal_field1 )": 1259}, {"AVG( DISTINCT decimal_field1 )": 9772}, {"AVG( DISTINCT decimal_field1 )": 5437}, {"AVG( DISTINCT decimal_field1 )": 7999}, {"AVG( DISTINCT decimal_field1 )": 7316}, {"AVG( DISTINCT decimal_field1 )": 2958}, {"AVG( DISTINCT decimal_field1 )": 6652}, {"AVG( DISTINCT decimal_field1 )": 6293}, {"AVG( DISTINCT decimal_field1 )": 6405}, {"AVG( DISTINCT decimal_field1 )": 1749}, {"AVG( DISTINCT decimal_field1 )": 1539}, {"AVG( DISTINCT decimal_field1 )": 9989}, {"AVG( DISTINCT decimal_field1 )": 7334}, {"AVG( DISTINCT decimal_field1 )": 7239}, {"AVG( DISTINCT decimal_field1 )": 1941}, {"AVG( DISTINCT decimal_field1 )": 3791}, {"AVG( DISTINCT decimal_field1 )": 2720}, {"AVG( DISTINCT decimal_field1 )": 3939}, {"AVG( DISTINCT decimal_field1 )": 8180}, {"AVG( DISTINCT decimal_field1 )": 3032}, {"AVG( DISTINCT decimal_field1 )": 7883}, {"AVG( DISTINCT decimal_field1 )": 5609}, {"AVG( DISTINCT decimal_field1 )": 5310}, {"AVG( DISTINCT decimal_field1 )": 5589}, {"AVG( DISTINCT decimal_field1 )": 7508}, {"AVG( DISTINCT decimal_field1 )": 1453}, {"AVG( DISTINCT decimal_field1 )": 5504}, {"AVG( DISTINCT decimal_field1 )": 1468}, {"AVG( DISTINCT decimal_field1 )": 9894}, {"AVG( DISTINCT decimal_field1 )": 8739}, {"AVG( DISTINCT decimal_field1 )": 7945}, {"AVG( DISTINCT decimal_field1 )": 9287}, {"AVG( DISTINCT decimal_field1 )": 839}, {"AVG( DISTINCT decimal_field1 )": 6235}, {"AVG( DISTINCT decimal_field1 )": 4076}, {"AVG( DISTINCT decimal_field1 )": 8904}, {"AVG( DISTINCT decimal_field1 )": 7644}, {"AVG( DISTINCT decimal_field1 )": 2573}, {"AVG( DISTINCT decimal_field1 )": 5434}, {"AVG( DISTINCT decimal_field1 )": 9577}, {"AVG( DISTINCT decimal_field1 )": 8938}, {"AVG( DISTINCT decimal_field1 )": 1619}, {"AVG( DISTINCT decimal_field1 )": 9884}, {"AVG( DISTINCT decimal_field1 )": 7931}, {"AVG( DISTINCT decimal_field1 )": 8129}, {"AVG( DISTINCT decimal_field1 )": 7010}, {"AVG( DISTINCT decimal_field1 )": 6584}, {"AVG( DISTINCT decimal_field1 )": 7648}, {"AVG( DISTINCT decimal_field1 )": 8428}, {"AVG( DISTINCT decimal_field1 )": 1329}, {"AVG( DISTINCT decimal_field1 )": 2146}, {"AVG( DISTINCT decimal_field1 )": 7247}, {"AVG( DISTINCT decimal_field1 )": 5411}, {"AVG( DISTINCT decimal_field1 )": 246}, {"AVG( DISTINCT decimal_field1 )": 6245}, {"AVG( DISTINCT decimal_field1 )": 5439}, {"AVG( DISTINCT decimal_field1 )": 8222}, {"AVG( DISTINCT decimal_field1 )": 2159}, {"AVG( DISTINCT decimal_field1 )": 7824}, {"AVG( DISTINCT decimal_field1 )": 2454}, {"AVG( DISTINCT decimal_field1 )": 2077}, {"AVG( DISTINCT decimal_field1 )": 2065}, {"AVG( DISTINCT decimal_field1 )": 4565}, {"AVG( DISTINCT decimal_field1 )": 2591}, {"AVG( DISTINCT decimal_field1 )": 5450}, {"AVG( DISTINCT decimal_field1 )": 1007}, {"AVG( DISTINCT decimal_field1 )": 8937}, {"AVG( DISTINCT decimal_field1 )": 5736}, {"AVG( DISTINCT decimal_field1 )": 2480}, {"AVG( DISTINCT decimal_field1 )": 5311}, {"AVG( DISTINCT decimal_field1 )": 6191}, {"AVG( DISTINCT decimal_field1 )": 9485}, {"AVG( DISTINCT decimal_field1 )": 7697}, {"AVG( DISTINCT decimal_field1 )": 1527}, {"AVG( DISTINCT decimal_field1 )": 5945}, {"AVG( DISTINCT decimal_field1 )": 4621}, {"AVG( DISTINCT decimal_field1 )": 9085}, {"AVG( DISTINCT decimal_field1 )": 5415}, {"AVG( DISTINCT decimal_field1 )": 8064}, {"AVG( DISTINCT decimal_field1 )": 5709}, {"AVG( DISTINCT decimal_field1 )": 8455}, {"AVG( DISTINCT decimal_field1 )": 475}, {"AVG( DISTINCT decimal_field1 )": 2847}, {"AVG( DISTINCT decimal_field1 )": 327}, {"AVG( DISTINCT decimal_field1 )": 2377}, {"AVG( DISTINCT decimal_field1 )": 9221}, {"AVG( DISTINCT decimal_field1 )": 9748}, {"AVG( DISTINCT decimal_field1 )": 4242}, {"AVG( DISTINCT decimal_field1 )": 3094}, {"AVG( DISTINCT decimal_field1 )": 4176}, {"AVG( DISTINCT decimal_field1 )": 9964}, {"AVG( DISTINCT decimal_field1 )": 1074}, {"AVG( DISTINCT decimal_field1 )": 3701}, {"AVG( DISTINCT decimal_field1 )": 8681}, {"AVG( DISTINCT decimal_field1 )": 2141}, {"AVG( DISTINCT decimal_field1 )": 8884}, {"AVG( DISTINCT decimal_field1 )": 9650}, {"AVG( DISTINCT decimal_field1 )": 8689}, {"AVG( DISTINCT decimal_field1 )": 9381}, {"AVG( DISTINCT decimal_field1 )": 5633}, {"AVG( DISTINCT decimal_field1 )": 3432}, {"AVG( DISTINCT decimal_field1 )": 4602}, {"AVG( DISTINCT decimal_field1 )": 9711}, {"AVG( DISTINCT decimal_field1 )": 2326}, {"AVG( DISTINCT decimal_field1 )": 7237}, {"AVG( DISTINCT decimal_field1 )": 4598}, {"AVG( DISTINCT decimal_field1 )": 7310}, {"AVG( DISTINCT decimal_field1 )": 4491}, {"AVG( DISTINCT decimal_field1 )": 7160}, {"AVG( DISTINCT decimal_field1 )": 389}, {"AVG( DISTINCT decimal_field1 )": 6022}, {"AVG( DISTINCT decimal_field1 )": 6193}, {"AVG( DISTINCT decimal_field1 )": 7005}, {"AVG( DISTINCT decimal_field1 )": 4012}, {"AVG( DISTINCT decimal_field1 )": 4111}, {"AVG( DISTINCT decimal_field1 )": 588}, {"AVG( DISTINCT decimal_field1 )": 2958}, {"AVG( DISTINCT decimal_field1 )": 7986}, {"AVG( DISTINCT decimal_field1 )": 7766}, {"AVG( DISTINCT decimal_field1 )": 6728}, {"AVG( DISTINCT decimal_field1 )": 6783}, {"AVG( DISTINCT decimal_field1 )": 179}, {"AVG( DISTINCT decimal_field1 )": 7677}, {"AVG( DISTINCT decimal_field1 )": 2530}, {"AVG( DISTINCT decimal_field1 )": 9808}, {"AVG( DISTINCT decimal_field1 )": 7851}, {"AVG( DISTINCT decimal_field1 )": 9570}, {"AVG( DISTINCT decimal_field1 )": 644}, {"AVG( DISTINCT decimal_field1 )": 9528}, {"AVG( DISTINCT decimal_field1 )": 5907}, {"AVG( DISTINCT decimal_field1 )": 3604}, {"AVG( DISTINCT decimal_field1 )": 210}, {"AVG( DISTINCT decimal_field1 )": 619}, {"AVG( DISTINCT decimal_field1 )": 6933}, {"AVG( DISTINCT decimal_field1 )": 6407}, {"AVG( DISTINCT decimal_field1 )": 7432}, {"AVG( DISTINCT decimal_field1 )": 2082}, {"AVG( DISTINCT decimal_field1 )": 4173}, {"AVG( DISTINCT decimal_field1 )": 5084}, {"AVG( DISTINCT decimal_field1 )": 8386}, {"AVG( DISTINCT decimal_field1 )": 6961}, {"AVG( DISTINCT decimal_field1 )": 839}, {"AVG( DISTINCT decimal_field1 )": 7156}, {"AVG( DISTINCT decimal_field1 )": 9665}, {"AVG( DISTINCT decimal_field1 )": 6422}, {"AVG( DISTINCT decimal_field1 )": 6030}, {"AVG( DISTINCT decimal_field1 )": 2330}, {"AVG( DISTINCT decimal_field1 )": 7316}, {"AVG( DISTINCT decimal_field1 )": 8425}, {"AVG( DISTINCT decimal_field1 )": 7673}, {"AVG( DISTINCT decimal_field1 )": 7598}, {"AVG( DISTINCT decimal_field1 )": 1010}, {"AVG( DISTINCT decimal_field1 )": 412}, {"AVG( DISTINCT decimal_field1 )": 5714}, {"AVG( DISTINCT decimal_field1 )": 9502}, {"AVG( DISTINCT decimal_field1 )": 7239}, {"AVG( DISTINCT decimal_field1 )": 5452}, {"AVG( DISTINCT decimal_field1 )": 54}, {"AVG( DISTINCT decimal_field1 )": 823}, {"AVG( DISTINCT decimal_field1 )": 8277}, {"AVG( DISTINCT decimal_field1 )": 3332}, {"AVG( DISTINCT decimal_field1 )": 5331}, {"AVG( DISTINCT decimal_field1 )": 9488}, {"AVG( DISTINCT decimal_field1 )": 2477}, {"AVG( DISTINCT decimal_field1 )": 6422}, {"AVG( DISTINCT decimal_field1 )": 3023}, {"AVG( DISTINCT decimal_field1 )": 1533}, {"AVG( DISTINCT decimal_field1 )": 5571}, {"AVG( DISTINCT decimal_field1 )": 5104}, {"AVG( DISTINCT decimal_field1 )": 7596}, {"AVG( DISTINCT decimal_field1 )": 2639}, {"AVG( DISTINCT decimal_field1 )": 3675}, {"AVG( DISTINCT decimal_field1 )": 3492}, {"AVG( DISTINCT decimal_field1 )": 4752}, {"AVG( DISTINCT decimal_field1 )": 1689}, {"AVG( DISTINCT decimal_field1 )": 7967}, {"AVG( DISTINCT decimal_field1 )": 6678}, {"AVG( DISTINCT decimal_field1 )": 8577}, {"AVG( DISTINCT decimal_field1 )": 3473}, {"AVG( DISTINCT decimal_field1 )": 721}, {"AVG( DISTINCT decimal_field1 )": 230}, {"AVG( DISTINCT decimal_field1 )": 1044}, {"AVG( DISTINCT decimal_field1 )": 6728}, {"AVG( DISTINCT decimal_field1 )": 6263}, {"AVG( DISTINCT decimal_field1 )": 8833}, {"AVG( DISTINCT decimal_field1 )": 4002}, {"AVG( DISTINCT decimal_field1 )": 3101}, {"AVG( DISTINCT decimal_field1 )": 2885}, {"AVG( DISTINCT decimal_field1 )": 1823}, {"AVG( DISTINCT decimal_field1 )": 6276}, {"AVG( DISTINCT decimal_field1 )": 4121}, {"AVG( DISTINCT decimal_field1 )": 7979}, {"AVG( DISTINCT decimal_field1 )": 8436}, {"AVG( DISTINCT decimal_field1 )": 7794}, {"AVG( DISTINCT decimal_field1 )": 9266}, {"AVG( DISTINCT decimal_field1 )": 6707}, {"AVG( DISTINCT decimal_field1 )": 8572}, {"AVG( DISTINCT decimal_field1 )": 9797}, {"AVG( DISTINCT decimal_field1 )": 2309}, {"AVG( DISTINCT decimal_field1 )": 6533}, {"AVG( DISTINCT decimal_field1 )": 7730}, {"AVG( DISTINCT decimal_field1 )": 8372}, {"AVG( DISTINCT decimal_field1 )": 7117}, {"AVG( DISTINCT decimal_field1 )": 5620}, {"AVG( DISTINCT decimal_field1 )": 9766}, {"AVG( DISTINCT decimal_field1 )": 4811}, {"AVG( DISTINCT decimal_field1 )": 6027}, {"AVG( DISTINCT decimal_field1 )": 7927}, {"AVG( DISTINCT decimal_field1 )": 9676}, {"AVG( DISTINCT decimal_field1 )": 5073}, {"AVG( DISTINCT decimal_field1 )": 1282}, {"AVG( DISTINCT decimal_field1 )": 5177}, {"AVG( DISTINCT decimal_field1 )": 4211}, {"AVG( DISTINCT decimal_field1 )": 1032}, {"AVG( DISTINCT decimal_field1 )": 3391}, {"AVG( DISTINCT decimal_field1 )": 9735}, {"AVG( DISTINCT decimal_field1 )": 978}, {"AVG( DISTINCT decimal_field1 )": 8645}, {"AVG( DISTINCT decimal_field1 )": 4333}, {"AVG( DISTINCT decimal_field1 )": 5301}, {"AVG( DISTINCT decimal_field1 )": 7393}, {"AVG( DISTINCT decimal_field1 )": 8419}, {"AVG( DISTINCT decimal_field1 )": 6084}, {"AVG( DISTINCT decimal_field1 )": 3716}, {"AVG( DISTINCT decimal_field1 )": 7155}, {"AVG( DISTINCT decimal_field1 )": 327}, {"AVG( DISTINCT decimal_field1 )": 6764}, {"AVG( DISTINCT decimal_field1 )": 7192}, {"AVG( DISTINCT decimal_field1 )": 8560}, {"AVG( DISTINCT decimal_field1 )": 7020}, {"AVG( DISTINCT decimal_field1 )": 6336}, {"AVG( DISTINCT decimal_field1 )": 6754}, {"AVG( DISTINCT decimal_field1 )": 5197}, {"AVG( DISTINCT decimal_field1 )": 6038}, {"AVG( DISTINCT decimal_field1 )": 7156}, {"AVG( DISTINCT decimal_field1 )": 2131}, {"AVG( DISTINCT decimal_field1 )": 7597}, {"AVG( DISTINCT decimal_field1 )": 8773}, {"AVG( DISTINCT decimal_field1 )": 6151}, {"AVG( DISTINCT decimal_field1 )": 6133}, {"AVG( DISTINCT decimal_field1 )": 4515}, {"AVG( DISTINCT decimal_field1 )": 8571}, {"AVG( DISTINCT decimal_field1 )": 6062}, {"AVG( DISTINCT decimal_field1 )": 7655}, {"AVG( DISTINCT decimal_field1 )": 4307}, {"AVG( DISTINCT decimal_field1 )": 6888}, {"AVG( DISTINCT decimal_field1 )": 2039}, {"AVG( DISTINCT decimal_field1 )": 4778}, {"AVG( DISTINCT decimal_field1 )": 867}, {"AVG( DISTINCT decimal_field1 )": 1193}, {"AVG( DISTINCT decimal_field1 )": 8031}, {"AVG( DISTINCT decimal_field1 )": 8045}, {"AVG( DISTINCT decimal_field1 )": 453}, {"AVG( DISTINCT decimal_field1 )": 5703}, {"AVG( DISTINCT decimal_field1 )": 405}, {"AVG( DISTINCT decimal_field1 )": 3}, {"AVG( DISTINCT decimal_field1 )": 6876}, {"AVG( DISTINCT decimal_field1 )": 3128}, {"AVG( DISTINCT decimal_field1 )": 9736}, {"AVG( DISTINCT decimal_field1 )": 8806}, {"AVG( DISTINCT decimal_field1 )": 5101}, {"AVG( DISTINCT decimal_field1 )": 7866}, {"AVG( DISTINCT decimal_field1 )": 5912}, {"AVG( DISTINCT decimal_field1 )": 8369}, {"AVG( DISTINCT decimal_field1 )": 257}, {"AVG( DISTINCT decimal_field1 )": 9800}, {"AVG( DISTINCT decimal_field1 )": 4197}, {"AVG( DISTINCT decimal_field1 )": 8850}, {"AVG( DISTINCT decimal_field1 )": 1429}, {"AVG( DISTINCT decimal_field1 )": 6243}, {"AVG( DISTINCT decimal_field1 )": 6201}, {"AVG( DISTINCT decimal_field1 )": 1903}, {"AVG( DISTINCT decimal_field1 )": 6115}, {"AVG( DISTINCT decimal_field1 )": 8660}, {"AVG( DISTINCT decimal_field1 )": 9770}, {"AVG( DISTINCT decimal_field1 )": 5919}, {"AVG( DISTINCT decimal_field1 )": 7326}, {"AVG( DISTINCT decimal_field1 )": 9270}, {"AVG( DISTINCT decimal_field1 )": 7280}, {"AVG( DISTINCT decimal_field1 )": 8466}, {"AVG( DISTINCT decimal_field1 )": 4289}, {"AVG( DISTINCT decimal_field1 )": 13}, {"AVG( DISTINCT decimal_field1 )": 4250}, {"AVG( DISTINCT decimal_field1 )": 9825}, {"AVG( DISTINCT decimal_field1 )": 4664}, {"AVG( DISTINCT decimal_field1 )": 8072}, {"AVG( DISTINCT decimal_field1 )": 5737}, {"AVG( DISTINCT decimal_field1 )": 6792}, {"AVG( DISTINCT decimal_field1 )": 7977}, {"AVG( DISTINCT decimal_field1 )": 2095}, {"AVG( DISTINCT decimal_field1 )": 1002}, {"AVG( DISTINCT decimal_field1 )": 8213}, {"AVG( DISTINCT decimal_field1 )": 8661}, {"AVG( DISTINCT decimal_field1 )": 4959}, {"AVG( DISTINCT decimal_field1 )": 6246}, {"AVG( DISTINCT decimal_field1 )": 9579}, {"AVG( DISTINCT decimal_field1 )": 6061}, {"AVG( DISTINCT decimal_field1 )": 9780}, {"AVG( DISTINCT decimal_field1 )": 5599}, {"AVG( DISTINCT decimal_field1 )": 5316}, {"AVG( DISTINCT decimal_field1 )": 899}, {"AVG( DISTINCT decimal_field1 )": 7620}, {"AVG( DISTINCT decimal_field1 )": 5959}, {"AVG( DISTINCT decimal_field1 )": 3614}, {"AVG( DISTINCT decimal_field1 )": 8755}, {"AVG( DISTINCT decimal_field1 )": 5665}, {"AVG( DISTINCT decimal_field1 )": 8314}, {"AVG( DISTINCT decimal_field1 )": 6732}, {"AVG( DISTINCT decimal_field1 )": 7289}, {"AVG( DISTINCT decimal_field1 )": 8}, {"AVG( DISTINCT decimal_field1 )": 6397}, {"AVG( DISTINCT decimal_field1 )": 5466}, {"AVG( DISTINCT decimal_field1 )": 6649}, {"AVG( DISTINCT decimal_field1 )": 9873}, {"AVG( DISTINCT decimal_field1 )": 7933}, {"AVG( DISTINCT decimal_field1 )": 4526}, {"AVG( DISTINCT decimal_field1 )": 7577}, {"AVG( DISTINCT decimal_field1 )": 7730}, {"AVG( DISTINCT decimal_field1 )": 2883}, {"AVG( DISTINCT decimal_field1 )": 7100}, {"AVG( DISTINCT decimal_field1 )": 7988}, {"AVG( DISTINCT decimal_field1 )": 9526}, {"AVG( DISTINCT decimal_field1 )": 8800}, {"AVG( DISTINCT decimal_field1 )": 8486}, {"AVG( DISTINCT decimal_field1 )": 4632}, {"AVG( DISTINCT decimal_field1 )": 3319}, {"AVG( DISTINCT decimal_field1 )": 3469}, {"AVG( DISTINCT decimal_field1 )": 479}, {"AVG( DISTINCT decimal_field1 )": 2466}, {"AVG( DISTINCT decimal_field1 )": 8507}, {"AVG( DISTINCT decimal_field1 )": 9633}, {"AVG( DISTINCT decimal_field1 )": 5777}, {"AVG( DISTINCT decimal_field1 )": 7062}, {"AVG( DISTINCT decimal_field1 )": 5784}, {"AVG( DISTINCT decimal_field1 )": 8340}, {"AVG( DISTINCT decimal_field1 )": 7159}, {"AVG( DISTINCT decimal_field1 )": 6643}, {"AVG( DISTINCT decimal_field1 )": 7848}, {"AVG( DISTINCT decimal_field1 )": 8657}, {"AVG( DISTINCT decimal_field1 )": 8006}, {"AVG( DISTINCT decimal_field1 )": 6554}, {"AVG( DISTINCT decimal_field1 )": 5503}, {"AVG( DISTINCT decimal_field1 )": 6823}, {"AVG( DISTINCT decimal_field1 )": 7368}, {"AVG( DISTINCT decimal_field1 )": 6662}, {"AVG( DISTINCT decimal_field1 )": 9814}, {"AVG( DISTINCT decimal_field1 )": 9239}, {"AVG( DISTINCT decimal_field1 )": 9681}, {"AVG( DISTINCT decimal_field1 )": 8686}, {"AVG( DISTINCT decimal_field1 )": 7310}, {"AVG( DISTINCT decimal_field1 )": 6450}, {"AVG( DISTINCT decimal_field1 )": 8157}, {"AVG( DISTINCT decimal_field1 )": 1434}, {"AVG( DISTINCT decimal_field1 )": 6711}, {"AVG( DISTINCT decimal_field1 )": 8221}, {"AVG( DISTINCT decimal_field1 )": 9252}, {"AVG( DISTINCT decimal_field1 )": 4448}, {"AVG( DISTINCT decimal_field1 )": 7254}, {"AVG( DISTINCT decimal_field1 )": 8816}, {"AVG( DISTINCT decimal_field1 )": 3492}, {"AVG( DISTINCT decimal_field1 )": 6671}, {"AVG( DISTINCT decimal_field1 )": 5267}, {"AVG( DISTINCT decimal_field1 )": 6086}, {"AVG( DISTINCT decimal_field1 )": 8207}, {"AVG( DISTINCT decimal_field1 )": 5213}, {"AVG( DISTINCT decimal_field1 )": 5269}, {"AVG( DISTINCT decimal_field1 )": 8565}, {"AVG( DISTINCT decimal_field1 )": 3192}, {"AVG( DISTINCT decimal_field1 )": 1421}, {"AVG( DISTINCT decimal_field1 )": 9087}, {"AVG( DISTINCT decimal_field1 )": 5213}, {"AVG( DISTINCT decimal_field1 )": 6323}, {"AVG( DISTINCT decimal_field1 )": 3676}, {"AVG( DISTINCT decimal_field1 )": 6515}, {"AVG( DISTINCT decimal_field1 )": 8501}, {"AVG( DISTINCT decimal_field1 )": 1917}, {"AVG( DISTINCT decimal_field1 )": 6128}, {"AVG( DISTINCT decimal_field1 )": 5120}, {"AVG( DISTINCT decimal_field1 )": 9941}, {"AVG( DISTINCT decimal_field1 )": 6790}, {"AVG( DISTINCT decimal_field1 )": 714}, {"AVG( DISTINCT decimal_field1 )": 8998}, {"AVG( DISTINCT decimal_field1 )": 7716}, {"AVG( DISTINCT decimal_field1 )": 5260}, {"AVG( DISTINCT decimal_field1 )": 261}, {"AVG( DISTINCT decimal_field1 )": 2458}, {"AVG( DISTINCT decimal_field1 )": 8499}, {"AVG( DISTINCT decimal_field1 )": 5966}, {"AVG( DISTINCT decimal_field1 )": 3854}, {"AVG( DISTINCT decimal_field1 )": 8890}, {"AVG( DISTINCT decimal_field1 )": 7475}, {"AVG( DISTINCT decimal_field1 )": 2160}, {"AVG( DISTINCT decimal_field1 )": 1021}, {"AVG( DISTINCT decimal_field1 )": 8432}, {"AVG( DISTINCT decimal_field1 )": 8389}, {"AVG( DISTINCT decimal_field1 )": 9120}, {"AVG( DISTINCT decimal_field1 )": 4024}, {"AVG( DISTINCT decimal_field1 )": 8394}, {"AVG( DISTINCT decimal_field1 )": 4574}, {"AVG( DISTINCT decimal_field1 )": 9440}, {"AVG( DISTINCT decimal_field1 )": 7011}, {"AVG( DISTINCT decimal_field1 )": 9016}, {"AVG( DISTINCT decimal_field1 )": 9223}, {"AVG( DISTINCT decimal_field1 )": 116}, {"AVG( DISTINCT decimal_field1 )": 5249}, {"AVG( DISTINCT decimal_field1 )": 6501}, {"AVG( DISTINCT decimal_field1 )": 8453}, {"AVG( DISTINCT decimal_field1 )": 8458}, {"AVG( DISTINCT decimal_field1 )": 5607}, {"AVG( DISTINCT decimal_field1 )": 4600}, {"AVG( DISTINCT decimal_field1 )": 9644}, {"AVG( DISTINCT decimal_field1 )": 7273}, {"AVG( DISTINCT decimal_field1 )": 6973}, {"AVG( DISTINCT decimal_field1 )": 1183}, {"AVG( DISTINCT decimal_field1 )": 4585}, {"AVG( DISTINCT decimal_field1 )": 6060}, {"AVG( DISTINCT decimal_field1 )": 8684}, {"AVG( DISTINCT decimal_field1 )": 8364}, {"AVG( DISTINCT decimal_field1 )": 5082}, {"AVG( DISTINCT decimal_field1 )": 8733}, {"AVG( DISTINCT decimal_field1 )": 5468}, {"AVG( DISTINCT decimal_field1 )": 1250}, {"AVG( DISTINCT decimal_field1 )": 9461}, {"AVG( DISTINCT decimal_field1 )": 9303}, {"AVG( DISTINCT decimal_field1 )": 4441}, {"AVG( DISTINCT decimal_field1 )": 1252}, {"AVG( DISTINCT decimal_field1 )": 5695}, {"AVG( DISTINCT decimal_field1 )": 5469}, {"AVG( DISTINCT decimal_field1 )": 7577}, {"AVG( DISTINCT decimal_field1 )": 7751}, {"AVG( DISTINCT decimal_field1 )": 1768}, {"AVG( DISTINCT decimal_field1 )": 7447}, {"AVG( DISTINCT decimal_field1 )": 5522}, {"AVG( DISTINCT decimal_field1 )": 9513}, {"AVG( DISTINCT decimal_field1 )": 5920}, {"AVG( DISTINCT decimal_field1 )": 6913}, {"AVG( DISTINCT decimal_field1 )": 3514}, {"AVG( DISTINCT decimal_field1 )": 8137}, {"AVG( DISTINCT decimal_field1 )": 6427}, {"AVG( DISTINCT decimal_field1 )": 7270}, {"AVG( DISTINCT decimal_field1 )": 6020}, {"AVG( DISTINCT decimal_field1 )": 7695}, {"AVG( DISTINCT decimal_field1 )": 2481}, {"AVG( DISTINCT decimal_field1 )": 7449}, {"AVG( DISTINCT decimal_field1 )": 7977}, {"AVG( DISTINCT decimal_field1 )": 2168}, {"AVG( DISTINCT decimal_field1 )": 326}, {"AVG( DISTINCT decimal_field1 )": 3498}, {"AVG( DISTINCT decimal_field1 )": 8382}, {"AVG( DISTINCT decimal_field1 )": 8857}, {"AVG( DISTINCT decimal_field1 )": 7578}, {"AVG( DISTINCT decimal_field1 )": 5359}, {"AVG( DISTINCT decimal_field1 )": 9502}, {"AVG( DISTINCT decimal_field1 )": 7201}, {"AVG( DISTINCT decimal_field1 )": 5989}, {"AVG( DISTINCT decimal_field1 )": 5214}, {"AVG( DISTINCT decimal_field1 )": 4526}, {"AVG( DISTINCT decimal_field1 )": 5716}, {"AVG( DISTINCT decimal_field1 )": 7027}, {"AVG( DISTINCT decimal_field1 )": 4784}, {"AVG( DISTINCT decimal_field1 )": 6933}, {"AVG( DISTINCT decimal_field1 )": 3493}, {"AVG( DISTINCT decimal_field1 )": 8253}, {"AVG( DISTINCT decimal_field1 )": 7707}, {"AVG( DISTINCT decimal_field1 )": 2255}, {"AVG( DISTINCT decimal_field1 )": 4199}, {"AVG( DISTINCT decimal_field1 )": 6665}, {"AVG( DISTINCT decimal_field1 )": 2395}, {"AVG( DISTINCT decimal_field1 )": 8217}, {"AVG( DISTINCT decimal_field1 )": 9505}, {"AVG( DISTINCT decimal_field1 )": 5759}, {"AVG( DISTINCT decimal_field1 )": 3354}, {"AVG( DISTINCT decimal_field1 )": 7900}, {"AVG( DISTINCT decimal_field1 )": 5202}, {"AVG( DISTINCT decimal_field1 )": 4755}, {"AVG( DISTINCT decimal_field1 )": 2364}, {"AVG( DISTINCT decimal_field1 )": 6253}, {"AVG( DISTINCT decimal_field1 )": 5066}, {"AVG( DISTINCT decimal_field1 )": 3494}, {"AVG( DISTINCT decimal_field1 )": 6517}, {"AVG( DISTINCT decimal_field1 )": 5734}, {"AVG( DISTINCT decimal_field1 )": 4241}, {"AVG( DISTINCT decimal_field1 )": 3059}, {"AVG( DISTINCT decimal_field1 )": 8816}, {"AVG( DISTINCT decimal_field1 )": 7179}, {"AVG( DISTINCT decimal_field1 )": 6280}, {"AVG( DISTINCT decimal_field1 )": 4856}, {"AVG( DISTINCT decimal_field1 )": 8829}, {"AVG( DISTINCT decimal_field1 )": 5838}, {"AVG( DISTINCT decimal_field1 )": 7572}, {"AVG( DISTINCT decimal_field1 )": 370}, {"AVG( DISTINCT decimal_field1 )": 5962}, {"AVG( DISTINCT decimal_field1 )": 2765}, {"AVG( DISTINCT decimal_field1 )": 7453}, {"AVG( DISTINCT decimal_field1 )": 9608}, {"AVG( DISTINCT decimal_field1 )": 9977}, {"AVG( DISTINCT decimal_field1 )": 2752}, {"AVG( DISTINCT decimal_field1 )": 9682}, {"AVG( DISTINCT decimal_field1 )": 2576}, {"AVG( DISTINCT decimal_field1 )": 3578}, {"AVG( DISTINCT decimal_field1 )": 4615}, {"AVG( DISTINCT decimal_field1 )": 7924}, {"AVG( DISTINCT decimal_field1 )": 9839}, {"AVG( DISTINCT decimal_field1 )": 5338}, {"AVG( DISTINCT decimal_field1 )": 8124}, {"AVG( DISTINCT decimal_field1 )": 5123}, {"AVG( DISTINCT decimal_field1 )": 8676}, {"AVG( DISTINCT decimal_field1 )": 5435}, {"AVG( DISTINCT decimal_field1 )": 5932}, {"AVG( DISTINCT decimal_field1 )": 5835}, {"AVG( DISTINCT decimal_field1 )": 8155}, {"AVG( DISTINCT decimal_field1 )": 8777}, {"AVG( DISTINCT decimal_field1 )": 3822}, {"AVG( DISTINCT decimal_field1 )": 4292}, {"AVG( DISTINCT decimal_field1 )": 5802}, {"AVG( DISTINCT decimal_field1 )": 1444}, {"AVG( DISTINCT decimal_field1 )": 2491}, {"AVG( DISTINCT decimal_field1 )": 7588}, {"AVG( DISTINCT decimal_field1 )": 2635}, {"AVG( DISTINCT decimal_field1 )": 6645}, {"AVG( DISTINCT decimal_field1 )": 9520}, {"AVG( DISTINCT decimal_field1 )": 403}, {"AVG( DISTINCT decimal_field1 )": 9127}, {"AVG( DISTINCT decimal_field1 )": 4680}, {"AVG( DISTINCT decimal_field1 )": 3654}, {"AVG( DISTINCT decimal_field1 )": 3606}, {"AVG( DISTINCT decimal_field1 )": 2821}, {"AVG( DISTINCT decimal_field1 )": 9155}, {"AVG( DISTINCT decimal_field1 )": 4134}, {"AVG( DISTINCT decimal_field1 )": 8391}, {"AVG( DISTINCT decimal_field1 )": 1784}, {"AVG( DISTINCT decimal_field1 )": 9385}, {"AVG( DISTINCT decimal_field1 )": 7029}, {"AVG( DISTINCT decimal_field1 )": 2418}, {"AVG( DISTINCT decimal_field1 )": 9208}, {"AVG( DISTINCT decimal_field1 )": 6510}, {"AVG( DISTINCT decimal_field1 )": 9811}, {"AVG( DISTINCT decimal_field1 )": 5415}, {"AVG( DISTINCT decimal_field1 )": 6340}, {"AVG( DISTINCT decimal_field1 )": 9422}, {"AVG( DISTINCT decimal_field1 )": 1158}, {"AVG( DISTINCT decimal_field1 )": 1036}, {"AVG( DISTINCT decimal_field1 )": 3814}, {"AVG( DISTINCT decimal_field1 )": 9196}, {"AVG( DISTINCT decimal_field1 )": 2929}, {"AVG( DISTINCT decimal_field1 )": 1570}, {"AVG( DISTINCT decimal_field1 )": 4479}, {"AVG( DISTINCT decimal_field1 )": 1432}, {"AVG( DISTINCT decimal_field1 )": 8097}, {"AVG( DISTINCT decimal_field1 )": 6151}, {"AVG( DISTINCT decimal_field1 )": 7780}, {"AVG( DISTINCT decimal_field1 )": 604}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT AVG( DISTINCT decimal_field1 ) FROM simple_table_10 WHERE ((bool_field1 != true AND (int_field1 >= 5069) OR (decimal_field1 >= 5082))) OR ((bool_field1 != true AND decimal_field1 != 5082)) GROUP BY int_field1 "} {"n1ql": "SELECT AVG( int_field1 ) FROM simple_table_1 WHERE (bool_field1 OR int_field1 BETWEEN 9 and 9992) GROUP BY int_field1 , primary_key_id , varchar_field1 , char_field1 ", "expected_result": [{"AVG( int_field1 )": 9}, {"AVG( int_field1 )": 29}, {"AVG( int_field1 )": 37}, {"AVG( int_field1 )": 44}, {"AVG( int_field1 )": 50}, {"AVG( int_field1 )": 52}, {"AVG( int_field1 )": 55}, {"AVG( int_field1 )": 58}, {"AVG( int_field1 )": 60}, {"AVG( int_field1 )": 65}, {"AVG( int_field1 )": 101}, {"AVG( int_field1 )": 104}, {"AVG( int_field1 )": 108}, {"AVG( int_field1 )": 133}, {"AVG( int_field1 )": 161}, {"AVG( int_field1 )": 177}, {"AVG( int_field1 )": 181}, {"AVG( int_field1 )": 195}, {"AVG( int_field1 )": 200}, {"AVG( int_field1 )": 205}, {"AVG( int_field1 )": 228}, {"AVG( int_field1 )": 234}, {"AVG( int_field1 )": 248}, {"AVG( int_field1 )": 261}, {"AVG( int_field1 )": 270}, {"AVG( int_field1 )": 277}, {"AVG( int_field1 )": 292}, {"AVG( int_field1 )": 301}, {"AVG( int_field1 )": 301}, {"AVG( int_field1 )": 319}, {"AVG( int_field1 )": 325}, {"AVG( int_field1 )": 326}, {"AVG( int_field1 )": 326}, {"AVG( int_field1 )": 332}, {"AVG( int_field1 )": 338}, {"AVG( int_field1 )": 343}, {"AVG( int_field1 )": 353}, {"AVG( int_field1 )": 364}, {"AVG( int_field1 )": 364}, {"AVG( int_field1 )": 369}, {"AVG( int_field1 )": 376}, {"AVG( int_field1 )": 390}, {"AVG( int_field1 )": 411}, {"AVG( int_field1 )": 413}, {"AVG( int_field1 )": 422}, {"AVG( int_field1 )": 450}, {"AVG( int_field1 )": 467}, {"AVG( int_field1 )": 468}, {"AVG( int_field1 )": 487}, {"AVG( int_field1 )": 505}, {"AVG( int_field1 )": 506}, {"AVG( int_field1 )": 516}, {"AVG( int_field1 )": 517}, {"AVG( int_field1 )": 530}, {"AVG( int_field1 )": 535}, {"AVG( int_field1 )": 543}, {"AVG( int_field1 )": 553}, {"AVG( int_field1 )": 555}, {"AVG( int_field1 )": 556}, {"AVG( int_field1 )": 566}, {"AVG( int_field1 )": 583}, {"AVG( int_field1 )": 586}, {"AVG( int_field1 )": 597}, {"AVG( int_field1 )": 599}, {"AVG( int_field1 )": 619}, {"AVG( int_field1 )": 621}, {"AVG( int_field1 )": 622}, {"AVG( int_field1 )": 625}, {"AVG( int_field1 )": 628}, {"AVG( int_field1 )": 680}, {"AVG( int_field1 )": 683}, {"AVG( int_field1 )": 700}, {"AVG( int_field1 )": 715}, {"AVG( int_field1 )": 721}, {"AVG( int_field1 )": 722}, {"AVG( int_field1 )": 723}, {"AVG( int_field1 )": 732}, {"AVG( int_field1 )": 734}, {"AVG( int_field1 )": 752}, {"AVG( int_field1 )": 759}, {"AVG( int_field1 )": 761}, {"AVG( int_field1 )": 762}, {"AVG( int_field1 )": 764}, {"AVG( int_field1 )": 777}, {"AVG( int_field1 )": 779}, {"AVG( int_field1 )": 782}, {"AVG( int_field1 )": 793}, {"AVG( int_field1 )": 797}, {"AVG( int_field1 )": 797}, {"AVG( int_field1 )": 811}, {"AVG( int_field1 )": 820}, {"AVG( int_field1 )": 821}, {"AVG( int_field1 )": 821}, {"AVG( int_field1 )": 821}, {"AVG( int_field1 )": 833}, {"AVG( int_field1 )": 835}, {"AVG( int_field1 )": 836}, {"AVG( int_field1 )": 847}, {"AVG( int_field1 )": 851}, {"AVG( int_field1 )": 869}, {"AVG( int_field1 )": 869}, {"AVG( int_field1 )": 874}, {"AVG( int_field1 )": 898}, {"AVG( int_field1 )": 907}, {"AVG( int_field1 )": 910}, {"AVG( int_field1 )": 927}, {"AVG( int_field1 )": 927}, {"AVG( int_field1 )": 931}, {"AVG( int_field1 )": 947}, {"AVG( int_field1 )": 966}, {"AVG( int_field1 )": 986}, {"AVG( int_field1 )": 989}, {"AVG( int_field1 )": 1008}, {"AVG( int_field1 )": 1015}, {"AVG( int_field1 )": 1016}, {"AVG( int_field1 )": 1035}, {"AVG( int_field1 )": 1062}, {"AVG( int_field1 )": 1079}, {"AVG( int_field1 )": 1086}, {"AVG( int_field1 )": 1091}, {"AVG( int_field1 )": 1102}, {"AVG( int_field1 )": 1113}, {"AVG( int_field1 )": 1115}, {"AVG( int_field1 )": 1117}, {"AVG( int_field1 )": 1119}, {"AVG( int_field1 )": 1141}, {"AVG( int_field1 )": 1174}, {"AVG( int_field1 )": 1175}, {"AVG( int_field1 )": 1183}, {"AVG( int_field1 )": 1185}, {"AVG( int_field1 )": 1188}, {"AVG( int_field1 )": 1214}, {"AVG( int_field1 )": 1249}, {"AVG( int_field1 )": 1275}, {"AVG( int_field1 )": 1332}, {"AVG( int_field1 )": 1333}, {"AVG( int_field1 )": 1343}, {"AVG( int_field1 )": 1343}, {"AVG( int_field1 )": 1350}, {"AVG( int_field1 )": 1354}, {"AVG( int_field1 )": 1355}, {"AVG( int_field1 )": 1361}, {"AVG( int_field1 )": 1366}, {"AVG( int_field1 )": 1385}, {"AVG( int_field1 )": 1391}, {"AVG( int_field1 )": 1395}, {"AVG( int_field1 )": 1407}, {"AVG( int_field1 )": 1407}, {"AVG( int_field1 )": 1411}, {"AVG( int_field1 )": 1414}, {"AVG( int_field1 )": 1423}, {"AVG( int_field1 )": 1427}, {"AVG( int_field1 )": 1434}, {"AVG( int_field1 )": 1451}, {"AVG( int_field1 )": 1456}, {"AVG( int_field1 )": 1456}, {"AVG( int_field1 )": 1458}, {"AVG( int_field1 )": 1460}, {"AVG( int_field1 )": 1463}, {"AVG( int_field1 )": 1479}, {"AVG( int_field1 )": 1488}, {"AVG( int_field1 )": 1491}, {"AVG( int_field1 )": 1492}, {"AVG( int_field1 )": 1501}, {"AVG( int_field1 )": 1510}, {"AVG( int_field1 )": 1521}, {"AVG( int_field1 )": 1524}, {"AVG( int_field1 )": 1531}, {"AVG( int_field1 )": 1535}, {"AVG( int_field1 )": 1535}, {"AVG( int_field1 )": 1543}, {"AVG( int_field1 )": 1552}, {"AVG( int_field1 )": 1560}, {"AVG( int_field1 )": 1574}, {"AVG( int_field1 )": 1578}, {"AVG( int_field1 )": 1581}, {"AVG( int_field1 )": 1584}, {"AVG( int_field1 )": 1647}, {"AVG( int_field1 )": 1658}, {"AVG( int_field1 )": 1671}, {"AVG( int_field1 )": 1673}, {"AVG( int_field1 )": 1679}, {"AVG( int_field1 )": 1680}, {"AVG( int_field1 )": 1682}, {"AVG( int_field1 )": 1685}, {"AVG( int_field1 )": 1716}, {"AVG( int_field1 )": 1720}, {"AVG( int_field1 )": 1722}, {"AVG( int_field1 )": 1741}, {"AVG( int_field1 )": 1741}, {"AVG( int_field1 )": 1755}, {"AVG( int_field1 )": 1757}, {"AVG( int_field1 )": 1757}, {"AVG( int_field1 )": 1779}, {"AVG( int_field1 )": 1792}, {"AVG( int_field1 )": 1794}, {"AVG( int_field1 )": 1797}, {"AVG( int_field1 )": 1803}, {"AVG( int_field1 )": 1812}, {"AVG( int_field1 )": 1814}, {"AVG( int_field1 )": 1819}, {"AVG( int_field1 )": 1835}, {"AVG( int_field1 )": 1877}, {"AVG( int_field1 )": 1877}, {"AVG( int_field1 )": 1911}, {"AVG( int_field1 )": 1937}, {"AVG( int_field1 )": 1940}, {"AVG( int_field1 )": 1944}, {"AVG( int_field1 )": 1960}, {"AVG( int_field1 )": 1961}, {"AVG( int_field1 )": 1971}, {"AVG( int_field1 )": 1973}, {"AVG( int_field1 )": 1980}, {"AVG( int_field1 )": 1980}, {"AVG( int_field1 )": 1981}, {"AVG( int_field1 )": 1985}, {"AVG( int_field1 )": 1989}, {"AVG( int_field1 )": 2018}, {"AVG( int_field1 )": 2028}, {"AVG( int_field1 )": 2033}, {"AVG( int_field1 )": 2046}, {"AVG( int_field1 )": 2047}, {"AVG( int_field1 )": 2066}, {"AVG( int_field1 )": 2078}, {"AVG( int_field1 )": 2089}, {"AVG( int_field1 )": 2108}, {"AVG( int_field1 )": 2109}, {"AVG( int_field1 )": 2118}, {"AVG( int_field1 )": 2122}, {"AVG( int_field1 )": 2124}, {"AVG( int_field1 )": 2131}, {"AVG( int_field1 )": 2132}, {"AVG( int_field1 )": 2149}, {"AVG( int_field1 )": 2155}, {"AVG( int_field1 )": 2155}, {"AVG( int_field1 )": 2168}, {"AVG( int_field1 )": 2175}, {"AVG( int_field1 )": 2176}, {"AVG( int_field1 )": 2189}, {"AVG( int_field1 )": 2222}, {"AVG( int_field1 )": 2223}, {"AVG( int_field1 )": 2224}, {"AVG( int_field1 )": 2230}, {"AVG( int_field1 )": 2236}, {"AVG( int_field1 )": 2238}, {"AVG( int_field1 )": 2249}, {"AVG( int_field1 )": 2270}, {"AVG( int_field1 )": 2272}, {"AVG( int_field1 )": 2273}, {"AVG( int_field1 )": 2288}, {"AVG( int_field1 )": 2289}, {"AVG( int_field1 )": 2290}, {"AVG( int_field1 )": 2291}, {"AVG( int_field1 )": 2293}, {"AVG( int_field1 )": 2306}, {"AVG( int_field1 )": 2340}, {"AVG( int_field1 )": 2354}, {"AVG( int_field1 )": 2371}, {"AVG( int_field1 )": 2383}, {"AVG( int_field1 )": 2387}, {"AVG( int_field1 )": 2395}, {"AVG( int_field1 )": 2397}, {"AVG( int_field1 )": 2397}, {"AVG( int_field1 )": 2399}, {"AVG( int_field1 )": 2428}, {"AVG( int_field1 )": 2430}, {"AVG( int_field1 )": 2445}, {"AVG( int_field1 )": 2445}, {"AVG( int_field1 )": 2447}, {"AVG( int_field1 )": 2485}, {"AVG( int_field1 )": 2488}, {"AVG( int_field1 )": 2493}, {"AVG( int_field1 )": 2503}, {"AVG( int_field1 )": 2504}, {"AVG( int_field1 )": 2506}, {"AVG( int_field1 )": 2509}, {"AVG( int_field1 )": 2542}, {"AVG( int_field1 )": 2549}, {"AVG( int_field1 )": 2555}, {"AVG( int_field1 )": 2558}, {"AVG( int_field1 )": 2566}, {"AVG( int_field1 )": 2592}, {"AVG( int_field1 )": 2594}, {"AVG( int_field1 )": 2600}, {"AVG( int_field1 )": 2620}, {"AVG( int_field1 )": 2635}, {"AVG( int_field1 )": 2637}, {"AVG( int_field1 )": 2637}, {"AVG( int_field1 )": 2643}, {"AVG( int_field1 )": 2650}, {"AVG( int_field1 )": 2651}, {"AVG( int_field1 )": 2655}, {"AVG( int_field1 )": 2661}, {"AVG( int_field1 )": 2665}, {"AVG( int_field1 )": 2665}, {"AVG( int_field1 )": 2677}, {"AVG( int_field1 )": 2693}, {"AVG( int_field1 )": 2727}, {"AVG( int_field1 )": 2740}, {"AVG( int_field1 )": 2758}, {"AVG( int_field1 )": 2759}, {"AVG( int_field1 )": 2760}, {"AVG( int_field1 )": 2769}, {"AVG( int_field1 )": 2783}, {"AVG( int_field1 )": 2789}, {"AVG( int_field1 )": 2797}, {"AVG( int_field1 )": 2800}, {"AVG( int_field1 )": 2879}, {"AVG( int_field1 )": 2900}, {"AVG( int_field1 )": 2920}, {"AVG( int_field1 )": 2937}, {"AVG( int_field1 )": 2947}, {"AVG( int_field1 )": 2959}, {"AVG( int_field1 )": 2968}, {"AVG( int_field1 )": 2976}, {"AVG( int_field1 )": 2977}, {"AVG( int_field1 )": 2978}, {"AVG( int_field1 )": 2999}, {"AVG( int_field1 )": 3019}, {"AVG( int_field1 )": 3026}, {"AVG( int_field1 )": 3029}, {"AVG( int_field1 )": 3036}, {"AVG( int_field1 )": 3048}, {"AVG( int_field1 )": 3056}, {"AVG( int_field1 )": 3064}, {"AVG( int_field1 )": 3094}, {"AVG( int_field1 )": 3096}, {"AVG( int_field1 )": 3096}, {"AVG( int_field1 )": 3097}, {"AVG( int_field1 )": 3107}, {"AVG( int_field1 )": 3108}, {"AVG( int_field1 )": 3114}, {"AVG( int_field1 )": 3128}, {"AVG( int_field1 )": 3129}, {"AVG( int_field1 )": 3137}, {"AVG( int_field1 )": 3143}, {"AVG( int_field1 )": 3144}, {"AVG( int_field1 )": 3144}, {"AVG( int_field1 )": 3148}, {"AVG( int_field1 )": 3152}, {"AVG( int_field1 )": 3154}, {"AVG( int_field1 )": 3155}, {"AVG( int_field1 )": 3170}, {"AVG( int_field1 )": 3171}, {"AVG( int_field1 )": 3173}, {"AVG( int_field1 )": 3177}, {"AVG( int_field1 )": 3191}, {"AVG( int_field1 )": 3201}, {"AVG( int_field1 )": 3216}, {"AVG( int_field1 )": 3219}, {"AVG( int_field1 )": 3237}, {"AVG( int_field1 )": 3240}, {"AVG( int_field1 )": 3259}, {"AVG( int_field1 )": 3259}, {"AVG( int_field1 )": 3261}, {"AVG( int_field1 )": 3288}, {"AVG( int_field1 )": 3358}, {"AVG( int_field1 )": 3364}, {"AVG( int_field1 )": 3369}, {"AVG( int_field1 )": 3380}, {"AVG( int_field1 )": 3380}, {"AVG( int_field1 )": 3391}, {"AVG( int_field1 )": 3393}, {"AVG( int_field1 )": 3403}, {"AVG( int_field1 )": 3406}, {"AVG( int_field1 )": 3416}, {"AVG( int_field1 )": 3433}, {"AVG( int_field1 )": 3439}, {"AVG( int_field1 )": 3445}, {"AVG( int_field1 )": 3448}, {"AVG( int_field1 )": 3452}, {"AVG( int_field1 )": 3459}, {"AVG( int_field1 )": 3460}, {"AVG( int_field1 )": 3461}, {"AVG( int_field1 )": 3463}, {"AVG( int_field1 )": 3483}, {"AVG( int_field1 )": 3486}, {"AVG( int_field1 )": 3516}, {"AVG( int_field1 )": 3525}, {"AVG( int_field1 )": 3536}, {"AVG( int_field1 )": 3549}, {"AVG( int_field1 )": 3557}, {"AVG( int_field1 )": 3559}, {"AVG( int_field1 )": 3567}, {"AVG( int_field1 )": 3580}, {"AVG( int_field1 )": 3589}, {"AVG( int_field1 )": 3593}, {"AVG( int_field1 )": 3605}, {"AVG( int_field1 )": 3621}, {"AVG( int_field1 )": 3633}, {"AVG( int_field1 )": 3670}, {"AVG( int_field1 )": 3675}, {"AVG( int_field1 )": 3681}, {"AVG( int_field1 )": 3691}, {"AVG( int_field1 )": 3703}, {"AVG( int_field1 )": 3707}, {"AVG( int_field1 )": 3709}, {"AVG( int_field1 )": 3720}, {"AVG( int_field1 )": 3737}, {"AVG( int_field1 )": 3745}, {"AVG( int_field1 )": 3746}, {"AVG( int_field1 )": 3756}, {"AVG( int_field1 )": 3764}, {"AVG( int_field1 )": 3776}, {"AVG( int_field1 )": 3791}, {"AVG( int_field1 )": 3794}, {"AVG( int_field1 )": 3799}, {"AVG( int_field1 )": 3800}, {"AVG( int_field1 )": 3813}, {"AVG( int_field1 )": 3828}, {"AVG( int_field1 )": 3829}, {"AVG( int_field1 )": 3831}, {"AVG( int_field1 )": 3866}, {"AVG( int_field1 )": 3868}, {"AVG( int_field1 )": 3870}, {"AVG( int_field1 )": 3873}, {"AVG( int_field1 )": 3878}, {"AVG( int_field1 )": 3881}, {"AVG( int_field1 )": 3882}, {"AVG( int_field1 )": 3892}, {"AVG( int_field1 )": 3902}, {"AVG( int_field1 )": 3906}, {"AVG( int_field1 )": 3908}, {"AVG( int_field1 )": 3913}, {"AVG( int_field1 )": 3914}, {"AVG( int_field1 )": 3924}, {"AVG( int_field1 )": 3936}, {"AVG( int_field1 )": 3941}, {"AVG( int_field1 )": 3951}, {"AVG( int_field1 )": 3956}, {"AVG( int_field1 )": 3959}, {"AVG( int_field1 )": 3980}, {"AVG( int_field1 )": 3981}, {"AVG( int_field1 )": 3985}, {"AVG( int_field1 )": 3991}, {"AVG( int_field1 )": 4002}, {"AVG( int_field1 )": 4017}, {"AVG( int_field1 )": 4042}, {"AVG( int_field1 )": 4043}, {"AVG( int_field1 )": 4045}, {"AVG( int_field1 )": 4048}, {"AVG( int_field1 )": 4054}, {"AVG( int_field1 )": 4060}, {"AVG( int_field1 )": 4065}, {"AVG( int_field1 )": 4089}, {"AVG( int_field1 )": 4094}, {"AVG( int_field1 )": 4097}, {"AVG( int_field1 )": 4100}, {"AVG( int_field1 )": 4115}, {"AVG( int_field1 )": 4121}, {"AVG( int_field1 )": 4128}, {"AVG( int_field1 )": 4128}, {"AVG( int_field1 )": 4153}, {"AVG( int_field1 )": 4162}, {"AVG( int_field1 )": 4170}, {"AVG( int_field1 )": 4190}, {"AVG( int_field1 )": 4209}, {"AVG( int_field1 )": 4212}, {"AVG( int_field1 )": 4237}, {"AVG( int_field1 )": 4240}, {"AVG( int_field1 )": 4258}, {"AVG( int_field1 )": 4260}, {"AVG( int_field1 )": 4262}, {"AVG( int_field1 )": 4283}, {"AVG( int_field1 )": 4286}, {"AVG( int_field1 )": 4325}, {"AVG( int_field1 )": 4333}, {"AVG( int_field1 )": 4336}, {"AVG( int_field1 )": 4345}, {"AVG( int_field1 )": 4398}, {"AVG( int_field1 )": 4404}, {"AVG( int_field1 )": 4417}, {"AVG( int_field1 )": 4451}, {"AVG( int_field1 )": 4467}, {"AVG( int_field1 )": 4468}, {"AVG( int_field1 )": 4485}, {"AVG( int_field1 )": 4505}, {"AVG( int_field1 )": 4532}, {"AVG( int_field1 )": 4538}, {"AVG( int_field1 )": 4564}, {"AVG( int_field1 )": 4568}, {"AVG( int_field1 )": 4568}, {"AVG( int_field1 )": 4569}, {"AVG( int_field1 )": 4578}, {"AVG( int_field1 )": 4597}, {"AVG( int_field1 )": 4601}, {"AVG( int_field1 )": 4613}, {"AVG( int_field1 )": 4615}, {"AVG( int_field1 )": 4620}, {"AVG( int_field1 )": 4651}, {"AVG( int_field1 )": 4658}, {"AVG( int_field1 )": 4672}, {"AVG( int_field1 )": 4680}, {"AVG( int_field1 )": 4684}, {"AVG( int_field1 )": 4686}, {"AVG( int_field1 )": 4726}, {"AVG( int_field1 )": 4728}, {"AVG( int_field1 )": 4748}, {"AVG( int_field1 )": 4760}, {"AVG( int_field1 )": 4770}, {"AVG( int_field1 )": 4776}, {"AVG( int_field1 )": 4786}, {"AVG( int_field1 )": 4790}, {"AVG( int_field1 )": 4795}, {"AVG( int_field1 )": 4810}, {"AVG( int_field1 )": 4816}, {"AVG( int_field1 )": 4833}, {"AVG( int_field1 )": 4835}, {"AVG( int_field1 )": 4841}, {"AVG( int_field1 )": 4842}, {"AVG( int_field1 )": 4854}, {"AVG( int_field1 )": 4866}, {"AVG( int_field1 )": 4879}, {"AVG( int_field1 )": 4889}, {"AVG( int_field1 )": 4908}, {"AVG( int_field1 )": 4909}, {"AVG( int_field1 )": 4920}, {"AVG( int_field1 )": 4921}, {"AVG( int_field1 )": 4959}, {"AVG( int_field1 )": 4962}, {"AVG( int_field1 )": 4966}, {"AVG( int_field1 )": 4967}, {"AVG( int_field1 )": 4996}, {"AVG( int_field1 )": 5004}, {"AVG( int_field1 )": 5021}, {"AVG( int_field1 )": 5041}, {"AVG( int_field1 )": 5042}, {"AVG( int_field1 )": 5055}, {"AVG( int_field1 )": 5068}, {"AVG( int_field1 )": 5095}, {"AVG( int_field1 )": 5109}, {"AVG( int_field1 )": 5115}, {"AVG( int_field1 )": 5119}, {"AVG( int_field1 )": 5131}, {"AVG( int_field1 )": 5133}, {"AVG( int_field1 )": 5138}, {"AVG( int_field1 )": 5152}, {"AVG( int_field1 )": 5174}, {"AVG( int_field1 )": 5193}, {"AVG( int_field1 )": 5215}, {"AVG( int_field1 )": 5222}, {"AVG( int_field1 )": 5231}, {"AVG( int_field1 )": 5237}, {"AVG( int_field1 )": 5253}, {"AVG( int_field1 )": 5257}, {"AVG( int_field1 )": 5263}, {"AVG( int_field1 )": 5263}, {"AVG( int_field1 )": 5267}, {"AVG( int_field1 )": 5267}, {"AVG( int_field1 )": 5272}, {"AVG( int_field1 )": 5273}, {"AVG( int_field1 )": 5278}, {"AVG( int_field1 )": 5282}, {"AVG( int_field1 )": 5285}, {"AVG( int_field1 )": 5289}, {"AVG( int_field1 )": 5289}, {"AVG( int_field1 )": 5291}, {"AVG( int_field1 )": 5303}, {"AVG( int_field1 )": 5307}, {"AVG( int_field1 )": 5320}, {"AVG( int_field1 )": 5323}, {"AVG( int_field1 )": 5326}, {"AVG( int_field1 )": 5328}, {"AVG( int_field1 )": 5338}, {"AVG( int_field1 )": 5378}, {"AVG( int_field1 )": 5399}, {"AVG( int_field1 )": 5402}, {"AVG( int_field1 )": 5406}, {"AVG( int_field1 )": 5406}, {"AVG( int_field1 )": 5418}, {"AVG( int_field1 )": 5435}, {"AVG( int_field1 )": 5436}, {"AVG( int_field1 )": 5461}, {"AVG( int_field1 )": 5467}, {"AVG( int_field1 )": 5468}, {"AVG( int_field1 )": 5488}, {"AVG( int_field1 )": 5508}, {"AVG( int_field1 )": 5510}, {"AVG( int_field1 )": 5545}, {"AVG( int_field1 )": 5545}, {"AVG( int_field1 )": 5548}, {"AVG( int_field1 )": 5549}, {"AVG( int_field1 )": 5568}, {"AVG( int_field1 )": 5575}, {"AVG( int_field1 )": 5599}, {"AVG( int_field1 )": 5619}, {"AVG( int_field1 )": 5626}, {"AVG( int_field1 )": 5638}, {"AVG( int_field1 )": 5658}, {"AVG( int_field1 )": 5670}, {"AVG( int_field1 )": 5673}, {"AVG( int_field1 )": 5676}, {"AVG( int_field1 )": 5677}, {"AVG( int_field1 )": 5679}, {"AVG( int_field1 )": 5681}, {"AVG( int_field1 )": 5689}, {"AVG( int_field1 )": 5690}, {"AVG( int_field1 )": 5696}, {"AVG( int_field1 )": 5700}, {"AVG( int_field1 )": 5704}, {"AVG( int_field1 )": 5705}, {"AVG( int_field1 )": 5711}, {"AVG( int_field1 )": 5720}, {"AVG( int_field1 )": 5725}, {"AVG( int_field1 )": 5728}, {"AVG( int_field1 )": 5734}, {"AVG( int_field1 )": 5737}, {"AVG( int_field1 )": 5750}, {"AVG( int_field1 )": 5759}, {"AVG( int_field1 )": 5762}, {"AVG( int_field1 )": 5775}, {"AVG( int_field1 )": 5777}, {"AVG( int_field1 )": 5790}, {"AVG( int_field1 )": 5794}, {"AVG( int_field1 )": 5796}, {"AVG( int_field1 )": 5798}, {"AVG( int_field1 )": 5819}, {"AVG( int_field1 )": 5819}, {"AVG( int_field1 )": 5829}, {"AVG( int_field1 )": 5834}, {"AVG( int_field1 )": 5836}, {"AVG( int_field1 )": 5851}, {"AVG( int_field1 )": 5854}, {"AVG( int_field1 )": 5859}, {"AVG( int_field1 )": 5892}, {"AVG( int_field1 )": 5900}, {"AVG( int_field1 )": 5903}, {"AVG( int_field1 )": 5904}, {"AVG( int_field1 )": 5905}, {"AVG( int_field1 )": 5907}, {"AVG( int_field1 )": 5930}, {"AVG( int_field1 )": 5934}, {"AVG( int_field1 )": 5942}, {"AVG( int_field1 )": 5947}, {"AVG( int_field1 )": 5956}, {"AVG( int_field1 )": 5965}, {"AVG( int_field1 )": 5977}, {"AVG( int_field1 )": 5985}, {"AVG( int_field1 )": 5988}, {"AVG( int_field1 )": 5993}, {"AVG( int_field1 )": 5997}, {"AVG( int_field1 )": 6000}, {"AVG( int_field1 )": 6001}, {"AVG( int_field1 )": 6004}, {"AVG( int_field1 )": 6005}, {"AVG( int_field1 )": 6016}, {"AVG( int_field1 )": 6017}, {"AVG( int_field1 )": 6028}, {"AVG( int_field1 )": 6055}, {"AVG( int_field1 )": 6105}, {"AVG( int_field1 )": 6107}, {"AVG( int_field1 )": 6119}, {"AVG( int_field1 )": 6152}, {"AVG( int_field1 )": 6178}, {"AVG( int_field1 )": 6178}, {"AVG( int_field1 )": 6180}, {"AVG( int_field1 )": 6187}, {"AVG( int_field1 )": 6189}, {"AVG( int_field1 )": 6197}, {"AVG( int_field1 )": 6200}, {"AVG( int_field1 )": 6210}, {"AVG( int_field1 )": 6215}, {"AVG( int_field1 )": 6235}, {"AVG( int_field1 )": 6238}, {"AVG( int_field1 )": 6240}, {"AVG( int_field1 )": 6248}, {"AVG( int_field1 )": 6249}, {"AVG( int_field1 )": 6251}, {"AVG( int_field1 )": 6256}, {"AVG( int_field1 )": 6276}, {"AVG( int_field1 )": 6281}, {"AVG( int_field1 )": 6281}, {"AVG( int_field1 )": 6304}, {"AVG( int_field1 )": 6328}, {"AVG( int_field1 )": 6331}, {"AVG( int_field1 )": 6369}, {"AVG( int_field1 )": 6374}, {"AVG( int_field1 )": 6384}, {"AVG( int_field1 )": 6412}, {"AVG( int_field1 )": 6413}, {"AVG( int_field1 )": 6424}, {"AVG( int_field1 )": 6428}, {"AVG( int_field1 )": 6453}, {"AVG( int_field1 )": 6464}, {"AVG( int_field1 )": 6470}, {"AVG( int_field1 )": 6483}, {"AVG( int_field1 )": 6489}, {"AVG( int_field1 )": 6494}, {"AVG( int_field1 )": 6510}, {"AVG( int_field1 )": 6511}, {"AVG( int_field1 )": 6522}, {"AVG( int_field1 )": 6526}, {"AVG( int_field1 )": 6527}, {"AVG( int_field1 )": 6534}, {"AVG( int_field1 )": 6536}, {"AVG( int_field1 )": 6565}, {"AVG( int_field1 )": 6568}, {"AVG( int_field1 )": 6578}, {"AVG( int_field1 )": 6584}, {"AVG( int_field1 )": 6587}, {"AVG( int_field1 )": 6593}, {"AVG( int_field1 )": 6623}, {"AVG( int_field1 )": 6623}, {"AVG( int_field1 )": 6650}, {"AVG( int_field1 )": 6652}, {"AVG( int_field1 )": 6654}, {"AVG( int_field1 )": 6660}, {"AVG( int_field1 )": 6663}, {"AVG( int_field1 )": 6664}, {"AVG( int_field1 )": 6665}, {"AVG( int_field1 )": 6671}, {"AVG( int_field1 )": 6676}, {"AVG( int_field1 )": 6690}, {"AVG( int_field1 )": 6734}, {"AVG( int_field1 )": 6735}, {"AVG( int_field1 )": 6741}, {"AVG( int_field1 )": 6753}, {"AVG( int_field1 )": 6762}, {"AVG( int_field1 )": 6792}, {"AVG( int_field1 )": 6795}, {"AVG( int_field1 )": 6817}, {"AVG( int_field1 )": 6828}, {"AVG( int_field1 )": 6829}, {"AVG( int_field1 )": 6840}, {"AVG( int_field1 )": 6851}, {"AVG( int_field1 )": 6855}, {"AVG( int_field1 )": 6867}, {"AVG( int_field1 )": 6872}, {"AVG( int_field1 )": 6880}, {"AVG( int_field1 )": 6885}, {"AVG( int_field1 )": 6892}, {"AVG( int_field1 )": 6894}, {"AVG( int_field1 )": 6904}, {"AVG( int_field1 )": 6918}, {"AVG( int_field1 )": 6922}, {"AVG( int_field1 )": 6964}, {"AVG( int_field1 )": 6991}, {"AVG( int_field1 )": 7006}, {"AVG( int_field1 )": 7012}, {"AVG( int_field1 )": 7028}, {"AVG( int_field1 )": 7029}, {"AVG( int_field1 )": 7036}, {"AVG( int_field1 )": 7056}, {"AVG( int_field1 )": 7068}, {"AVG( int_field1 )": 7078}, {"AVG( int_field1 )": 7081}, {"AVG( int_field1 )": 7092}, {"AVG( int_field1 )": 7095}, {"AVG( int_field1 )": 7098}, {"AVG( int_field1 )": 7110}, {"AVG( int_field1 )": 7127}, {"AVG( int_field1 )": 7127}, {"AVG( int_field1 )": 7128}, {"AVG( int_field1 )": 7143}, {"AVG( int_field1 )": 7149}, {"AVG( int_field1 )": 7152}, {"AVG( int_field1 )": 7162}, {"AVG( int_field1 )": 7165}, {"AVG( int_field1 )": 7192}, {"AVG( int_field1 )": 7195}, {"AVG( int_field1 )": 7206}, {"AVG( int_field1 )": 7207}, {"AVG( int_field1 )": 7223}, {"AVG( int_field1 )": 7230}, {"AVG( int_field1 )": 7233}, {"AVG( int_field1 )": 7256}, {"AVG( int_field1 )": 7261}, {"AVG( int_field1 )": 7266}, {"AVG( int_field1 )": 7270}, {"AVG( int_field1 )": 7276}, {"AVG( int_field1 )": 7278}, {"AVG( int_field1 )": 7281}, {"AVG( int_field1 )": 7281}, {"AVG( int_field1 )": 7312}, {"AVG( int_field1 )": 7321}, {"AVG( int_field1 )": 7323}, {"AVG( int_field1 )": 7330}, {"AVG( int_field1 )": 7330}, {"AVG( int_field1 )": 7335}, {"AVG( int_field1 )": 7336}, {"AVG( int_field1 )": 7340}, {"AVG( int_field1 )": 7360}, {"AVG( int_field1 )": 7363}, {"AVG( int_field1 )": 7364}, {"AVG( int_field1 )": 7370}, {"AVG( int_field1 )": 7373}, {"AVG( int_field1 )": 7387}, {"AVG( int_field1 )": 7396}, {"AVG( int_field1 )": 7423}, {"AVG( int_field1 )": 7437}, {"AVG( int_field1 )": 7456}, {"AVG( int_field1 )": 7465}, {"AVG( int_field1 )": 7483}, {"AVG( int_field1 )": 7517}, {"AVG( int_field1 )": 7517}, {"AVG( int_field1 )": 7542}, {"AVG( int_field1 )": 7549}, {"AVG( int_field1 )": 7564}, {"AVG( int_field1 )": 7594}, {"AVG( int_field1 )": 7603}, {"AVG( int_field1 )": 7612}, {"AVG( int_field1 )": 7614}, {"AVG( int_field1 )": 7623}, {"AVG( int_field1 )": 7658}, {"AVG( int_field1 )": 7687}, {"AVG( int_field1 )": 7688}, {"AVG( int_field1 )": 7697}, {"AVG( int_field1 )": 7698}, {"AVG( int_field1 )": 7706}, {"AVG( int_field1 )": 7709}, {"AVG( int_field1 )": 7710}, {"AVG( int_field1 )": 7734}, {"AVG( int_field1 )": 7742}, {"AVG( int_field1 )": 7776}, {"AVG( int_field1 )": 7789}, {"AVG( int_field1 )": 7789}, {"AVG( int_field1 )": 7790}, {"AVG( int_field1 )": 7791}, {"AVG( int_field1 )": 7799}, {"AVG( int_field1 )": 7817}, {"AVG( int_field1 )": 7823}, {"AVG( int_field1 )": 7823}, {"AVG( int_field1 )": 7823}, {"AVG( int_field1 )": 7831}, {"AVG( int_field1 )": 7855}, {"AVG( int_field1 )": 7874}, {"AVG( int_field1 )": 7884}, {"AVG( int_field1 )": 7891}, {"AVG( int_field1 )": 7933}, {"AVG( int_field1 )": 7940}, {"AVG( int_field1 )": 7949}, {"AVG( int_field1 )": 7963}, {"AVG( int_field1 )": 7963}, {"AVG( int_field1 )": 7972}, {"AVG( int_field1 )": 7983}, {"AVG( int_field1 )": 7999}, {"AVG( int_field1 )": 8029}, {"AVG( int_field1 )": 8069}, {"AVG( int_field1 )": 8076}, {"AVG( int_field1 )": 8086}, {"AVG( int_field1 )": 8101}, {"AVG( int_field1 )": 8126}, {"AVG( int_field1 )": 8129}, {"AVG( int_field1 )": 8137}, {"AVG( int_field1 )": 8141}, {"AVG( int_field1 )": 8171}, {"AVG( int_field1 )": 8180}, {"AVG( int_field1 )": 8183}, {"AVG( int_field1 )": 8205}, {"AVG( int_field1 )": 8218}, {"AVG( int_field1 )": 8220}, {"AVG( int_field1 )": 8252}, {"AVG( int_field1 )": 8272}, {"AVG( int_field1 )": 8283}, {"AVG( int_field1 )": 8290}, {"AVG( int_field1 )": 8292}, {"AVG( int_field1 )": 8306}, {"AVG( int_field1 )": 8306}, {"AVG( int_field1 )": 8326}, {"AVG( int_field1 )": 8342}, {"AVG( int_field1 )": 8362}, {"AVG( int_field1 )": 8376}, {"AVG( int_field1 )": 8387}, {"AVG( int_field1 )": 8446}, {"AVG( int_field1 )": 8455}, {"AVG( int_field1 )": 8465}, {"AVG( int_field1 )": 8467}, {"AVG( int_field1 )": 8475}, {"AVG( int_field1 )": 8482}, {"AVG( int_field1 )": 8519}, {"AVG( int_field1 )": 8528}, {"AVG( int_field1 )": 8540}, {"AVG( int_field1 )": 8555}, {"AVG( int_field1 )": 8556}, {"AVG( int_field1 )": 8570}, {"AVG( int_field1 )": 8580}, {"AVG( int_field1 )": 8584}, {"AVG( int_field1 )": 8589}, {"AVG( int_field1 )": 8620}, {"AVG( int_field1 )": 8620}, {"AVG( int_field1 )": 8621}, {"AVG( int_field1 )": 8627}, {"AVG( int_field1 )": 8628}, {"AVG( int_field1 )": 8629}, {"AVG( int_field1 )": 8635}, {"AVG( int_field1 )": 8638}, {"AVG( int_field1 )": 8651}, {"AVG( int_field1 )": 8662}, {"AVG( int_field1 )": 8665}, {"AVG( int_field1 )": 8665}, {"AVG( int_field1 )": 8666}, {"AVG( int_field1 )": 8705}, {"AVG( int_field1 )": 8707}, {"AVG( int_field1 )": 8710}, {"AVG( int_field1 )": 8718}, {"AVG( int_field1 )": 8728}, {"AVG( int_field1 )": 8729}, {"AVG( int_field1 )": 8755}, {"AVG( int_field1 )": 8757}, {"AVG( int_field1 )": 8790}, {"AVG( int_field1 )": 8792}, {"AVG( int_field1 )": 8808}, {"AVG( int_field1 )": 8819}, {"AVG( int_field1 )": 8827}, {"AVG( int_field1 )": 8853}, {"AVG( int_field1 )": 8860}, {"AVG( int_field1 )": 8860}, {"AVG( int_field1 )": 8871}, {"AVG( int_field1 )": 8877}, {"AVG( int_field1 )": 8877}, {"AVG( int_field1 )": 8877}, {"AVG( int_field1 )": 8907}, {"AVG( int_field1 )": 8911}, {"AVG( int_field1 )": 8911}, {"AVG( int_field1 )": 8912}, {"AVG( int_field1 )": 8933}, {"AVG( int_field1 )": 8937}, {"AVG( int_field1 )": 8945}, {"AVG( int_field1 )": 8978}, {"AVG( int_field1 )": 8978}, {"AVG( int_field1 )": 8988}, {"AVG( int_field1 )": 9005}, {"AVG( int_field1 )": 9051}, {"AVG( int_field1 )": 9057}, {"AVG( int_field1 )": 9061}, {"AVG( int_field1 )": 9074}, {"AVG( int_field1 )": 9091}, {"AVG( int_field1 )": 9100}, {"AVG( int_field1 )": 9101}, {"AVG( int_field1 )": 9112}, {"AVG( int_field1 )": 9189}, {"AVG( int_field1 )": 9217}, {"AVG( int_field1 )": 9241}, {"AVG( int_field1 )": 9249}, {"AVG( int_field1 )": 9252}, {"AVG( int_field1 )": 9271}, {"AVG( int_field1 )": 9293}, {"AVG( int_field1 )": 9293}, {"AVG( int_field1 )": 9297}, {"AVG( int_field1 )": 9314}, {"AVG( int_field1 )": 9329}, {"AVG( int_field1 )": 9331}, {"AVG( int_field1 )": 9381}, {"AVG( int_field1 )": 9416}, {"AVG( int_field1 )": 9422}, {"AVG( int_field1 )": 9428}, {"AVG( int_field1 )": 9432}, {"AVG( int_field1 )": 9435}, {"AVG( int_field1 )": 9451}, {"AVG( int_field1 )": 9451}, {"AVG( int_field1 )": 9479}, {"AVG( int_field1 )": 9485}, {"AVG( int_field1 )": 9496}, {"AVG( int_field1 )": 9499}, {"AVG( int_field1 )": 9520}, {"AVG( int_field1 )": 9532}, {"AVG( int_field1 )": 9542}, {"AVG( int_field1 )": 9543}, {"AVG( int_field1 )": 9544}, {"AVG( int_field1 )": 9545}, {"AVG( int_field1 )": 9593}, {"AVG( int_field1 )": 9593}, {"AVG( int_field1 )": 9599}, {"AVG( int_field1 )": 9601}, {"AVG( int_field1 )": 9604}, {"AVG( int_field1 )": 9607}, {"AVG( int_field1 )": 9611}, {"AVG( int_field1 )": 9618}, {"AVG( int_field1 )": 9636}, {"AVG( int_field1 )": 9654}, {"AVG( int_field1 )": 9659}, {"AVG( int_field1 )": 9668}, {"AVG( int_field1 )": 9670}, {"AVG( int_field1 )": 9677}, {"AVG( int_field1 )": 9717}, {"AVG( int_field1 )": 9722}, {"AVG( int_field1 )": 9730}, {"AVG( int_field1 )": 9754}, {"AVG( int_field1 )": 9755}, {"AVG( int_field1 )": 9797}, {"AVG( int_field1 )": 9805}, {"AVG( int_field1 )": 9812}, {"AVG( int_field1 )": 9867}, {"AVG( int_field1 )": 9871}, {"AVG( int_field1 )": 9883}, {"AVG( int_field1 )": 9896}, {"AVG( int_field1 )": 9898}, {"AVG( int_field1 )": 9906}, {"AVG( int_field1 )": 9936}, {"AVG( int_field1 )": 9937}, {"AVG( int_field1 )": 9941}, {"AVG( int_field1 )": 9950}, {"AVG( int_field1 )": 9950}, {"AVG( int_field1 )": 9952}, {"AVG( int_field1 )": 9957}, {"AVG( int_field1 )": 9957}, {"AVG( int_field1 )": 9964}, {"AVG( int_field1 )": 9974}, {"AVG( int_field1 )": 9981}, {"AVG( int_field1 )": 9992}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT AVG( int_field1 ) FROM simple_table_1 WHERE (bool_field1 OR int_field1 BETWEEN 9 and 9992) GROUP BY int_field1 , primary_key_id , varchar_field1 , char_field1 "} {"n1ql": "SELECT SUM( decimal_field1 ) FROM simple_table_1 WHERE (bool_field1 = true) AND ((bool_field1 AND int_field1 IN [ 9 , 29 , 37 , 44 , 50 ])) ", "expected_result": [{"SUM( decimal_field1 )": 14223}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( decimal_field1 ) FROM simple_table_1 WHERE (bool_field1 = true) AND ((bool_field1 AND int_field1 IN ( 9 , 29 , 37 , 44 , 50 ))) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_1 WHERE (int_field1 IN [ 9 , 29 , 37 , 44 , 50 ]) OR (int_field1 != 4760) ", "expected_result": [{"COUNT(*)": 999}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_1 WHERE (int_field1 IN ( 9 , 29 , 37 , 44 , 50 )) OR (int_field1 != 4760) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE (bool_field1 AND decimal_field1 IN [ 5 , 9 , 13 , 15 , 48 ]) ", "expected_result": [{"SUM( int_field1 )": 5599}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE (bool_field1 AND decimal_field1 IN ( 5 , 9 , 13 , 15 , 48 )) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 OR NOT (int_field1 IN [ 9 , 29 , 37 , 44 , 50 ]))) AND ((bool_field1 != false AND int_field1 > 4760)) ", "expected_result": [{"SUM( int_field1 )": 1808939}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 OR NOT (int_field1 IN ( 9 , 29 , 37 , 44 , 50 )))) AND ((bool_field1 != false AND int_field1 > 4760)) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE decimal_field1 IN [ 5 , 9 , 13 , 15 , 48 ] ", "expected_result": [{"SUM( int_field1 )": 14501}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE decimal_field1 IN ( 5 , 9 , 13 , 15 , 48 ) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE ((int_field1 >= 5069) OR (int_field1 BETWEEN 3 and 9979)) AND (int_field1 <= 5069) ", "expected_result": [{"SUM( int_field1 )": 1291096}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE ((int_field1 >= 5069) OR (int_field1 BETWEEN 3 and 9979)) AND (int_field1 <= 5069) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE NOT ((bool_field1 != false OR int_field1 IN [ 3 , 13 , 21 , 27 , 36 ])) ", "expected_result": [{"SUM( int_field1 )": 2570880}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE NOT ((bool_field1 != false OR int_field1 IN ( 3 , 13 , 21 , 27 , 36 ))) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_10 WHERE (char_field1 <= \"N\" AND int_field1 IN [ 3 , 13 , 21 , 27 , 36 ]) ", "expected_result": [{"COUNT(*)": 3}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_10 WHERE (char_field1 <= \"N\" AND int_field1 IN ( 3 , 13 , 21 , 27 , 36 )) "} {"n1ql": "SELECT SUM( decimal_field1 ) FROM simple_table_1 WHERE (bool_field1 != false) AND ((bool_field1 OR int_field1 IN [ 9 , 29 , 37 , 44 , 50 ])) OR ((bool_field1 AND NOT (int_field1 > 4760))) AND (bool_field1) ", "expected_result": [{"SUM( decimal_field1 )": 2572410}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( decimal_field1 ) FROM simple_table_1 WHERE (bool_field1 != false) AND ((bool_field1 OR int_field1 IN ( 9 , 29 , 37 , 44 , 50 ))) OR ((bool_field1 AND NOT (int_field1 > 4760))) AND (bool_field1) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_1 WHERE NOT ((bool_field1 != false OR int_field1 IN [ 9 , 29 , 37 , 44 , 50 ])) ORDER BY int_field1 , decimal_field1 ", "expected_result": [{"COUNT(*)": 484}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_1 WHERE NOT ((bool_field1 != false OR int_field1 IN ( 9 , 29 , 37 , 44 , 50 ))) ORDER BY int_field1 , decimal_field1 "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE NOT ((decimal_field1 >= 4849 OR ((NOT (varchar_field1 NOT LIKE \"ZmmAagcFAU\")) AND (NOT (NOT (varchar_field1 > \"ZmmAagcFAU\")))) AND (varchar_field1 <> \"ZmmAagcFAU\"))) ", "expected_result": [{"SUM( int_field1 )": 2431514}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE NOT ((decimal_field1 >= 4849 OR ((NOT (varchar_field1 NOT LIKE \"ZmmAagcFAU\")) AND (NOT (NOT (varchar_field1 > \"ZmmAagcFAU\")))) AND (varchar_field1 <> \"ZmmAagcFAU\"))) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE NOT ((bool_field1 = false OR int_field1 IN [ 9 , 29 , 37 , 44 , 50 ])) ", "expected_result": [{"SUM( int_field1 )": 2409938}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE NOT ((bool_field1 = false OR int_field1 IN ( 9 , 29 , 37 , 44 , 50 ))) "} {"n1ql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE ((bool_field1 != true OR char_field1 IN [ \"A\" , \"B\" , \"C\" , \"D\" , \"E\" ])) AND ((bool_field1 != true AND char_field1 NOT LIKE 'N%')) ", "expected_result": [{"SUM( decimal_field1 )": 2432454}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE ((bool_field1 != true OR char_field1 IN ( \"A\" , \"B\" , \"C\" , \"D\" , \"E\" ))) AND ((bool_field1 != true AND char_field1 NOT LIKE 'N%')) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_10 WHERE NOT ((bool_field1 != true OR decimal_field1 IN [ 3 , 8 , 13 , 27 , 54 ])) ", "expected_result": [{"COUNT(*)": 495}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_10 WHERE NOT ((bool_field1 != true OR decimal_field1 IN ( 3 , 8 , 13 , 27 , 54 ))) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 = true OR int_field1 != 4760)) AND ((bool_field1 AND NOT (int_field1 IN [ 9 , 29 , 37 , 44 , 50 ]))) ", "expected_result": [{"SUM( int_field1 )": 2409938}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 = true OR int_field1 != 4760)) AND ((bool_field1 AND NOT (int_field1 IN ( 9 , 29 , 37 , 44 , 50 )))) "} {"n1ql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE NOT (NOT ((decimal_field1 < 5082) OR (decimal_field1 <= 5082))) ", "expected_result": [{"SUM( decimal_field1 )": 1300618}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE NOT (NOT ((decimal_field1 < 5082) OR (decimal_field1 <= 5082))) "} {"n1ql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE char_field1 IN [ \"A\" , \"B\" , \"C\" , \"D\" , \"E\" ] ", "expected_result": [{"SUM( decimal_field1 )": 978785}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE char_field1 IN ( \"A\" , \"B\" , \"C\" , \"D\" , \"E\" ) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE (bool_field1 = true) AND ((bool_field1 AND varchar_field1 IN [ \"ADdiftNWjX\" , \"AMHCjniudX\" , \"APMThwexAu\" , \"ARyeblEWAc\" , \"AVVmxLwfLr\" ])) ", "expected_result": [{"SUM( int_field1 )": 20610}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE (bool_field1 = true) AND ((bool_field1 AND varchar_field1 IN ( \"ADdiftNWjX\" , \"AMHCjniudX\" , \"APMThwexAu\" , \"ARyeblEWAc\" , \"AVVmxLwfLr\" ))) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE ((NOT (bool_field1) AND decimal_field1 IN [ 3 , 8 , 13 , 27 , 54 ])) AND (NOT (bool_field1)) ", "expected_result": [{"SUM( int_field1 )": 23682}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE ((NOT (bool_field1) AND decimal_field1 IN ( 3 , 8 , 13 , 27 , 54 ))) AND (NOT (bool_field1)) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_1 WHERE (int_field1 IN [ 9 , 29 , 37 , 44 , 50 ]) AND ((bool_field1 AND decimal_field1 >= 4849)) ORDER BY int_field1 , decimal_field1 ", "expected_result": [{"COUNT(*)": 2}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_1 WHERE (int_field1 IN ( 9 , 29 , 37 , 44 , 50 )) AND ((bool_field1 AND decimal_field1 >= 4849)) ORDER BY int_field1 , decimal_field1 "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE NOT ((bool_field1 != false OR NOT ((decimal_field1 BETWEEN 5 and 9977) AND (int_field1 != 4760)))) ", "expected_result": [{"SUM( int_field1 )": 2361999}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_1 WHERE NOT ((bool_field1 != false OR NOT ((decimal_field1 BETWEEN 5 and 9977) AND (int_field1 != 4760)))) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE NOT ((NOT (decimal_field1 IN [ 3 , 8 , 13 , 27 , 54 ]) OR varchar_field1 = \"ZWjEXagolJ\")) ", "expected_result": [{"SUM( int_field1 )": 31324}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE NOT ((NOT (decimal_field1 IN ( 3 , 8 , 13 , 27 , 54 )) OR varchar_field1 = \"ZWjEXagolJ\")) "} {"n1ql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE (decimal_field1 <= 5082) OR (decimal_field1 != 5082) ", "expected_result": [{"SUM( decimal_field1 )": 5018763}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( decimal_field1 ) FROM simple_table_10 WHERE (decimal_field1 <= 5082) OR (decimal_field1 != 5082) "} {"n1ql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE (bool_field1 AND char_field1 IN [ \"A\" , \"B\" , \"C\" , \"D\" , \"E\" ]) ", "expected_result": [{"SUM( int_field1 )": 447274}], "bucket": "simple_table_10", "indexes": {}, "sql": "SELECT SUM( int_field1 ) FROM simple_table_10 WHERE (bool_field1 AND char_field1 IN ( \"A\" , \"B\" , \"C\" , \"D\" , \"E\" )) "} {"n1ql": "SELECT SUM( decimal_field1 ) FROM simple_table_1 WHERE NOT ((NOT (bool_field1) OR decimal_field1 IN [ 5 , 9 , 13 , 15 , 48 ])) ", "expected_result": [{"SUM( decimal_field1 )": 2572395}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( decimal_field1 ) FROM simple_table_1 WHERE NOT ((NOT (bool_field1) OR decimal_field1 IN ( 5 , 9 , 13 , 15 , 48 ))) "} {"n1ql": "SELECT COUNT(*) FROM simple_table_1 WHERE (int_field1 IN [ 9 , 29 , 37 , 44 , 50 ]) AND (bool_field1 != true) ", "expected_result": [{"COUNT(*)": 3}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT COUNT(*) FROM simple_table_1 WHERE (int_field1 IN ( 9 , 29 , 37 , 44 , 50 )) AND (bool_field1 != true) "} {"n1ql": "SELECT SUM( decimal_field1 ) FROM simple_table_1 WHERE NOT (((NOT (NOT (int_field1 <= 4760))) OR ((int_field1 != 4760) AND (int_field1 <= 4760)) OR varchar_field1 IN [ \"ADoScZeGkd\" , \"AEHqmpBGzq\" , \"AHJeJxeoLa\" , \"ALyfoCSkgJ\" , \"AaJhFKqjoT\" ])) ", "expected_result": [{"SUM( decimal_field1 )": 2402865}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( decimal_field1 ) FROM simple_table_1 WHERE NOT (((NOT (NOT (int_field1 <= 4760))) OR ((int_field1 != 4760) AND (int_field1 <= 4760)) OR varchar_field1 IN ( \"ADoScZeGkd\" , \"AEHqmpBGzq\" , \"AHJeJxeoLa\" , \"ALyfoCSkgJ\" , \"AaJhFKqjoT\" ))) "} {"n1ql": "SELECT SUM( decimal_field1 ) FROM simple_table_1 WHERE ((bool_field1 != false AND char_field1 IN [ \"A\" , \"B\" , \"C\" , \"D\" , \"E\" ])) AND ((bool_field1 = false AND char_field1 IS NULL)) OR ((bool_field1 != true AND (decimal_field1 IN [ 5 , 9 , 13 , 15 , 48 ]) AND (decimal_field1 != 4849))) AND ((bool_field1 != true AND decimal_field1 <= 4849)) ", "expected_result": [{"SUM( decimal_field1 )": 75}], "bucket": "simple_table_1", "indexes": {}, "sql": "SELECT SUM( decimal_field1 ) FROM simple_table_1 WHERE ((bool_field1 != false AND char_field1 IN ( \"A\" , \"B\" , \"C\" , \"D\" , \"E\" ))) AND ((bool_field1 = false AND char_field1 IS NULL)) OR ((bool_field1 != true AND (decimal_field1 IN ( 5 , 9 , 13 , 15 , 48 )) AND (decimal_field1 != 4849))) AND ((bool_field1 != true AND decimal_field1 <= 4849)) "}