number of errors=34
number of warnings=0
Group=chkGrpShp
select a.countrycode,a.avg,a.level,t2.avg,t2.level, to_char(a.avg/t2.avg,'999990.99') as mul from tmp_shape_qa a,tmp_shape_qa t2 where t2.countrycode=a.countrycode and 9*t2.avg
[{key=LK,number=4}, {key=PL,number=4}, {key=CO,number=3}, {key=LT,number=3}, {key=BR,number=2}, {key=IE,number=2}, {key=PF,number=2}, {key=PT,number=2}, {key=TH,number=2}, {key=WF,number=2}, {key=AR,number=1}, {key=DK,number=1}, {key=ID,number=1}, {key=MZ,number=1}, {key=OM,number=1}, {key=RU,number=1}, {key=TF,number=1}, {key=UA,number=1}]
countrycode avg level avg level mul AR 0.02153441719260129 3 0.00048475718362914807 4 44.42 BR 0.0170317667160983 2 0.00021154876487191102 4 80.51 BR 0.0022441441799237773 3 0.00021154876487191102 4 10.61 CO 0.0055218733084689605 1 0.00047363719310013176 3 11.66 CO 0.0055218733084689605 1 0.00042735883452488406 4 12.92 CO 0.0055218733084689605 1 0.0002293132210052578 5 24.08 DK 0.0011892113908497774 1 0.00010136009250427145 2 11.73 ID 0.0031900009257876836 2 0.0002418468928355384 4 13.19 IE 0.0021720063885412337 1 0.0001688282011749409 2 12.87 IE 0.0021720063885412337 1 0.0001524447367151622 3 14.25 LK 0.0038961392421342665 1 0.00020350145070643935 2 19.15 LK 0.0038961392421342665 1 0.00021445377292846082 3 18.17 LK 0.0038961392421342665 1 0.0002277023431978165 4 17.11 LK 0.0038961392421342665 1 0.0002433237945488165 5 16.01 LT 0.007417272813114837 1 0.0003194370804023692 2 23.22 LT 0.007417272813114837 1 0.00043946313447571427 3 16.88 LT 0.007417272813114837 1 0.0005731296209576991 4 12.94 MZ 0.03892318185495974 2 0.001188898338215546 3 32.74 OM 0.09856473100272116 2 0.0031494059449523404 3 31.30 PF 0.000704127291220477 1 5.91178733720957e-05 2 11.91 PF 0.000704127291220477 1 7.7054262725687e-05 3 9.14 PL 0.007476835485212899 1 0.00045938455166337483 3 16.28 PL 0.007476835485212899 1 0.00027124081885753875 5 27.57 PL 0.007759746668523544 2 0.00045938455166337483 3 16.89 PL 0.007759746668523544 2 0.00027124081885753875 5 28.61 PT 0.003226488094045864 1 0.0003026675813516281 3 10.66 PT 0.0029660935102286115 2 0.0003026675813516281 3 9.80 RU 0.037009308694188024 2 0.0027165882491053815 3 13.62 TF 0.02224714622794798 2 0.0004308100333007135 3 51.64 TH 0.012758261645967574 2 0.0006513339320734778 3 19.59 TH 0.012758261645967574 2 0.0007256907448326458 4 17.58 UA 0.012348539068921114 1 0.0010040899667107914 2 12.30 WF 0.0010192573090565668 1 4.6509958153299775e-05 2 21.91 WF 0.0010192573090565668 1 5.768398995108164e-05 3 17.67