{
  "fields": [{"type":"int","id":"_id"},{"type":"text","id":"SQL Statement"}],
  "records": [
    [1,"select *\nfrom ( ---zzz\nSELECT X.BEROEP_CD\n     , b.omschrijving_l beroepnaam\n     , ROUND(SUM(AANT_COMP_RECIPROOK) * AVG(X.AANT_COMP), 3) GEWICHT\n     , X.COMPETENTIE_CD\n     , comp.omschrijving competentie\n     , decode(regcomp.beroep_cd, NULL, NULL, '*') reg\n     , COUNT(DISTINCT X.PERS_ID) AANT_PERS\n     , ROUND(AVG(X.JR_ERV),1) JR_ERV_GEM\n     , ROUND(AVG(X.AANT_COMP),1) AANT_COMP_GEM\nFROM \n( -- X\nselect peb.pers_id\n     , peb.beroep_cd\n     , round(peb.jr_erv, 1) jr_erv \n     , compcnt.aant_comp\n     , 1 / compcnt.aant_comp aant_comp_reciprook \n     , compcv.competentie_cd\nfrom (select pers_id\n           , beroep_cd_reg beroep_cd\n           , sum(datum_tot - datum_vanaf) / 365.24 jr_erv\n      from wnx_cv.wnx_werkervaring\n      where 1=1 -- beroep_cd_reg in (4949,1000406546,1000000519,14169,1000401907,1000401909,1000406327,15133,14304,14979,1000406384)\n      group by pers_id, beroep_cd_reg      \n      having sum(datum_tot - datum_vanaf) / 365.24 >= 3      \n     ) peb\n   , (select pers_id\n           , count(distinct competentie_referentie_id) aant_comp\n      from wnx_cv.wnx_competentie\n      group by pers_id\n     ) compcnt\n   , (select pers_id\n           , competentie_referentie_id competentie_cd\n      from wnx_cv.wnx_competentie\n      where competentie_referentie_id is not null\n      group by pers_id, competentie_referentie_id\n     ) compcv\nwhere peb.pers_id = compcnt.pers_id\n  and peb.pers_id = compcv.pers_id     \norder by peb.pers_id, peb.beroep_cd, compcv.competentie_cd\n) X\n, reg_owner9.beroep b\n, reg_owner9.competentie comp \n, (select bi.beroep_cd\n        , bi.bcle_cd competentie_cd\n   from reg_owner9.beroepindeling bi\n   where bi.bclass_cd in (82, 89, 90, 93, 96, 102)\n     and bi.status_cd = 'A'\n   order by 1,2\n  ) regcomp\nwhere X.beroep_cd = b.beroep_cd\n  and X.competentie_cd = comp.competentie_cd\n  and X.beroep_cd      = regcomp.beroep_cd(+)\n  and X.competentie_cd = regcomp.competentie_cd(+)\nGROUP BY X.BEROEP_CD, X.COMPETENTIE_CD, b.omschrijving_l, comp.omschrijving, regcomp.beroep_cd\nORDER BY b.omschrijving_l, GEWICHT DESC, comp.omschrijving\n) zzz\nwhere zzz.aant_pers >= 50"],
    [2,""],
    [3,"Drempel = 50 personen"],
    [4,"Gewicht = 1 per persoon"]
]}