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.021534417192601293 3 0.00048475718362914807 4 44.42 BR 0.0170317667160983 2 0.00021154876487191102 4 80.51 BR 0.002244144179923778 3 0.00021154876487191102 4 10.61 CO 0.005521873308468961 1 0.00047363719310013186 3 11.66 CO 0.005521873308468961 1 0.0004273588345248841 4 12.92 CO 0.005521873308468961 1 0.0002293132210052578 5 24.08 DK 0.0011892113908497772 1 0.00010136009250427145 2 11.73 ID 0.003190000925787684 2 0.0002418468928355384 4 13.19 IE 0.0021720063885412337 1 0.0001688282011749409 2 12.87 IE 0.0021720063885412337 1 0.00015244473671516222 3 14.25 LK 0.003896139242134266 1 0.00020350145070643935 2 19.15 LK 0.003896139242134266 1 0.0002144537729284608 3 18.17 LK 0.003896139242134266 1 0.00022770234319781642 4 17.11 LK 0.003896139242134266 1 0.0002433237945488167 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.0005731296209576989 4 12.94 MZ 0.03892318185495974 2 0.001188898338215546 3 32.74 OM 0.09856473100272113 2 0.0031494059449523404 3 31.30 PF 0.0007041272912204772 1 5.91178733720957e-05 2 11.91 PF 0.0007041272912204772 1 7.705426272568697e-05 3 9.14 PL 0.007476835485212899 1 0.00045938455166337483 3 16.28 PL 0.007476835485212899 1 0.0002712408188575388 5 27.57 PL 0.007759746668523544 2 0.00045938455166337483 3 16.89 PL 0.007759746668523544 2 0.0002712408188575388 5 28.61 PT 0.003226488094045864 1 0.0003026675813516281 3 10.66 PT 0.0029660935102286115 2 0.0003026675813516281 3 9.80 RU 0.03700930869418804 2 0.0027165882491053815 3 13.62 TF 0.02224714622794798 2 0.0004308100333007135 3 51.64 TH 0.012758261645967576 2 0.0006513339320734779 3 19.59 TH 0.012758261645967576 2 0.0007256907448326456 4 17.58 UA 0.012348539068921112 1 0.0010040899667107912 2 12.30 WF 0.0010192573090565668 1 4.650995815329978e-05 2 21.91 WF 0.0010192573090565668 1 5.768398995108164e-05 3 17.67