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.02153441719260131 3 0.00048475718362914807 4 44.42 BR 0.017031766716098302 2 0.000211548764871911 4 80.51 BR 0.0022441441799237807 3 0.000211548764871911 4 10.61 CO 0.005521873308468963 1 0.00047363719310013116 3 11.66 CO 0.005521873308468963 1 0.00042735883452488417 4 12.92 CO 0.005521873308468963 1 0.00022931322100525772 5 24.08 DK 0.0011892113908497774 1 0.00010136009250427145 2 11.73 ID 0.0031900009257876836 2 0.00024184689283553832 4 13.19 IE 0.0021720063885412332 1 0.0001688282011749409 2 12.87 IE 0.0021720063885412332 1 0.00015244473671516222 3 14.25 LK 0.0038961392421342665 1 0.00020350145070643935 2 19.15 LK 0.0038961392421342665 1 0.0002144537729284607 3 18.17 LK 0.0038961392421342665 1 0.0002277023431978164 4 17.11 LK 0.0038961392421342665 1 0.00024332379454881678 5 16.01 LT 0.007417272813114837 1 0.0003194370804023692 2 23.22 LT 0.007417272813114837 1 0.00043946313447571444 3 16.88 LT 0.007417272813114837 1 0.000573129620957699 4 12.94 MZ 0.03892318185495975 2 0.0011888983382155466 3 32.74 OM 0.09856473100272113 2 0.0031494059449523404 3 31.30 PF 0.0007041272912204775 1 5.911787337209571e-05 2 11.91 PF 0.0007041272912204775 1 7.705426272568702e-05 3 9.14 PL 0.007476835485212899 1 0.00045938455166337467 3 16.28 PL 0.007476835485212899 1 0.00027124081885753886 5 27.57 PL 0.007759746668523544 2 0.00045938455166337467 3 16.89 PL 0.007759746668523544 2 0.00027124081885753886 5 28.61 PT 0.003226488094045864 1 0.00030266758135162836 3 10.66 PT 0.00296609351022861 2 0.00030266758135162836 3 9.80 RU 0.037009308694188024 2 0.002716588249105382 3 13.62 TF 0.022247146227947975 2 0.0004308100333007135 3 51.64 TH 0.012758261645967576 2 0.0006513339320734777 3 19.59 TH 0.012758261645967576 2 0.000725690744832644 4 17.58 UA 0.012348539068921114 1 0.0010040899667107912 2 12.30 WF 0.0010192573090565668 1 4.650995815329978e-05 2 21.91 WF 0.0010192573090565668 1 5.768398995108165e-05 3 17.67