SELECT   row_number() over() AS "#", *
FROM
(SELECT
  vt as vax_code,
  totals AS total_reports,
  death AS deaths,
  life_threat,
  er_visit,
  other_effects,
  round((death / totals)*100, 2) AS death_percent,
  round((life_threat / totals)*100, 2) AS life_threat_percent,
  round((er_visit / totals)*100, 2) AS er_percent,
  vax_desc
FROM (
  SELECT
    vg.vt,
    (SELECT count(*)::decimal FROM vax WHERE "VAX_TYPE"=vg.vt) AS totals,
    (
      SELECT count(*)::decimal
      FROM vax LEFT JOIN vax_data AS vd ON (vd."VAERS_ID"=vax."VAERS_ID")
      WHERE "VAX_TYPE"=vg.vt AND vd."DIED" IS NOT NULL
    ) AS death,
    (
        SELECT count(*)::decimal
        FROM vax LEFT JOIN vax_data AS vd ON (vd."VAERS_ID"=vax."VAERS_ID")
        WHERE "VAX_TYPE"=vg.vt AND vd."L_THREAT" IS NOT NULL AND vd."DIED" IS NULL
    ) AS life_threat,
    (
        SELECT count(*)::decimal
        FROM vax LEFT JOIN vax_data AS vd ON (vd."VAERS_ID"=vax."VAERS_ID")
        WHERE "VAX_TYPE"=vg.vt AND vd."L_THREAT" IS NULL AND vd."DIED" IS NULL AND vd."ER_VISIT" IS NOT NULL
    ) AS er_visit,
    (
        SELECT count(*)::decimal
        FROM vax LEFT JOIN vax_data AS vd ON (vd."VAERS_ID"=vax."VAERS_ID")
        WHERE "VAX_TYPE"=vg.vt AND vd."L_THREAT" IS NULL AND vd."DIED" IS NULL
    ) AS other_effects,
    (SELECT description FROM vax_description AS vdesc WHERE vdesc.code=vg.vt LIMIT 1) AS vax_desc
  FROM (
      SELECT "VAX_TYPE" AS vt FROM vax
      GROUP BY vt
  ) as vg
) as data
WHERE death > 0 AND life_threat > 0 AND totals > 1000
ORDER BY death_percent DESC, life_threat_percent DESC
LIMIT 20) as dataset