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.0215344171926013 3 0.00048475718362914807 4 44.42 BR 0.0170317667160983 2 0.00021154876487191102 4 80.51 BR 0.0022441441799237777 3 0.00021154876487191102 4 10.61 CO 0.005521873308468961 1 0.00047363719310013186 3 11.66 CO 0.005521873308468961 1 0.00042735883452488406 4 12.92 CO 0.005521873308468961 1 0.0002293132210052578 5 24.08 DK 0.0011892113908497776 1 0.00010136009250427145 2 11.73 ID 0.0031900009257876836 2 0.00024184689283553843 4 13.19 IE 0.0021720063885412337 1 0.0001688282011749409 2 12.87 IE 0.0021720063885412337 1 0.00015244473671516222 3 14.25 LK 0.0038961392421342665 1 0.00020350145070643935 2 19.15 LK 0.0038961392421342665 1 0.0002144537729284608 3 18.17 LK 0.0038961392421342665 1 0.00022770234319781648 4 17.11 LK 0.0038961392421342665 1 0.00024332379454881673 5 16.01 LT 0.007417272813114837 1 0.0003194370804023692 2 23.22 LT 0.007417272813114837 1 0.0004394631344757144 3 16.88 LT 0.007417272813114837 1 0.0005731296209576991 4 12.94 MZ 0.03892318185495975 2 0.001188898338215546 3 32.74 OM 0.09856473100272116 2 0.0031494059449523404 3 31.30 PF 0.0007041272912204772 1 5.91178733720957e-05 2 11.91 PF 0.0007041272912204772 1 7.705426272568702e-05 3 9.14 PL 0.007476835485212899 1 0.0004593845516633746 3 16.28 PL 0.007476835485212899 1 0.0002712408188575388 5 27.57 PL 0.0077597466685235435 2 0.0004593845516633746 3 16.89 PL 0.0077597466685235435 2 0.0002712408188575388 5 28.61 PT 0.003226488094045864 1 0.00030266758135162814 3 10.66 PT 0.0029660935102286115 2 0.00030266758135162814 3 9.80 RU 0.03700930869418804 2 0.0027165882491053815 3 13.62 TF 0.022247146227947975 2 0.0004308100333007135 3 51.64 TH 0.012758261645967574 2 0.0006513339320734779 3 19.59 TH 0.012758261645967574 2 0.0007256907448326464 4 17.58 UA 0.012348539068921112 1 0.0010040899667107914 2 12.30 WF 0.0010192573090565668 1 4.650995815329978e-05 2 21.91 WF 0.0010192573090565668 1 5.768398995108164e-05 3 17.67