create table bureau (
id int(11) default null,
c2 int(11) default null,
c3 varchar(20),
c4 varchar(20),
c5 int(11) default null,
c6 int(11) default null,
c7 varchar(20),
c8 varchar(20),
c9 varchar(20),
c10 int(11) default null,
c11 double default null,
c12 varchar(20),
c13 varchar(20),
c14 double default null,
c15 varchar(20),
c16 int(11) default null,
amt_annuity varchar(20),
key bureau (id,c2),
key bureau_i2 (c2)
) engine=innodb default charset=utf8mb4 collate=utf8mb4_0900_ai_ci;
Warnings:
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
set session sql_mode='';
load data infile '../../std_data/inconsistent_scan.csv' into table bureau columns terminated by "," ignore 1 lines;
set big_tables=0;
create table t1 as
select id, c2, count(*) over w cnt,
c3,
c4, c5,
c6, c7, c8,
c9, c10, c11,
c12, c13,
c14, c15, c16
from bureau window w as (partition by id);
set big_tables=1;
create table t2 as
select id, c2, count(*) over w cnt,
c3,
c4, c5,
c6, c7, c8,
c9, c10, c11,
c12, c13,
c14, c15, c16
from bureau window w as (partition by id);
create table t3 as
select * from t1 union select * from t2;
select * from t1;
id	c2	cnt	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16
119939	5714566	17	Closed	currency 1	-2279	0	-1945.0	-2033.0	0.0	0	39541.5	0.0	0.0	0	Consumer credit	-2033
119939	5714567	17	Closed	currency 1	-2247	0	-1123.0	-1733.0	0.0	0	135000	0.0	0.0	0	Credit card	-1733
119939	5714568	17	Closed	currency 1	-1447	0	-331.0	-1272.0	0.0	0	99000	-2692.17	137692.17	0	Credit card	-1272
119939	5714569	17	Closed	currency 1	-1390	0	-331.0	-1263.0	0.0	0	135000	-149.04	135149.04	0	Credit card	-1263
119939	5714570	17	Active	currency 1	-1390	0	-696.0		0.0	0	4500	-2.565	2.565	0	Credit card	-691
119939	5714571	17	Active	currency 1	-733	0	1100.0		0.0	0	337500	242596.395	94903.605	0	Credit card	-687
119939	5714573	17	Closed	currency 1	-1188	0	1369.0	-1090.0		0	450000	0.0	0.0	0	Consumer credit	-429
119939	5714574	17	Closed	currency 1	-437	0	1389.0	-225.0		0	1226250	0.0	0.0	0	Consumer credit	-194
119939	5714575	17	Closed	currency 1	-944	0	335.0	-548.0		0	1215000	0.0	0.0	0	Consumer credit	-513
119939	5714577	17	Active	currency 1	-1102	0	4.0			0	225000	210730.5	0.0	0	Credit card	-10
119939	5714578	17	Closed	currency 1	-1572	0	-1179.0	-987.0		0	225000			0	Consumer credit	-984
119939	5714579	17	Closed	currency 1	-1791	0	-1703.0	-987.0		0	22770			0	Consumer credit	-984
119939	5714580	17	Active	currency 1	-2401	0			0.0	0	99000	45036.0	53962.695	0	Credit card	-22
119939	5714581	17	Closed	currency 1	-1624	0	203.0	-1085.0	40.5	0	765000			0	Consumer credit	-1085
119939	5714582	17	Closed	currency 1	-1617	0	9341.0	-1083.0	6007.5	0	144000			0	Credit card	-1083
119939	5714583	17	Closed	currency 1	-937	0	889.0	-156.0	0.0	0	675000			0	Consumer credit	-156
119939	5714585	17	Active	currency 1	-314	0	1512.0		0.0	0	900000			0	Consumer credit	-40
136226	5714502	2	Active	currency 1	-521	0	551.0			0	112500	0.0	0.0	0	Credit card	-30
136226	5714503	2	Closed	currency 1	-559	0		-355.0	0.0	0	110250	0.0	0.0	0	Credit card	-351
162297	5714469	6	Closed	currency 1	-1896	0	-1684.0	-1710.0	14985.0	0	76878.45	0.0	0.0	0	Consumer credit	-1710
162297	5714470	6	Closed	currency 1	-1146	0	-811.0	-840.0	0.0	0	103007.7	0.0	0.0	0	Consumer credit	-840
162297	5714471	6	Active	currency 1	-1146	0	-484.0		0.0	0	4500	0.0	0.0	0	Credit card	-690
162297	5714472	6	Active	currency 1	-1146	0	-180.0		0.0	0	337500	0.0	0.0	0	Credit card	-690
162297	5714473	6	Closed	currency 1	-2456	0	-629.0	-825.0		0	675000	0.0	0.0	0	Consumer credit	-706
162297	5714474	6	Active	currency 1	-277	0	5261.0		0.0	0	7033500			0	Mortgage	-31
166034	5714697	8	Closed	currency 1	-1283	0	-1069.0	-1083.0	3727.89	0	19399.5	0.0	0.0	0	Consumer credit	-1068
166034	5714698	8	Closed	currency 1	-828	0	-613.0	-642.0	13590.0	0	70692.84	0.0	0.0	0	Consumer credit	-642
166034	5714699	8	Active	currency 1	-828	0	916.0		0.0	0	4500	0.0	4500.0	0	Credit card	-676
166034	5714700	8	Closed	currency 1	-1207	0	-1021.0	-1021.0		0	93240	0.0	0.0	0	Consumer credit	-981
166034	5714701	8	Active	currency 1	-706	0	369.0			0	459000	483534.0	0.0	0	Credit card	-4
166034	5714702	8	Active	currency 1	-262	0	103.0			0	450000	174519.0		0	Consumer credit	-7
166034	5714704	8	Active	currency 1	-718	0			2189.205	0	45000	43357.5	1638.765	0	Credit card	-22
166034	5714705	8	Closed	currency 1	-612	0	-245.0	-207.0	13225.725	0	178335	0.0	0.0	0	Consumer credit	-206
173404	5714710	4	Closed	currency 1	-1103	0	-304.0	-303.0		0	216000	0.0	0.0	0	Credit card	-303
173404	5714711	4	Closed	currency 1	-1166	0	-915.0	-915.0		0	107037	0.0	0.0	0	Consumer credit	-752
173404	5714712	4	Active	currency 1	-45	0	320.0			0	234000	234000.0	0.0	0	Consumer credit	-26
173404	5714713	4	Closed	currency 1	-1165	0	-860.0	-915.0	0.0	0	107037	0.0	0.0	0	Consumer credit	-825
215354	5714462	7	Closed	currency 1	-497	0	-153.0	-153.0		0	91323	0.0		0	Consumer credit	-131
215354	5714463	7	Active	currency 1	-208	0	1075.0			0	225000	171342.0		0	Credit card	-20
215354	5714464	7	Active	currency 1	-203	0	528.0			0	464323.5			0	Consumer credit	-16
215354	5714465	7	Active	currency 1	-203	0				0	90000			0	Credit card	-16
215354	5714466	7	Active	currency 1	-629	0	1197.0		77674.5	0	2700000			0	Consumer credit	-21
215354	5714467	7	Active	currency 1	-273	0	27460.0		0.0	0	180000	71017.38	108982.62	0	Credit card	-31
215354	5714468	7	Active	currency 1	-43	0	79.0		0.0	0	42103.8	42103.8	0.0	0	Consumer credit	-22
222183	5714491	6	Active	currency 1	-784	0	1008.0		0.0	0	0	-411.615	411.615	0	Credit card	-694
222183	5714492	6	Active	currency 1	-774	0	625.0			0	127840.5	0.0	0.0	0	Credit card	-210
222183	5714493	6	Active	currency 1	-395	0	1431.0			0	1350000	1185493.5	0.0	0	Consumer credit	-24
222183	5714495	6	Closed	currency 1	-2744	0	-2561.0	-2559.0	310.5	0	18157.5			0	Consumer credit	-2559
222183	5714496	6	Closed	currency 1	-1103	0	-7.0	-343.0	20493.27	0	675000	0.0	0.0	0	Consumer credit	-343
222183	5714497	6	Active	currency 1	-315	0	1512.0		88821.0	0	3709552.5			0	Car loan	-32
234931	5714557	6	Active	currency 1	-1272	0	-667.0			0	135000	17982.0	0.0	0	Consumer credit	-721
234931	5714558	6	Closed	currency 1	-1602	0	-1332.0	-987.0		0	42894			0	Consumer credit	-984
234931	5714559	6	Closed	currency 1	-1273	0	-667.0	-649.0		0	135000			0	Consumer credit	-643
234931	5714560	6	Closed	currency 1	-371	0	-130.0	-130.0		0	63522	0.0		0	Consumer credit	-110
234931	5714561	6	Closed	currency 1	-2638	0	-1208.0	-1518.0	18293.265	0	1143000	0.0	0.0	0	Car loan	-704
234931	5714562	6	Closed	currency 1	-1495	0	-635.0	-40.0	12618.0	0	46831.5			0	Consumer credit	-34
238881	5714482	7	Closed	currency 1	-318	0	-187.0	-187.0		0	0	0.0	0.0	0	Credit card	-185
238881	5714484	7	Closed	currency 1	-2911	0	-2607.0	-2604.0		0	48555			0	Consumer credit	-2601
238881	5714485	7	Closed	currency 1	-2148	0	-1595.0	-987.0		0	135000			0	Consumer credit	-984
238881	5714486	7	Active	currency 1	-381	0				0	450000	520920.0		0	Consumer credit	-4
238881	5714487	7	Active	currency 1	-95	0	1720.0			0	67500	8131.5		0	Credit card	-7
238881	5714488	7	Closed	currency 1	-444	0	-77.0	-77.0	0.0	0	107184.06	0.0	0.0	0	Consumer credit	-71
238881	5714489	7	Active	currency 1	-392	0			0.0	0	252000	23679.0	228320.1	0	Credit card	-22
241216	5714692	2	Closed	currency 1	-259	0	-139.0	-230.0	0.0	0	10464.435	0.0	0.0	0	Consumer credit	-227
241216	5714693	2	Active	currency 1	-199	0	-14.0		0.0	0	40810.5	8055.0	0.0	0	Consumer credit	-22
242993	5714537	13	Closed	currency 1	-2785	0	-958.0	-1769.0		0	225000	0.0	0.0	0	Consumer credit	-908
242993	5714538	13	Closed	currency 1	-683	0	-654.0	-654.0		0	40500	0.0	0.0	0	Consumer credit	-624
242993	5714539	13	Closed	currency 1	-744	0	-717.0	-717.0		0	45000	0.0	0.0	0	Consumer credit	-624
242993	5714541	13	Closed	currency 1	-801	0	-773.0	-773.0		0	45000	0.0	0.0	0	Consumer credit	-624
242993	5714542	13	Closed	currency 1	-1841	0	-1473.0	-1466.0		0	225000	0.0	0.0	0	Consumer credit	-1195
242993	5714543	13	Active	currency 1	-2237	0	-1868.0			0	135000			0	Consumer credit	-1874
242993	5714544	13	Closed	currency 1	-1201	0	-1081.0	-987.0		0	157500			0	Consumer credit	-984
242993	5714545	13	Closed	currency 1	-1844	0	-1473.0	-987.0		0	225000			0	Consumer credit	-984
242993	5714547	13	Closed	currency 1	-705	0	-614.0	-586.0		0	158566.5			0	Consumer credit	-580
242993	5714548	13	Closed	currency 1	-605	0	-577.0	-577.0		0	13500			0	Consumer credit	-572
242993	5714549	13	Closed	currency 1	-564	0	-535.0	-535.0		0	45000			0	Consumer credit	-531
242993	5714550	13	Active	currency 1	-382	0	1464.0			0	58500	59809.5		0	Credit card	-341
242993	5714551	13	Closed	currency 1	-865	0	-742.0	-833.0	0.0	0	29250	0.0	0.0	0	Consumer credit	-833
253882	5714648	4	Closed	currency 1	-1341	0	-241.0	-749.0		0	0	0.0		0	Credit card	-747
253882	5714649	4	Active	currency 1	-758	0	1095.0			0	315000	54895.5		0	Credit card	0
253882	5714650	4	Closed	currency 1	-1531	0	-800.0	-805.0	0.0	0	138987	0.0	0.0	0	Consumer credit	-805
253882	5714651	4	Closed	currency 1	-770	0	-467.0	-467.0	0.0	0	50301	0.0	0.0	0	Consumer credit	-463
280788	5714715	4	Active	currency 1	-221	0	875.0			0	220675.5			0	Consumer credit	-30
280788	5714716	4	Active	currency 1	-221	0				0	90000			0	Credit card	-9
280788	5714717	4	Active	currency 1	-728	0	2.0		3520.8	0	112500	5926.5	0.0	0	Consumer credit	-27
280788	5714718	4	Closed	currency 1	-637	0	-120.0	-120.0	1856.34	0	56532.645	0.0	0.0	0	Consumer credit	-120
286014	5714690	1	Active	currency 1	-137	0	27460.0		0.0	0	22500	18765.63	76.59	0	Credit card	-31
293201	5714620	5	Closed	currency 1	-2730	0	-2454.0	-2514.0	0.0	0	14058	0.0	0.0	0	Consumer credit	-2514
293201	5714621	5	Closed	currency 1	-2389	0	-1365.0	-1780.0	11250.0	0	225000	-701.28	225701.28	0	Credit card	-1780
293201	5714622	5	Closed	currency 1	-2255	0	-1982.0	-1987.0	6492.42	0	46033.92	0.0	0.0	0	Consumer credit	-1981
293201	5714624	5	Active	currency 1	-1425	0	-757.0		0.0	0	4500	0.0	4500.0	0	Credit card	-695
293201	5714625	5	Closed	currency 1	-2540	0	-713.0	-2209.0		0	360000	0.0	0.0	0	Consumer credit	-1261
303740	5714552	4	Closed	currency 1	-1423	0	-1119.0	-1118.0		0	79744.5	0.0	0.0	0	Consumer credit	-1118
303740	5714553	4	Closed	currency 1	-666	0	-574.0	-574.0	0.0	0	36916.56	0.0	0.0	0	Consumer credit	-568
303740	5714554	4	Active	currency 1	-581	0			0.0	0	384750	263056.5	121690.17	0	Credit card	-22
303740	5714555	4	Closed	currency 1	-433	0	-320.0	-320.0	0.0	0	67500	0.0	0.0	0	Consumer credit	-316
311918	5714563	2	Closed	currency 1	-2904	0	-2723.0	-2723.0		0	32899.5	0.0		0	Consumer credit	-2723
311918	5714564	2	Active	currency 1	-146	0	37.0		0.0	0	59085	20835.0	0.0	0	Consumer credit	-24
335122	5714653	5	Closed	currency 1	-1189	0	-109.0	-874.0		0	225000	0.0	0.0	0	Consumer credit	-860
335122	5714654	5	Closed	currency 1	-2426	0	-600.0	-556.0		0	540000	0.0	0.0	0	Consumer credit	-188
335122	5714655	5	Active	currency 1	-644	0	1182.0			0	900000			0	Consumer credit	-30
335122	5714656	5	Active	currency 1	-885	0	210.0			0	900000			0	Consumer credit	-30
335122	5714657	5	Closed	currency 1	-2740	0	-2434.0	-2496.0	0.0	0	54000	0.0	0.0	0	Consumer credit	-2494
338464	5714626	8	Closed	currency 1	-2655	0	-2319.0	-2348.0	0.0	0	20165.4	0.0	0.0	0	Consumer credit	-831
338464	5714627	8	Closed	currency 1	-2539	0	-1427.0	-651.0	0.0	0	45000	0.0	0.0	0	Credit card	-651
338464	5714628	8	Closed	currency 1	-2343	0	-2008.0	-2219.0	0.0	0	19192.5	0.0	0.0	0	Consumer credit	-2219
338464	5714629	8	Closed	currency 1	-857	0	-523.0	-582.0	3285.0	0	33853.5	0.0	0.0	0	Consumer credit	-582
338464	5714630	8	Active	currency 1	-857	0	765.0		1704.78	0	45000	38294.37	6705.63	0	Credit card	-675
338464	5714631	8	Active	currency 1	-1131	0	-27.0			0	270000	0.0	0.0	0	Credit card	-17
338464	5714633	8	Closed	currency 1	-1706	0	-976.0	-1260.0		0	247500	0.0	0.0	0	Consumer credit	-538
338464	5714634	8	Active	currency 1	-140	0			0.0	0	144000	143019.0	980.28	0	Credit card	-22
351919	5714658	1	Active	currency 1	-769	0	1057.0			0	409500	295542.0	0.0	0	Consumer credit	-14
373324	5714674	14	Active	currency 1	-837	0	-453.0		0.0	0	0	-45.36	45.36	0	Credit card	-685
373324	5714675	14	Active	currency 1	-341	0	-160.0		0.0	0	63496.17	63496.17	0.0	0	Consumer credit	-234
373324	5714676	14	Closed	currency 1	-586	0	-402.0	-402.0		0	90180	0.0	0.0	0	Consumer credit	-400
373324	5714677	14	Closed	currency 1	-1439	0	-1134.0	-1123.0		0	60399	0.0	0.0	0	Consumer credit	-775
373324	5714679	14	Active	currency 1	-577	0	521.0			0	225000	45324.0	0.0	0	Credit card	-25
373324	5714681	14	Closed	currency 1	-2819	0	-2516.0	-2516.0		0	24903	0.0		0	Consumer credit	-2516
373324	5714682	14	Closed	currency 1	-2673	0	-2307.0	-2307.0		0	31788	0.0		0	Consumer credit	-2307
373324	5714683	14	Closed	currency 1	-1438	0	-1134.0	-1153.0		0	60399	0.0		0	Consumer credit	-1128
373324	5714684	14	Closed	currency 1	-1913	0	-1609.0	-1609.0		0	53410.5	0.0		0	Consumer credit	-1128
373324	5714685	14	Closed	currency 1	-1593	0	-1109.0	-987.0		0	79456.5			0	Consumer credit	-984
373324	5714686	14	Closed	currency 1	-986	0	-805.0	-740.0		0	68850			0	Consumer credit	-738
373324	5714687	14	Closed	currency 1	-2455	0	-2273.0	-1925.0	0.0	0	31410	0.0	0.0	0	Consumer credit	-1924
373324	5714688	14	Closed	currency 1	-2216	0	-2121.0	-2095.0	0.0	0	20002.5	0.0	0.0	0	Consumer credit	-2095
373324	5714689	14	Closed	currency 1	-1805	0		-320.0	0.0	0	13500	0.0	0.0	0	Credit card	-229
387080	5714598	14	Closed	currency 1	-983	0	-623.0	-900.0		0	52987.5	0.0	0.0	0	Consumer credit	-802
387080	5714600	14	Closed	currency 1	-1104	0	-738.0	-731.0		0	194400	0.0	0.0	0	Consumer credit	-731
387080	5714601	14	Closed	currency 1	-1766	0	-1219.0	-1256.0		0	135000	0.0	0.0	0	Consumer credit	-1252
387080	5714602	14	Active	currency 1	-1082	0	745.0			0	197820	105840.0	0.0	0	Consumer credit	-10
387080	5714603	14	Active	currency 1	-1239	0	-149.0			0	225000	185953.5	0.0	0	Credit card	-10
387080	5714604	14	Active	currency 1	-681	0	1145.0			0	328500	244791.0	0.0	0	Consumer credit	-10
387080	5714606	14	Closed	currency 1	-2897	0	-2350.0	-2357.0		0	67500			0	Consumer credit	-2357
387080	5714607	14	Closed	currency 1	-1603	0	-1299.0	-1087.0		0	70335	0.0		0	Consumer credit	-1087
387080	5714608	14	Closed	currency 1	-2093	0	-1949.0	-987.0		0	44968.5			0	Consumer credit	-984
387080	5714609	14	Active	currency 1	-69	0	263.0			0	84361.5			0	Consumer credit	-6
387080	5714610	14	Closed	currency 1	-2299	0	-1932.0	-1932.0	0.0	0	72600.75	0.0	0.0	0	Consumer credit	-1603
387080	5714611	14	Closed	currency 1	-549	0	-364.0	-488.0	0.0	0	37935	0.0	0.0	0	Consumer credit	-486
387080	5714612	14	Closed	currency 1	-388	0	-21.0	-84.0	0.0	0	98446.5	0.0	0.0	0	Consumer credit	-84
387080	5714614	14	Active	currency 1	-18	0	378.0		0.0	0	76500	76500.0	0.0	0	Consumer credit	-14
388421	5714587	4	Active	currency 1	-685	0	410.0		0.0	0	135000	0.0	135000.0	0	Credit card	-236
388421	5714590	4	Closed	currency 1	-325	0	223.0	-112.0		0	87286.5	0.0	0.0	0	Consumer credit	-106
388421	5714591	4	Active	currency 1	-674	0	1152.0			0	868500	662139.0	0.0	0	Consumer credit	-25
388421	5714593	4	Active	currency 1	-378	0	1449.0		0.0	0	991800			0	Consumer credit	-31
389074	5714667	3	Closed	currency 1	-957	0	-342.0	-341.0		0	13500	0.0	0.0	0	Credit card	-334
389074	5714668	3	Closed	currency 1	-705	0	-433.0	-404.0		0	135729			0	Consumer credit	-398
389074	5714669	3	Closed	currency 1	-1049	0	-378.0	-378.0	0.0	0	113496.885	0.0	0.0	0	Consumer credit	-372
389599	5714529	7	Closed	currency 1	-672	0	10285.0	-531.0		0	135000	0.0	0.0	0	Credit card	-429
389599	5714530	7	Closed	currency 1	-1304	0	1253.0	-1287.0		0	225000	0.0	0.0	0	Consumer credit	-429
389599	5714531	7	Closed	currency 1	-1253	0	-887.0	-887.0		0	43105.5	0.0	0.0	0	Consumer credit	-687
389599	5714532	7	Closed	currency 1	-1130	0	331.0	-858.0		0	450000	0.0	0.0	0	Consumer credit	-847
389599	5714533	7	Active	currency 1	-831	0	277.0			0	270000	274225.5	0.0	0	Credit card	-10
389599	5714534	7	Active	currency 1	-329	0	1497.0			0	589500	521478.0	0.0	0	Consumer credit	-8
389599	5714536	7	Closed	currency 1	-700	0	-600.0	-600.0	0.0	0	68715	0.0	0.0	0	Consumer credit	-596
399459	5714708	2	Closed	currency 1	-1141	0	-837.0	-784.0		0	113359.5			0	Consumer credit	-781
399459	5714709	2	Active	currency 1	-49	0	316.0		0.0	0	24763.5	22968.0	0.0	0	Consumer credit	-19
400486	5714504	5	Closed	currency 1	-2413	0	-1864.0	-2128.0		0	180000	0.0	0.0	0	Consumer credit	-708
400486	5714506	5	Active	currency 1	-941	0	-17.0			0	40500	0.0	0.0	0	Credit card	-15
400486	5714507	5	Closed	currency 1	-1110	0	-745.0	-727.0		0	114727.5	0.0	0.0	0	Consumer credit	-658
400486	5714508	5	Closed	currency 1	-2133	0	-1038.0	-1127.0		0	225000	0.0	0.0	0	Consumer credit	-708
400486	5714509	5	Active	currency 1	-391	0	705.0			0	142290	108315.0	0.0	0	Consumer credit	-30
402440	5714475	1	Active	currency 1	-96	0	269.0		0.0	0	89910	76905.0	0.0	0	Consumer credit	-22
406724	5714661	4	Closed	currency 1	-1293	0	-1155.0	-1155.0		0	13500	0.0	0.0	0	Credit card	-775
406724	5714662	4	Closed	currency 1	-1433	0	-1251.0	-1245.0		0	23067	0.0	0.0	0	Consumer credit	-783
406724	5714663	4	Closed	currency 1	-1432	0	-1251.0	-1251.0		0	23067	0.0		0	Consumer credit	-1142
406724	5714665	4	Active	currency 1	-167	0	1298.0		0.0	0	606496.995	574827.21	0.0	0	Consumer credit	-5
419892	5714594	4	Closed	currency 1	-1697	0	-1148.0	-1148.0		0	70695	0.0	0.0	0	Consumer credit	-696
419892	5714595	4	Closed	currency 1	-1238	0	-878.0	-1120.0		0	22320	0.0	0.0	0	Consumer credit	-1119
419892	5714596	4	Active	currency 1	-381	0				0	2767500	2739622.5		0	Mortgage	-27
419892	5714597	4	Closed	currency 1	-584	0	511.0	-405.0	0.0	0	238603.5	0.0	0.0	0	Consumer credit	-405
426155	5714498	4	Closed	currency 1	-1331	0	-994.0	-1023.0	1350.0	0	39433.5	0.0	0.0	0	Consumer credit	-1023
426155	5714499	4	Closed	currency 1	-2534	0	-2352.0	-2347.0		0	38830.5	0.0	0.0	0	Consumer credit	-2345
426155	5714500	4	Closed	currency 1	-845	0	-480.0	-480.0	0.0	0	67500	0.0	0.0	0	Consumer credit	-480
426155	5714501	4	Closed	currency 1	-529	0	-343.0	-343.0	0.0	0	182791.44	0.0	0.0	0	Consumer credit	-337
435112	5714512	11	Closed	currency 1	-1412	0	-861.0	-849.0		0	85288.5	0.0	0.0	0	Consumer credit	-753
435112	5714513	11	Closed	currency 1	-1590	0	-1344.0	-1276.0		0	100129.5	0.0	0.0	0	Consumer credit	-783
435112	5714514	11	Closed	currency 1	-1181	0	-875.0	-872.0		0	44419.5	0.0	0.0	0	Consumer credit	-872
435112	5714516	11	Closed	currency 1	-1475	0	-1293.0	-1322.0		0	21690	0.0		0	Consumer credit	-1322
435112	5714517	11	Closed	currency 1	-1411	0	-861.0	-861.0		0	85293	0.0		0	Consumer credit	-855
435112	5714518	11	Active	currency 1	-1483	0				0	200250	0.0		0	Credit card	-848
435112	5714519	11	Closed	currency 1	-1589	0	-1344.0	-1292.0	3980.52	0	100129.5	0.0	0.0	0	Consumer credit	-736
435112	5714520	11	Closed	currency 1	-829	0	-508.0	-508.0	0.0	0	159386.085	0.0	0.0	0	Consumer credit	-508
435112	5714521	11	Closed	currency 1	-739	0	-525.0	-525.0	0.0	0	48645	0.0	0.0	0	Consumer credit	-519
435112	5714522	11	Active	currency 1	-508	0	1318.0		0.0	0	1058823.54	858768.57	0.0	0	Consumer credit	-7
435112	5714523	11	Active	currency 1	-416	0	680.0		0.0	0	256500	183528.0	0.0	0	Consumer credit	-43
444864	5714635	12	Closed	currency 1	-2209	0	-2086.0	-2115.0	0.0	0	16645.5	0.0	0.0	0	Consumer credit	-2115
444864	5714636	12	Closed	currency 1	-2130	0	-1886.0	-1883.0		0	66600	0.0	0.0	0	Consumer credit	-791
444864	5714637	12	Closed	currency 1	-1125	0	-881.0	-881.0		0	82795.5	0.0	0.0	0	Consumer credit	-752
444864	5714638	12	Closed	currency 1	-1872	0	-1568.0	-1549.0		0	49936.5	0.0	0.0	0	Consumer credit	-801
444864	5714639	12	Closed	currency 1	-2030	0	31111.0	-1750.0		0	85050	0.0	0.0	0	Credit card	-555
444864	5714640	12	Closed	currency 1	-1776	0	-680.0	-712.0		0	157500	0.0	0.0	0	Consumer credit	-188
444864	5714642	12	Closed	currency 1	-1124	0	-881.0	-881.0		0	82795.5	0.0		0	Consumer credit	-876
444864	5714643	12	Closed	currency 1	-1871	0	-1568.0	-1568.0		0	49936.5	0.0		0	Consumer credit	-820
444864	5714644	12	Closed	currency 1	-2129	0	-1886.0	-1886.0		0	66600	0.0		0	Consumer credit	-820
444864	5714645	12	Closed	currency 1	-1416	0	-685.0	-685.0	0.0	0	182119.5	0.0	0.0	0	Consumer credit	-680
444864	5714646	12	Closed	currency 1	-312	0	-130.0	-130.0	0.0	0	52488	0.0	0.0	0	Consumer credit	-127
444864	5714647	12	Active	currency 1	-286	0			0.0	0	364500	0.0	364500.0	0	Credit card	-29
452585	5714524	4	Closed	currency 1	-2642	0	-2307.0	-2332.0	1800.0	0	15921	0.0	0.0	0	Consumer credit	-2306
452585	5714525	4	Active	currency 1	-2538	0	-1427.0		0.0	0	45000	0.0	0.0	0	Credit card	-682
452585	5714527	4	Active	currency 1	-42	0	-26.0			0	45000	54000.0	0.0	0	Consumer credit	-31
452585	5714528	4	Closed	currency 1	-2898	0	-2722.0	-2344.0		0	11340			0	Consumer credit	-2344
select * from t2;
id	c2	cnt	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16
119939	5714566	17	Closed	currency 1	-2279	0	-1945.0	-2033.0	0.0	0	39541.5	0.0	0.0	0	Consumer credit	-2033
119939	5714567	17	Closed	currency 1	-2247	0	-1123.0	-1733.0	0.0	0	135000	0.0	0.0	0	Credit card	-1733
119939	5714568	17	Closed	currency 1	-1447	0	-331.0	-1272.0	0.0	0	99000	-2692.17	137692.17	0	Credit card	-1272
119939	5714569	17	Closed	currency 1	-1390	0	-331.0	-1263.0	0.0	0	135000	-149.04	135149.04	0	Credit card	-1263
119939	5714570	17	Active	currency 1	-1390	0	-696.0		0.0	0	4500	-2.565	2.565	0	Credit card	-691
119939	5714571	17	Active	currency 1	-733	0	1100.0		0.0	0	337500	242596.395	94903.605	0	Credit card	-687
119939	5714573	17	Closed	currency 1	-1188	0	1369.0	-1090.0		0	450000	0.0	0.0	0	Consumer credit	-429
119939	5714574	17	Closed	currency 1	-437	0	1389.0	-225.0		0	1226250	0.0	0.0	0	Consumer credit	-194
119939	5714575	17	Closed	currency 1	-944	0	335.0	-548.0		0	1215000	0.0	0.0	0	Consumer credit	-513
119939	5714577	17	Active	currency 1	-1102	0	4.0			0	225000	210730.5	0.0	0	Credit card	-10
119939	5714578	17	Closed	currency 1	-1572	0	-1179.0	-987.0		0	225000			0	Consumer credit	-984
119939	5714579	17	Closed	currency 1	-1791	0	-1703.0	-987.0		0	22770			0	Consumer credit	-984
119939	5714580	17	Active	currency 1	-2401	0			0.0	0	99000	45036.0	53962.695	0	Credit card	-22
119939	5714581	17	Closed	currency 1	-1624	0	203.0	-1085.0	40.5	0	765000			0	Consumer credit	-1085
119939	5714582	17	Closed	currency 1	-1617	0	9341.0	-1083.0	6007.5	0	144000			0	Credit card	-1083
119939	5714583	17	Closed	currency 1	-937	0	889.0	-156.0	0.0	0	675000			0	Consumer credit	-156
119939	5714585	17	Active	currency 1	-314	0	1512.0		0.0	0	900000			0	Consumer credit	-40
136226	5714502	2	Active	currency 1	-521	0	551.0			0	112500	0.0	0.0	0	Credit card	-30
136226	5714503	2	Closed	currency 1	-559	0		-355.0	0.0	0	110250	0.0	0.0	0	Credit card	-351
162297	5714469	6	Closed	currency 1	-1896	0	-1684.0	-1710.0	14985.0	0	76878.45	0.0	0.0	0	Consumer credit	-1710
162297	5714470	6	Closed	currency 1	-1146	0	-811.0	-840.0	0.0	0	103007.7	0.0	0.0	0	Consumer credit	-840
162297	5714471	6	Active	currency 1	-1146	0	-484.0		0.0	0	4500	0.0	0.0	0	Credit card	-690
162297	5714472	6	Active	currency 1	-1146	0	-180.0		0.0	0	337500	0.0	0.0	0	Credit card	-690
162297	5714473	6	Closed	currency 1	-2456	0	-629.0	-825.0		0	675000	0.0	0.0	0	Consumer credit	-706
162297	5714474	6	Active	currency 1	-277	0	5261.0		0.0	0	7033500			0	Mortgage	-31
166034	5714697	8	Closed	currency 1	-1283	0	-1069.0	-1083.0	3727.89	0	19399.5	0.0	0.0	0	Consumer credit	-1068
166034	5714698	8	Closed	currency 1	-828	0	-613.0	-642.0	13590.0	0	70692.84	0.0	0.0	0	Consumer credit	-642
166034	5714699	8	Active	currency 1	-828	0	916.0		0.0	0	4500	0.0	4500.0	0	Credit card	-676
166034	5714700	8	Closed	currency 1	-1207	0	-1021.0	-1021.0		0	93240	0.0	0.0	0	Consumer credit	-981
166034	5714701	8	Active	currency 1	-706	0	369.0			0	459000	483534.0	0.0	0	Credit card	-4
166034	5714702	8	Active	currency 1	-262	0	103.0			0	450000	174519.0		0	Consumer credit	-7
166034	5714704	8	Active	currency 1	-718	0			2189.205	0	45000	43357.5	1638.765	0	Credit card	-22
166034	5714705	8	Closed	currency 1	-612	0	-245.0	-207.0	13225.725	0	178335	0.0	0.0	0	Consumer credit	-206
173404	5714710	4	Closed	currency 1	-1103	0	-304.0	-303.0		0	216000	0.0	0.0	0	Credit card	-303
173404	5714711	4	Closed	currency 1	-1166	0	-915.0	-915.0		0	107037	0.0	0.0	0	Consumer credit	-752
173404	5714712	4	Active	currency 1	-45	0	320.0			0	234000	234000.0	0.0	0	Consumer credit	-26
173404	5714713	4	Closed	currency 1	-1165	0	-860.0	-915.0	0.0	0	107037	0.0	0.0	0	Consumer credit	-825
215354	5714462	7	Closed	currency 1	-497	0	-153.0	-153.0		0	91323	0.0		0	Consumer credit	-131
215354	5714463	7	Active	currency 1	-208	0	1075.0			0	225000	171342.0		0	Credit card	-20
215354	5714464	7	Active	currency 1	-203	0	528.0			0	464323.5			0	Consumer credit	-16
215354	5714465	7	Active	currency 1	-203	0				0	90000			0	Credit card	-16
215354	5714466	7	Active	currency 1	-629	0	1197.0		77674.5	0	2700000			0	Consumer credit	-21
215354	5714467	7	Active	currency 1	-273	0	27460.0		0.0	0	180000	71017.38	108982.62	0	Credit card	-31
215354	5714468	7	Active	currency 1	-43	0	79.0		0.0	0	42103.8	42103.8	0.0	0	Consumer credit	-22
222183	5714491	6	Active	currency 1	-784	0	1008.0		0.0	0	0	-411.615	411.615	0	Credit card	-694
222183	5714492	6	Active	currency 1	-774	0	625.0			0	127840.5	0.0	0.0	0	Credit card	-210
222183	5714493	6	Active	currency 1	-395	0	1431.0			0	1350000	1185493.5	0.0	0	Consumer credit	-24
222183	5714495	6	Closed	currency 1	-2744	0	-2561.0	-2559.0	310.5	0	18157.5			0	Consumer credit	-2559
222183	5714496	6	Closed	currency 1	-1103	0	-7.0	-343.0	20493.27	0	675000	0.0	0.0	0	Consumer credit	-343
222183	5714497	6	Active	currency 1	-315	0	1512.0		88821.0	0	3709552.5			0	Car loan	-32
234931	5714557	6	Active	currency 1	-1272	0	-667.0			0	135000	17982.0	0.0	0	Consumer credit	-721
234931	5714558	6	Closed	currency 1	-1602	0	-1332.0	-987.0		0	42894			0	Consumer credit	-984
234931	5714559	6	Closed	currency 1	-1273	0	-667.0	-649.0		0	135000			0	Consumer credit	-643
234931	5714560	6	Closed	currency 1	-371	0	-130.0	-130.0		0	63522	0.0		0	Consumer credit	-110
234931	5714561	6	Closed	currency 1	-2638	0	-1208.0	-1518.0	18293.265	0	1143000	0.0	0.0	0	Car loan	-704
234931	5714562	6	Closed	currency 1	-1495	0	-635.0	-40.0	12618.0	0	46831.5			0	Consumer credit	-34
238881	5714482	7	Closed	currency 1	-318	0	-187.0	-187.0		0	0	0.0	0.0	0	Credit card	-185
238881	5714484	7	Closed	currency 1	-2911	0	-2607.0	-2604.0		0	48555			0	Consumer credit	-2601
238881	5714485	7	Closed	currency 1	-2148	0	-1595.0	-987.0		0	135000			0	Consumer credit	-984
238881	5714486	7	Active	currency 1	-381	0				0	450000	520920.0		0	Consumer credit	-4
238881	5714487	7	Active	currency 1	-95	0	1720.0			0	67500	8131.5		0	Credit card	-7
238881	5714488	7	Closed	currency 1	-444	0	-77.0	-77.0	0.0	0	107184.06	0.0	0.0	0	Consumer credit	-71
238881	5714489	7	Active	currency 1	-392	0			0.0	0	252000	23679.0	228320.1	0	Credit card	-22
241216	5714692	2	Closed	currency 1	-259	0	-139.0	-230.0	0.0	0	10464.435	0.0	0.0	0	Consumer credit	-227
241216	5714693	2	Active	currency 1	-199	0	-14.0		0.0	0	40810.5	8055.0	0.0	0	Consumer credit	-22
242993	5714537	13	Closed	currency 1	-2785	0	-958.0	-1769.0		0	225000	0.0	0.0	0	Consumer credit	-908
242993	5714538	13	Closed	currency 1	-683	0	-654.0	-654.0		0	40500	0.0	0.0	0	Consumer credit	-624
242993	5714539	13	Closed	currency 1	-744	0	-717.0	-717.0		0	45000	0.0	0.0	0	Consumer credit	-624
242993	5714541	13	Closed	currency 1	-801	0	-773.0	-773.0		0	45000	0.0	0.0	0	Consumer credit	-624
242993	5714542	13	Closed	currency 1	-1841	0	-1473.0	-1466.0		0	225000	0.0	0.0	0	Consumer credit	-1195
242993	5714543	13	Active	currency 1	-2237	0	-1868.0			0	135000			0	Consumer credit	-1874
242993	5714544	13	Closed	currency 1	-1201	0	-1081.0	-987.0		0	157500			0	Consumer credit	-984
242993	5714545	13	Closed	currency 1	-1844	0	-1473.0	-987.0		0	225000			0	Consumer credit	-984
242993	5714547	13	Closed	currency 1	-705	0	-614.0	-586.0		0	158566.5			0	Consumer credit	-580
242993	5714548	13	Closed	currency 1	-605	0	-577.0	-577.0		0	13500			0	Consumer credit	-572
242993	5714549	13	Closed	currency 1	-564	0	-535.0	-535.0		0	45000			0	Consumer credit	-531
242993	5714550	13	Active	currency 1	-382	0	1464.0			0	58500	59809.5		0	Credit card	-341
242993	5714551	13	Closed	currency 1	-865	0	-742.0	-833.0	0.0	0	29250	0.0	0.0	0	Consumer credit	-833
253882	5714648	4	Closed	currency 1	-1341	0	-241.0	-749.0		0	0	0.0		0	Credit card	-747
253882	5714649	4	Active	currency 1	-758	0	1095.0			0	315000	54895.5		0	Credit card	0
253882	5714650	4	Closed	currency 1	-1531	0	-800.0	-805.0	0.0	0	138987	0.0	0.0	0	Consumer credit	-805
253882	5714651	4	Closed	currency 1	-770	0	-467.0	-467.0	0.0	0	50301	0.0	0.0	0	Consumer credit	-463
280788	5714715	4	Active	currency 1	-221	0	875.0			0	220675.5			0	Consumer credit	-30
280788	5714716	4	Active	currency 1	-221	0				0	90000			0	Credit card	-9
280788	5714717	4	Active	currency 1	-728	0	2.0		3520.8	0	112500	5926.5	0.0	0	Consumer credit	-27
280788	5714718	4	Closed	currency 1	-637	0	-120.0	-120.0	1856.34	0	56532.645	0.0	0.0	0	Consumer credit	-120
286014	5714690	1	Active	currency 1	-137	0	27460.0		0.0	0	22500	18765.63	76.59	0	Credit card	-31
293201	5714620	5	Closed	currency 1	-2730	0	-2454.0	-2514.0	0.0	0	14058	0.0	0.0	0	Consumer credit	-2514
293201	5714621	5	Closed	currency 1	-2389	0	-1365.0	-1780.0	11250.0	0	225000	-701.28	225701.28	0	Credit card	-1780
293201	5714622	5	Closed	currency 1	-2255	0	-1982.0	-1987.0	6492.42	0	46033.92	0.0	0.0	0	Consumer credit	-1981
293201	5714624	5	Active	currency 1	-1425	0	-757.0		0.0	0	4500	0.0	4500.0	0	Credit card	-695
293201	5714625	5	Closed	currency 1	-2540	0	-713.0	-2209.0		0	360000	0.0	0.0	0	Consumer credit	-1261
303740	5714552	4	Closed	currency 1	-1423	0	-1119.0	-1118.0		0	79744.5	0.0	0.0	0	Consumer credit	-1118
303740	5714553	4	Closed	currency 1	-666	0	-574.0	-574.0	0.0	0	36916.56	0.0	0.0	0	Consumer credit	-568
303740	5714554	4	Active	currency 1	-581	0			0.0	0	384750	263056.5	121690.17	0	Credit card	-22
303740	5714555	4	Closed	currency 1	-433	0	-320.0	-320.0	0.0	0	67500	0.0	0.0	0	Consumer credit	-316
311918	5714563	2	Closed	currency 1	-2904	0	-2723.0	-2723.0		0	32899.5	0.0		0	Consumer credit	-2723
311918	5714564	2	Active	currency 1	-146	0	37.0		0.0	0	59085	20835.0	0.0	0	Consumer credit	-24
335122	5714653	5	Closed	currency 1	-1189	0	-109.0	-874.0		0	225000	0.0	0.0	0	Consumer credit	-860
335122	5714654	5	Closed	currency 1	-2426	0	-600.0	-556.0		0	540000	0.0	0.0	0	Consumer credit	-188
335122	5714655	5	Active	currency 1	-644	0	1182.0			0	900000			0	Consumer credit	-30
335122	5714656	5	Active	currency 1	-885	0	210.0			0	900000			0	Consumer credit	-30
335122	5714657	5	Closed	currency 1	-2740	0	-2434.0	-2496.0	0.0	0	54000	0.0	0.0	0	Consumer credit	-2494
338464	5714626	8	Closed	currency 1	-2655	0	-2319.0	-2348.0	0.0	0	20165.4	0.0	0.0	0	Consumer credit	-831
338464	5714627	8	Closed	currency 1	-2539	0	-1427.0	-651.0	0.0	0	45000	0.0	0.0	0	Credit card	-651
338464	5714628	8	Closed	currency 1	-2343	0	-2008.0	-2219.0	0.0	0	19192.5	0.0	0.0	0	Consumer credit	-2219
338464	5714629	8	Closed	currency 1	-857	0	-523.0	-582.0	3285.0	0	33853.5	0.0	0.0	0	Consumer credit	-582
338464	5714630	8	Active	currency 1	-857	0	765.0		1704.78	0	45000	38294.37	6705.63	0	Credit card	-675
338464	5714631	8	Active	currency 1	-1131	0	-27.0			0	270000	0.0	0.0	0	Credit card	-17
338464	5714633	8	Closed	currency 1	-1706	0	-976.0	-1260.0		0	247500	0.0	0.0	0	Consumer credit	-538
338464	5714634	8	Active	currency 1	-140	0			0.0	0	144000	143019.0	980.28	0	Credit card	-22
351919	5714658	1	Active	currency 1	-769	0	1057.0			0	409500	295542.0	0.0	0	Consumer credit	-14
373324	5714674	14	Active	currency 1	-837	0	-453.0		0.0	0	0	-45.36	45.36	0	Credit card	-685
373324	5714675	14	Active	currency 1	-341	0	-160.0		0.0	0	63496.17	63496.17	0.0	0	Consumer credit	-234
373324	5714676	14	Closed	currency 1	-586	0	-402.0	-402.0		0	90180	0.0	0.0	0	Consumer credit	-400
373324	5714677	14	Closed	currency 1	-1439	0	-1134.0	-1123.0		0	60399	0.0	0.0	0	Consumer credit	-775
373324	5714679	14	Active	currency 1	-577	0	521.0			0	225000	45324.0	0.0	0	Credit card	-25
373324	5714681	14	Closed	currency 1	-2819	0	-2516.0	-2516.0		0	24903	0.0		0	Consumer credit	-2516
373324	5714682	14	Closed	currency 1	-2673	0	-2307.0	-2307.0		0	31788	0.0		0	Consumer credit	-2307
373324	5714683	14	Closed	currency 1	-1438	0	-1134.0	-1153.0		0	60399	0.0		0	Consumer credit	-1128
373324	5714684	14	Closed	currency 1	-1913	0	-1609.0	-1609.0		0	53410.5	0.0		0	Consumer credit	-1128
373324	5714685	14	Closed	currency 1	-1593	0	-1109.0	-987.0		0	79456.5			0	Consumer credit	-984
373324	5714686	14	Closed	currency 1	-986	0	-805.0	-740.0		0	68850			0	Consumer credit	-738
373324	5714687	14	Closed	currency 1	-2455	0	-2273.0	-1925.0	0.0	0	31410	0.0	0.0	0	Consumer credit	-1924
373324	5714688	14	Closed	currency 1	-2216	0	-2121.0	-2095.0	0.0	0	20002.5	0.0	0.0	0	Consumer credit	-2095
373324	5714689	14	Closed	currency 1	-1805	0		-320.0	0.0	0	13500	0.0	0.0	0	Credit card	-229
387080	5714598	14	Closed	currency 1	-983	0	-623.0	-900.0		0	52987.5	0.0	0.0	0	Consumer credit	-802
387080	5714600	14	Closed	currency 1	-1104	0	-738.0	-731.0		0	194400	0.0	0.0	0	Consumer credit	-731
387080	5714601	14	Closed	currency 1	-1766	0	-1219.0	-1256.0		0	135000	0.0	0.0	0	Consumer credit	-1252
387080	5714602	14	Active	currency 1	-1082	0	745.0			0	197820	105840.0	0.0	0	Consumer credit	-10
387080	5714603	14	Active	currency 1	-1239	0	-149.0			0	225000	185953.5	0.0	0	Credit card	-10
387080	5714604	14	Active	currency 1	-681	0	1145.0			0	328500	244791.0	0.0	0	Consumer credit	-10
387080	5714606	14	Closed	currency 1	-2897	0	-2350.0	-2357.0		0	67500			0	Consumer credit	-2357
387080	5714607	14	Closed	currency 1	-1603	0	-1299.0	-1087.0		0	70335	0.0		0	Consumer credit	-1087
387080	5714608	14	Closed	currency 1	-2093	0	-1949.0	-987.0		0	44968.5			0	Consumer credit	-984
387080	5714609	14	Active	currency 1	-69	0	263.0			0	84361.5			0	Consumer credit	-6
387080	5714610	14	Closed	currency 1	-2299	0	-1932.0	-1932.0	0.0	0	72600.75	0.0	0.0	0	Consumer credit	-1603
387080	5714611	14	Closed	currency 1	-549	0	-364.0	-488.0	0.0	0	37935	0.0	0.0	0	Consumer credit	-486
387080	5714612	14	Closed	currency 1	-388	0	-21.0	-84.0	0.0	0	98446.5	0.0	0.0	0	Consumer credit	-84
387080	5714614	14	Active	currency 1	-18	0	378.0		0.0	0	76500	76500.0	0.0	0	Consumer credit	-14
388421	5714587	4	Active	currency 1	-685	0	410.0		0.0	0	135000	0.0	135000.0	0	Credit card	-236
388421	5714590	4	Closed	currency 1	-325	0	223.0	-112.0		0	87286.5	0.0	0.0	0	Consumer credit	-106
388421	5714591	4	Active	currency 1	-674	0	1152.0			0	868500	662139.0	0.0	0	Consumer credit	-25
388421	5714593	4	Active	currency 1	-378	0	1449.0		0.0	0	991800			0	Consumer credit	-31
389074	5714667	3	Closed	currency 1	-957	0	-342.0	-341.0		0	13500	0.0	0.0	0	Credit card	-334
389074	5714668	3	Closed	currency 1	-705	0	-433.0	-404.0		0	135729			0	Consumer credit	-398
389074	5714669	3	Closed	currency 1	-1049	0	-378.0	-378.0	0.0	0	113496.885	0.0	0.0	0	Consumer credit	-372
389599	5714529	7	Closed	currency 1	-672	0	10285.0	-531.0		0	135000	0.0	0.0	0	Credit card	-429
389599	5714530	7	Closed	currency 1	-1304	0	1253.0	-1287.0		0	225000	0.0	0.0	0	Consumer credit	-429
389599	5714531	7	Closed	currency 1	-1253	0	-887.0	-887.0		0	43105.5	0.0	0.0	0	Consumer credit	-687
389599	5714532	7	Closed	currency 1	-1130	0	331.0	-858.0		0	450000	0.0	0.0	0	Consumer credit	-847
389599	5714533	7	Active	currency 1	-831	0	277.0			0	270000	274225.5	0.0	0	Credit card	-10
389599	5714534	7	Active	currency 1	-329	0	1497.0			0	589500	521478.0	0.0	0	Consumer credit	-8
389599	5714536	7	Closed	currency 1	-700	0	-600.0	-600.0	0.0	0	68715	0.0	0.0	0	Consumer credit	-596
399459	5714708	2	Closed	currency 1	-1141	0	-837.0	-784.0		0	113359.5			0	Consumer credit	-781
399459	5714709	2	Active	currency 1	-49	0	316.0		0.0	0	24763.5	22968.0	0.0	0	Consumer credit	-19
400486	5714504	5	Closed	currency 1	-2413	0	-1864.0	-2128.0		0	180000	0.0	0.0	0	Consumer credit	-708
400486	5714506	5	Active	currency 1	-941	0	-17.0			0	40500	0.0	0.0	0	Credit card	-15
400486	5714507	5	Closed	currency 1	-1110	0	-745.0	-727.0		0	114727.5	0.0	0.0	0	Consumer credit	-658
400486	5714508	5	Closed	currency 1	-2133	0	-1038.0	-1127.0		0	225000	0.0	0.0	0	Consumer credit	-708
400486	5714509	5	Active	currency 1	-391	0	705.0			0	142290	108315.0	0.0	0	Consumer credit	-30
402440	5714475	1	Active	currency 1	-96	0	269.0		0.0	0	89910	76905.0	0.0	0	Consumer credit	-22
406724	5714661	4	Closed	currency 1	-1293	0	-1155.0	-1155.0		0	13500	0.0	0.0	0	Credit card	-775
406724	5714662	4	Closed	currency 1	-1433	0	-1251.0	-1245.0		0	23067	0.0	0.0	0	Consumer credit	-783
406724	5714663	4	Closed	currency 1	-1432	0	-1251.0	-1251.0		0	23067	0.0		0	Consumer credit	-1142
406724	5714665	4	Active	currency 1	-167	0	1298.0		0.0	0	606496.995	574827.21	0.0	0	Consumer credit	-5
419892	5714594	4	Closed	currency 1	-1697	0	-1148.0	-1148.0		0	70695	0.0	0.0	0	Consumer credit	-696
419892	5714595	4	Closed	currency 1	-1238	0	-878.0	-1120.0		0	22320	0.0	0.0	0	Consumer credit	-1119
419892	5714596	4	Active	currency 1	-381	0				0	2767500	2739622.5		0	Mortgage	-27
419892	5714597	4	Closed	currency 1	-584	0	511.0	-405.0	0.0	0	238603.5	0.0	0.0	0	Consumer credit	-405
426155	5714498	4	Closed	currency 1	-1331	0	-994.0	-1023.0	1350.0	0	39433.5	0.0	0.0	0	Consumer credit	-1023
426155	5714499	4	Closed	currency 1	-2534	0	-2352.0	-2347.0		0	38830.5	0.0	0.0	0	Consumer credit	-2345
426155	5714500	4	Closed	currency 1	-845	0	-480.0	-480.0	0.0	0	67500	0.0	0.0	0	Consumer credit	-480
426155	5714501	4	Closed	currency 1	-529	0	-343.0	-343.0	0.0	0	182791.44	0.0	0.0	0	Consumer credit	-337
435112	5714512	11	Closed	currency 1	-1412	0	-861.0	-849.0		0	85288.5	0.0	0.0	0	Consumer credit	-753
435112	5714513	11	Closed	currency 1	-1590	0	-1344.0	-1276.0		0	100129.5	0.0	0.0	0	Consumer credit	-783
435112	5714514	11	Closed	currency 1	-1181	0	-875.0	-872.0		0	44419.5	0.0	0.0	0	Consumer credit	-872
435112	5714516	11	Closed	currency 1	-1475	0	-1293.0	-1322.0		0	21690	0.0		0	Consumer credit	-1322
435112	5714517	11	Closed	currency 1	-1411	0	-861.0	-861.0		0	85293	0.0		0	Consumer credit	-855
435112	5714518	11	Active	currency 1	-1483	0				0	200250	0.0		0	Credit card	-848
435112	5714519	11	Closed	currency 1	-1589	0	-1344.0	-1292.0	3980.52	0	100129.5	0.0	0.0	0	Consumer credit	-736
435112	5714520	11	Closed	currency 1	-829	0	-508.0	-508.0	0.0	0	159386.085	0.0	0.0	0	Consumer credit	-508
435112	5714521	11	Closed	currency 1	-739	0	-525.0	-525.0	0.0	0	48645	0.0	0.0	0	Consumer credit	-519
435112	5714522	11	Active	currency 1	-508	0	1318.0		0.0	0	1058823.54	858768.57	0.0	0	Consumer credit	-7
435112	5714523	11	Active	currency 1	-416	0	680.0		0.0	0	256500	183528.0	0.0	0	Consumer credit	-43
444864	5714635	12	Closed	currency 1	-2209	0	-2086.0	-2115.0	0.0	0	16645.5	0.0	0.0	0	Consumer credit	-2115
444864	5714636	12	Closed	currency 1	-2130	0	-1886.0	-1883.0		0	66600	0.0	0.0	0	Consumer credit	-791
444864	5714637	12	Closed	currency 1	-1125	0	-881.0	-881.0		0	82795.5	0.0	0.0	0	Consumer credit	-752
444864	5714638	12	Closed	currency 1	-1872	0	-1568.0	-1549.0		0	49936.5	0.0	0.0	0	Consumer credit	-801
444864	5714639	12	Closed	currency 1	-2030	0	31111.0	-1750.0		0	85050	0.0	0.0	0	Credit card	-555
444864	5714640	12	Closed	currency 1	-1776	0	-680.0	-712.0		0	157500	0.0	0.0	0	Consumer credit	-188
444864	5714642	12	Closed	currency 1	-1124	0	-881.0	-881.0		0	82795.5	0.0		0	Consumer credit	-876
444864	5714643	12	Closed	currency 1	-1871	0	-1568.0	-1568.0		0	49936.5	0.0		0	Consumer credit	-820
444864	5714644	12	Closed	currency 1	-2129	0	-1886.0	-1886.0		0	66600	0.0		0	Consumer credit	-820
444864	5714645	12	Closed	currency 1	-1416	0	-685.0	-685.0	0.0	0	182119.5	0.0	0.0	0	Consumer credit	-680
444864	5714646	12	Closed	currency 1	-312	0	-130.0	-130.0	0.0	0	52488	0.0	0.0	0	Consumer credit	-127
444864	5714647	12	Active	currency 1	-286	0			0.0	0	364500	0.0	364500.0	0	Credit card	-29
452585	5714524	4	Closed	currency 1	-2642	0	-2307.0	-2332.0	1800.0	0	15921	0.0	0.0	0	Consumer credit	-2306
452585	5714525	4	Active	currency 1	-2538	0	-1427.0		0.0	0	45000	0.0	0.0	0	Credit card	-682
452585	5714527	4	Active	currency 1	-42	0	-26.0			0	45000	54000.0	0.0	0	Consumer credit	-31
452585	5714528	4	Closed	currency 1	-2898	0	-2722.0	-2344.0		0	11340			0	Consumer credit	-2344
select * from t3;
id	c2	cnt	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16
119939	5714566	17	Closed	currency 1	-2279	0	-1945.0	-2033.0	0.0	0	39541.5	0.0	0.0	0	Consumer credit	-2033
119939	5714567	17	Closed	currency 1	-2247	0	-1123.0	-1733.0	0.0	0	135000	0.0	0.0	0	Credit card	-1733
119939	5714568	17	Closed	currency 1	-1447	0	-331.0	-1272.0	0.0	0	99000	-2692.17	137692.17	0	Credit card	-1272
119939	5714569	17	Closed	currency 1	-1390	0	-331.0	-1263.0	0.0	0	135000	-149.04	135149.04	0	Credit card	-1263
119939	5714570	17	Active	currency 1	-1390	0	-696.0		0.0	0	4500	-2.565	2.565	0	Credit card	-691
119939	5714571	17	Active	currency 1	-733	0	1100.0		0.0	0	337500	242596.395	94903.605	0	Credit card	-687
119939	5714573	17	Closed	currency 1	-1188	0	1369.0	-1090.0		0	450000	0.0	0.0	0	Consumer credit	-429
119939	5714574	17	Closed	currency 1	-437	0	1389.0	-225.0		0	1226250	0.0	0.0	0	Consumer credit	-194
119939	5714575	17	Closed	currency 1	-944	0	335.0	-548.0		0	1215000	0.0	0.0	0	Consumer credit	-513
119939	5714577	17	Active	currency 1	-1102	0	4.0			0	225000	210730.5	0.0	0	Credit card	-10
119939	5714578	17	Closed	currency 1	-1572	0	-1179.0	-987.0		0	225000			0	Consumer credit	-984
119939	5714579	17	Closed	currency 1	-1791	0	-1703.0	-987.0		0	22770			0	Consumer credit	-984
119939	5714580	17	Active	currency 1	-2401	0			0.0	0	99000	45036.0	53962.695	0	Credit card	-22
119939	5714581	17	Closed	currency 1	-1624	0	203.0	-1085.0	40.5	0	765000			0	Consumer credit	-1085
119939	5714582	17	Closed	currency 1	-1617	0	9341.0	-1083.0	6007.5	0	144000			0	Credit card	-1083
119939	5714583	17	Closed	currency 1	-937	0	889.0	-156.0	0.0	0	675000			0	Consumer credit	-156
119939	5714585	17	Active	currency 1	-314	0	1512.0		0.0	0	900000			0	Consumer credit	-40
136226	5714502	2	Active	currency 1	-521	0	551.0			0	112500	0.0	0.0	0	Credit card	-30
136226	5714503	2	Closed	currency 1	-559	0		-355.0	0.0	0	110250	0.0	0.0	0	Credit card	-351
162297	5714469	6	Closed	currency 1	-1896	0	-1684.0	-1710.0	14985.0	0	76878.45	0.0	0.0	0	Consumer credit	-1710
162297	5714470	6	Closed	currency 1	-1146	0	-811.0	-840.0	0.0	0	103007.7	0.0	0.0	0	Consumer credit	-840
162297	5714471	6	Active	currency 1	-1146	0	-484.0		0.0	0	4500	0.0	0.0	0	Credit card	-690
162297	5714472	6	Active	currency 1	-1146	0	-180.0		0.0	0	337500	0.0	0.0	0	Credit card	-690
162297	5714473	6	Closed	currency 1	-2456	0	-629.0	-825.0		0	675000	0.0	0.0	0	Consumer credit	-706
162297	5714474	6	Active	currency 1	-277	0	5261.0		0.0	0	7033500			0	Mortgage	-31
166034	5714697	8	Closed	currency 1	-1283	0	-1069.0	-1083.0	3727.89	0	19399.5	0.0	0.0	0	Consumer credit	-1068
166034	5714698	8	Closed	currency 1	-828	0	-613.0	-642.0	13590.0	0	70692.84	0.0	0.0	0	Consumer credit	-642
166034	5714699	8	Active	currency 1	-828	0	916.0		0.0	0	4500	0.0	4500.0	0	Credit card	-676
166034	5714700	8	Closed	currency 1	-1207	0	-1021.0	-1021.0		0	93240	0.0	0.0	0	Consumer credit	-981
166034	5714701	8	Active	currency 1	-706	0	369.0			0	459000	483534.0	0.0	0	Credit card	-4
166034	5714702	8	Active	currency 1	-262	0	103.0			0	450000	174519.0		0	Consumer credit	-7
166034	5714704	8	Active	currency 1	-718	0			2189.205	0	45000	43357.5	1638.765	0	Credit card	-22
166034	5714705	8	Closed	currency 1	-612	0	-245.0	-207.0	13225.725	0	178335	0.0	0.0	0	Consumer credit	-206
173404	5714710	4	Closed	currency 1	-1103	0	-304.0	-303.0		0	216000	0.0	0.0	0	Credit card	-303
173404	5714711	4	Closed	currency 1	-1166	0	-915.0	-915.0		0	107037	0.0	0.0	0	Consumer credit	-752
173404	5714712	4	Active	currency 1	-45	0	320.0			0	234000	234000.0	0.0	0	Consumer credit	-26
173404	5714713	4	Closed	currency 1	-1165	0	-860.0	-915.0	0.0	0	107037	0.0	0.0	0	Consumer credit	-825
215354	5714462	7	Closed	currency 1	-497	0	-153.0	-153.0		0	91323	0.0		0	Consumer credit	-131
215354	5714463	7	Active	currency 1	-208	0	1075.0			0	225000	171342.0		0	Credit card	-20
215354	5714464	7	Active	currency 1	-203	0	528.0			0	464323.5			0	Consumer credit	-16
215354	5714465	7	Active	currency 1	-203	0				0	90000			0	Credit card	-16
215354	5714466	7	Active	currency 1	-629	0	1197.0		77674.5	0	2700000			0	Consumer credit	-21
215354	5714467	7	Active	currency 1	-273	0	27460.0		0.0	0	180000	71017.38	108982.62	0	Credit card	-31
215354	5714468	7	Active	currency 1	-43	0	79.0		0.0	0	42103.8	42103.8	0.0	0	Consumer credit	-22
222183	5714491	6	Active	currency 1	-784	0	1008.0		0.0	0	0	-411.615	411.615	0	Credit card	-694
222183	5714492	6	Active	currency 1	-774	0	625.0			0	127840.5	0.0	0.0	0	Credit card	-210
222183	5714493	6	Active	currency 1	-395	0	1431.0			0	1350000	1185493.5	0.0	0	Consumer credit	-24
222183	5714495	6	Closed	currency 1	-2744	0	-2561.0	-2559.0	310.5	0	18157.5			0	Consumer credit	-2559
222183	5714496	6	Closed	currency 1	-1103	0	-7.0	-343.0	20493.27	0	675000	0.0	0.0	0	Consumer credit	-343
222183	5714497	6	Active	currency 1	-315	0	1512.0		88821.0	0	3709552.5			0	Car loan	-32
234931	5714557	6	Active	currency 1	-1272	0	-667.0			0	135000	17982.0	0.0	0	Consumer credit	-721
234931	5714558	6	Closed	currency 1	-1602	0	-1332.0	-987.0		0	42894			0	Consumer credit	-984
234931	5714559	6	Closed	currency 1	-1273	0	-667.0	-649.0		0	135000			0	Consumer credit	-643
234931	5714560	6	Closed	currency 1	-371	0	-130.0	-130.0		0	63522	0.0		0	Consumer credit	-110
234931	5714561	6	Closed	currency 1	-2638	0	-1208.0	-1518.0	18293.265	0	1143000	0.0	0.0	0	Car loan	-704
234931	5714562	6	Closed	currency 1	-1495	0	-635.0	-40.0	12618.0	0	46831.5			0	Consumer credit	-34
238881	5714482	7	Closed	currency 1	-318	0	-187.0	-187.0		0	0	0.0	0.0	0	Credit card	-185
238881	5714484	7	Closed	currency 1	-2911	0	-2607.0	-2604.0		0	48555			0	Consumer credit	-2601
238881	5714485	7	Closed	currency 1	-2148	0	-1595.0	-987.0		0	135000			0	Consumer credit	-984
238881	5714486	7	Active	currency 1	-381	0				0	450000	520920.0		0	Consumer credit	-4
238881	5714487	7	Active	currency 1	-95	0	1720.0			0	67500	8131.5		0	Credit card	-7
238881	5714488	7	Closed	currency 1	-444	0	-77.0	-77.0	0.0	0	107184.06	0.0	0.0	0	Consumer credit	-71
238881	5714489	7	Active	currency 1	-392	0			0.0	0	252000	23679.0	228320.1	0	Credit card	-22
241216	5714692	2	Closed	currency 1	-259	0	-139.0	-230.0	0.0	0	10464.435	0.0	0.0	0	Consumer credit	-227
241216	5714693	2	Active	currency 1	-199	0	-14.0		0.0	0	40810.5	8055.0	0.0	0	Consumer credit	-22
242993	5714537	13	Closed	currency 1	-2785	0	-958.0	-1769.0		0	225000	0.0	0.0	0	Consumer credit	-908
242993	5714538	13	Closed	currency 1	-683	0	-654.0	-654.0		0	40500	0.0	0.0	0	Consumer credit	-624
242993	5714539	13	Closed	currency 1	-744	0	-717.0	-717.0		0	45000	0.0	0.0	0	Consumer credit	-624
242993	5714541	13	Closed	currency 1	-801	0	-773.0	-773.0		0	45000	0.0	0.0	0	Consumer credit	-624
242993	5714542	13	Closed	currency 1	-1841	0	-1473.0	-1466.0		0	225000	0.0	0.0	0	Consumer credit	-1195
242993	5714543	13	Active	currency 1	-2237	0	-1868.0			0	135000			0	Consumer credit	-1874
242993	5714544	13	Closed	currency 1	-1201	0	-1081.0	-987.0		0	157500			0	Consumer credit	-984
242993	5714545	13	Closed	currency 1	-1844	0	-1473.0	-987.0		0	225000			0	Consumer credit	-984
242993	5714547	13	Closed	currency 1	-705	0	-614.0	-586.0		0	158566.5			0	Consumer credit	-580
242993	5714548	13	Closed	currency 1	-605	0	-577.0	-577.0		0	13500			0	Consumer credit	-572
242993	5714549	13	Closed	currency 1	-564	0	-535.0	-535.0		0	45000			0	Consumer credit	-531
242993	5714550	13	Active	currency 1	-382	0	1464.0			0	58500	59809.5		0	Credit card	-341
242993	5714551	13	Closed	currency 1	-865	0	-742.0	-833.0	0.0	0	29250	0.0	0.0	0	Consumer credit	-833
253882	5714648	4	Closed	currency 1	-1341	0	-241.0	-749.0		0	0	0.0		0	Credit card	-747
253882	5714649	4	Active	currency 1	-758	0	1095.0			0	315000	54895.5		0	Credit card	0
253882	5714650	4	Closed	currency 1	-1531	0	-800.0	-805.0	0.0	0	138987	0.0	0.0	0	Consumer credit	-805
253882	5714651	4	Closed	currency 1	-770	0	-467.0	-467.0	0.0	0	50301	0.0	0.0	0	Consumer credit	-463
280788	5714715	4	Active	currency 1	-221	0	875.0			0	220675.5			0	Consumer credit	-30
280788	5714716	4	Active	currency 1	-221	0				0	90000			0	Credit card	-9
280788	5714717	4	Active	currency 1	-728	0	2.0		3520.8	0	112500	5926.5	0.0	0	Consumer credit	-27
280788	5714718	4	Closed	currency 1	-637	0	-120.0	-120.0	1856.34	0	56532.645	0.0	0.0	0	Consumer credit	-120
286014	5714690	1	Active	currency 1	-137	0	27460.0		0.0	0	22500	18765.63	76.59	0	Credit card	-31
293201	5714620	5	Closed	currency 1	-2730	0	-2454.0	-2514.0	0.0	0	14058	0.0	0.0	0	Consumer credit	-2514
293201	5714621	5	Closed	currency 1	-2389	0	-1365.0	-1780.0	11250.0	0	225000	-701.28	225701.28	0	Credit card	-1780
293201	5714622	5	Closed	currency 1	-2255	0	-1982.0	-1987.0	6492.42	0	46033.92	0.0	0.0	0	Consumer credit	-1981
293201	5714624	5	Active	currency 1	-1425	0	-757.0		0.0	0	4500	0.0	4500.0	0	Credit card	-695
293201	5714625	5	Closed	currency 1	-2540	0	-713.0	-2209.0		0	360000	0.0	0.0	0	Consumer credit	-1261
303740	5714552	4	Closed	currency 1	-1423	0	-1119.0	-1118.0		0	79744.5	0.0	0.0	0	Consumer credit	-1118
303740	5714553	4	Closed	currency 1	-666	0	-574.0	-574.0	0.0	0	36916.56	0.0	0.0	0	Consumer credit	-568
303740	5714554	4	Active	currency 1	-581	0			0.0	0	384750	263056.5	121690.17	0	Credit card	-22
303740	5714555	4	Closed	currency 1	-433	0	-320.0	-320.0	0.0	0	67500	0.0	0.0	0	Consumer credit	-316
311918	5714563	2	Closed	currency 1	-2904	0	-2723.0	-2723.0		0	32899.5	0.0		0	Consumer credit	-2723
311918	5714564	2	Active	currency 1	-146	0	37.0		0.0	0	59085	20835.0	0.0	0	Consumer credit	-24
335122	5714653	5	Closed	currency 1	-1189	0	-109.0	-874.0		0	225000	0.0	0.0	0	Consumer credit	-860
335122	5714654	5	Closed	currency 1	-2426	0	-600.0	-556.0		0	540000	0.0	0.0	0	Consumer credit	-188
335122	5714655	5	Active	currency 1	-644	0	1182.0			0	900000			0	Consumer credit	-30
335122	5714656	5	Active	currency 1	-885	0	210.0			0	900000			0	Consumer credit	-30
335122	5714657	5	Closed	currency 1	-2740	0	-2434.0	-2496.0	0.0	0	54000	0.0	0.0	0	Consumer credit	-2494
338464	5714626	8	Closed	currency 1	-2655	0	-2319.0	-2348.0	0.0	0	20165.4	0.0	0.0	0	Consumer credit	-831
338464	5714627	8	Closed	currency 1	-2539	0	-1427.0	-651.0	0.0	0	45000	0.0	0.0	0	Credit card	-651
338464	5714628	8	Closed	currency 1	-2343	0	-2008.0	-2219.0	0.0	0	19192.5	0.0	0.0	0	Consumer credit	-2219
338464	5714629	8	Closed	currency 1	-857	0	-523.0	-582.0	3285.0	0	33853.5	0.0	0.0	0	Consumer credit	-582
338464	5714630	8	Active	currency 1	-857	0	765.0		1704.78	0	45000	38294.37	6705.63	0	Credit card	-675
338464	5714631	8	Active	currency 1	-1131	0	-27.0			0	270000	0.0	0.0	0	Credit card	-17
338464	5714633	8	Closed	currency 1	-1706	0	-976.0	-1260.0		0	247500	0.0	0.0	0	Consumer credit	-538
338464	5714634	8	Active	currency 1	-140	0			0.0	0	144000	143019.0	980.28	0	Credit card	-22
351919	5714658	1	Active	currency 1	-769	0	1057.0			0	409500	295542.0	0.0	0	Consumer credit	-14
373324	5714674	14	Active	currency 1	-837	0	-453.0		0.0	0	0	-45.36	45.36	0	Credit card	-685
373324	5714675	14	Active	currency 1	-341	0	-160.0		0.0	0	63496.17	63496.17	0.0	0	Consumer credit	-234
373324	5714676	14	Closed	currency 1	-586	0	-402.0	-402.0		0	90180	0.0	0.0	0	Consumer credit	-400
373324	5714677	14	Closed	currency 1	-1439	0	-1134.0	-1123.0		0	60399	0.0	0.0	0	Consumer credit	-775
373324	5714679	14	Active	currency 1	-577	0	521.0			0	225000	45324.0	0.0	0	Credit card	-25
373324	5714681	14	Closed	currency 1	-2819	0	-2516.0	-2516.0		0	24903	0.0		0	Consumer credit	-2516
373324	5714682	14	Closed	currency 1	-2673	0	-2307.0	-2307.0		0	31788	0.0		0	Consumer credit	-2307
373324	5714683	14	Closed	currency 1	-1438	0	-1134.0	-1153.0		0	60399	0.0		0	Consumer credit	-1128
373324	5714684	14	Closed	currency 1	-1913	0	-1609.0	-1609.0		0	53410.5	0.0		0	Consumer credit	-1128
373324	5714685	14	Closed	currency 1	-1593	0	-1109.0	-987.0		0	79456.5			0	Consumer credit	-984
373324	5714686	14	Closed	currency 1	-986	0	-805.0	-740.0		0	68850			0	Consumer credit	-738
373324	5714687	14	Closed	currency 1	-2455	0	-2273.0	-1925.0	0.0	0	31410	0.0	0.0	0	Consumer credit	-1924
373324	5714688	14	Closed	currency 1	-2216	0	-2121.0	-2095.0	0.0	0	20002.5	0.0	0.0	0	Consumer credit	-2095
373324	5714689	14	Closed	currency 1	-1805	0		-320.0	0.0	0	13500	0.0	0.0	0	Credit card	-229
387080	5714598	14	Closed	currency 1	-983	0	-623.0	-900.0		0	52987.5	0.0	0.0	0	Consumer credit	-802
387080	5714600	14	Closed	currency 1	-1104	0	-738.0	-731.0		0	194400	0.0	0.0	0	Consumer credit	-731
387080	5714601	14	Closed	currency 1	-1766	0	-1219.0	-1256.0		0	135000	0.0	0.0	0	Consumer credit	-1252
387080	5714602	14	Active	currency 1	-1082	0	745.0			0	197820	105840.0	0.0	0	Consumer credit	-10
387080	5714603	14	Active	currency 1	-1239	0	-149.0			0	225000	185953.5	0.0	0	Credit card	-10
387080	5714604	14	Active	currency 1	-681	0	1145.0			0	328500	244791.0	0.0	0	Consumer credit	-10
387080	5714606	14	Closed	currency 1	-2897	0	-2350.0	-2357.0		0	67500			0	Consumer credit	-2357
387080	5714607	14	Closed	currency 1	-1603	0	-1299.0	-1087.0		0	70335	0.0		0	Consumer credit	-1087
387080	5714608	14	Closed	currency 1	-2093	0	-1949.0	-987.0		0	44968.5			0	Consumer credit	-984
387080	5714609	14	Active	currency 1	-69	0	263.0			0	84361.5			0	Consumer credit	-6
387080	5714610	14	Closed	currency 1	-2299	0	-1932.0	-1932.0	0.0	0	72600.75	0.0	0.0	0	Consumer credit	-1603
387080	5714611	14	Closed	currency 1	-549	0	-364.0	-488.0	0.0	0	37935	0.0	0.0	0	Consumer credit	-486
387080	5714612	14	Closed	currency 1	-388	0	-21.0	-84.0	0.0	0	98446.5	0.0	0.0	0	Consumer credit	-84
387080	5714614	14	Active	currency 1	-18	0	378.0		0.0	0	76500	76500.0	0.0	0	Consumer credit	-14
388421	5714587	4	Active	currency 1	-685	0	410.0		0.0	0	135000	0.0	135000.0	0	Credit card	-236
388421	5714590	4	Closed	currency 1	-325	0	223.0	-112.0		0	87286.5	0.0	0.0	0	Consumer credit	-106
388421	5714591	4	Active	currency 1	-674	0	1152.0			0	868500	662139.0	0.0	0	Consumer credit	-25
388421	5714593	4	Active	currency 1	-378	0	1449.0		0.0	0	991800			0	Consumer credit	-31
389074	5714667	3	Closed	currency 1	-957	0	-342.0	-341.0		0	13500	0.0	0.0	0	Credit card	-334
389074	5714668	3	Closed	currency 1	-705	0	-433.0	-404.0		0	135729			0	Consumer credit	-398
389074	5714669	3	Closed	currency 1	-1049	0	-378.0	-378.0	0.0	0	113496.885	0.0	0.0	0	Consumer credit	-372
389599	5714529	7	Closed	currency 1	-672	0	10285.0	-531.0		0	135000	0.0	0.0	0	Credit card	-429
389599	5714530	7	Closed	currency 1	-1304	0	1253.0	-1287.0		0	225000	0.0	0.0	0	Consumer credit	-429
389599	5714531	7	Closed	currency 1	-1253	0	-887.0	-887.0		0	43105.5	0.0	0.0	0	Consumer credit	-687
389599	5714532	7	Closed	currency 1	-1130	0	331.0	-858.0		0	450000	0.0	0.0	0	Consumer credit	-847
389599	5714533	7	Active	currency 1	-831	0	277.0			0	270000	274225.5	0.0	0	Credit card	-10
389599	5714534	7	Active	currency 1	-329	0	1497.0			0	589500	521478.0	0.0	0	Consumer credit	-8
389599	5714536	7	Closed	currency 1	-700	0	-600.0	-600.0	0.0	0	68715	0.0	0.0	0	Consumer credit	-596
399459	5714708	2	Closed	currency 1	-1141	0	-837.0	-784.0		0	113359.5			0	Consumer credit	-781
399459	5714709	2	Active	currency 1	-49	0	316.0		0.0	0	24763.5	22968.0	0.0	0	Consumer credit	-19
400486	5714504	5	Closed	currency 1	-2413	0	-1864.0	-2128.0		0	180000	0.0	0.0	0	Consumer credit	-708
400486	5714506	5	Active	currency 1	-941	0	-17.0			0	40500	0.0	0.0	0	Credit card	-15
400486	5714507	5	Closed	currency 1	-1110	0	-745.0	-727.0		0	114727.5	0.0	0.0	0	Consumer credit	-658
400486	5714508	5	Closed	currency 1	-2133	0	-1038.0	-1127.0		0	225000	0.0	0.0	0	Consumer credit	-708
400486	5714509	5	Active	currency 1	-391	0	705.0			0	142290	108315.0	0.0	0	Consumer credit	-30
402440	5714475	1	Active	currency 1	-96	0	269.0		0.0	0	89910	76905.0	0.0	0	Consumer credit	-22
406724	5714661	4	Closed	currency 1	-1293	0	-1155.0	-1155.0		0	13500	0.0	0.0	0	Credit card	-775
406724	5714662	4	Closed	currency 1	-1433	0	-1251.0	-1245.0		0	23067	0.0	0.0	0	Consumer credit	-783
406724	5714663	4	Closed	currency 1	-1432	0	-1251.0	-1251.0		0	23067	0.0		0	Consumer credit	-1142
406724	5714665	4	Active	currency 1	-167	0	1298.0		0.0	0	606496.995	574827.21	0.0	0	Consumer credit	-5
419892	5714594	4	Closed	currency 1	-1697	0	-1148.0	-1148.0		0	70695	0.0	0.0	0	Consumer credit	-696
419892	5714595	4	Closed	currency 1	-1238	0	-878.0	-1120.0		0	22320	0.0	0.0	0	Consumer credit	-1119
419892	5714596	4	Active	currency 1	-381	0				0	2767500	2739622.5		0	Mortgage	-27
419892	5714597	4	Closed	currency 1	-584	0	511.0	-405.0	0.0	0	238603.5	0.0	0.0	0	Consumer credit	-405
426155	5714498	4	Closed	currency 1	-1331	0	-994.0	-1023.0	1350.0	0	39433.5	0.0	0.0	0	Consumer credit	-1023
426155	5714499	4	Closed	currency 1	-2534	0	-2352.0	-2347.0		0	38830.5	0.0	0.0	0	Consumer credit	-2345
426155	5714500	4	Closed	currency 1	-845	0	-480.0	-480.0	0.0	0	67500	0.0	0.0	0	Consumer credit	-480
426155	5714501	4	Closed	currency 1	-529	0	-343.0	-343.0	0.0	0	182791.44	0.0	0.0	0	Consumer credit	-337
435112	5714512	11	Closed	currency 1	-1412	0	-861.0	-849.0		0	85288.5	0.0	0.0	0	Consumer credit	-753
435112	5714513	11	Closed	currency 1	-1590	0	-1344.0	-1276.0		0	100129.5	0.0	0.0	0	Consumer credit	-783
435112	5714514	11	Closed	currency 1	-1181	0	-875.0	-872.0		0	44419.5	0.0	0.0	0	Consumer credit	-872
435112	5714516	11	Closed	currency 1	-1475	0	-1293.0	-1322.0		0	21690	0.0		0	Consumer credit	-1322
435112	5714517	11	Closed	currency 1	-1411	0	-861.0	-861.0		0	85293	0.0		0	Consumer credit	-855
435112	5714518	11	Active	currency 1	-1483	0				0	200250	0.0		0	Credit card	-848
435112	5714519	11	Closed	currency 1	-1589	0	-1344.0	-1292.0	3980.52	0	100129.5	0.0	0.0	0	Consumer credit	-736
435112	5714520	11	Closed	currency 1	-829	0	-508.0	-508.0	0.0	0	159386.085	0.0	0.0	0	Consumer credit	-508
435112	5714521	11	Closed	currency 1	-739	0	-525.0	-525.0	0.0	0	48645	0.0	0.0	0	Consumer credit	-519
435112	5714522	11	Active	currency 1	-508	0	1318.0		0.0	0	1058823.54	858768.57	0.0	0	Consumer credit	-7
435112	5714523	11	Active	currency 1	-416	0	680.0		0.0	0	256500	183528.0	0.0	0	Consumer credit	-43
444864	5714635	12	Closed	currency 1	-2209	0	-2086.0	-2115.0	0.0	0	16645.5	0.0	0.0	0	Consumer credit	-2115
444864	5714636	12	Closed	currency 1	-2130	0	-1886.0	-1883.0		0	66600	0.0	0.0	0	Consumer credit	-791
444864	5714637	12	Closed	currency 1	-1125	0	-881.0	-881.0		0	82795.5	0.0	0.0	0	Consumer credit	-752
444864	5714638	12	Closed	currency 1	-1872	0	-1568.0	-1549.0		0	49936.5	0.0	0.0	0	Consumer credit	-801
444864	5714639	12	Closed	currency 1	-2030	0	31111.0	-1750.0		0	85050	0.0	0.0	0	Credit card	-555
444864	5714640	12	Closed	currency 1	-1776	0	-680.0	-712.0		0	157500	0.0	0.0	0	Consumer credit	-188
444864	5714642	12	Closed	currency 1	-1124	0	-881.0	-881.0		0	82795.5	0.0		0	Consumer credit	-876
444864	5714643	12	Closed	currency 1	-1871	0	-1568.0	-1568.0		0	49936.5	0.0		0	Consumer credit	-820
444864	5714644	12	Closed	currency 1	-2129	0	-1886.0	-1886.0		0	66600	0.0		0	Consumer credit	-820
444864	5714645	12	Closed	currency 1	-1416	0	-685.0	-685.0	0.0	0	182119.5	0.0	0.0	0	Consumer credit	-680
444864	5714646	12	Closed	currency 1	-312	0	-130.0	-130.0	0.0	0	52488	0.0	0.0	0	Consumer credit	-127
444864	5714647	12	Active	currency 1	-286	0			0.0	0	364500	0.0	364500.0	0	Credit card	-29
452585	5714524	4	Closed	currency 1	-2642	0	-2307.0	-2332.0	1800.0	0	15921	0.0	0.0	0	Consumer credit	-2306
452585	5714525	4	Active	currency 1	-2538	0	-1427.0		0.0	0	45000	0.0	0.0	0	Credit card	-682
452585	5714527	4	Active	currency 1	-42	0	-26.0			0	45000	54000.0	0.0	0	Consumer credit	-31
452585	5714528	4	Closed	currency 1	-2898	0	-2722.0	-2344.0		0	11340			0	Consumer credit	-2344
select count(*) from t1;
count(*)
201
select count(*) from t2;
count(*)
201
select count(*) from t3;
count(*)
201
checksum table t1, t2, t3;
Table	Checksum
test.t1	1688521217
test.t2	1688521217
test.t3	1688521217
drop table bureau;
drop table t1, t2, t3;