SELECT * FROM (
   SELECT
   (SELECT count(*)
      FROM (
           SELECT DISTINCT v."VAERS_ID"
           FROM vax_data AS vd
           LEFT JOIN vax AS v ON (v."VAERS_ID"=vd."VAERS_ID")
           WHERE v."VAX_TYPE" = 'COVID19' AND vd."DIED" IS NOT NULL
      ) as sub
   ) as covid,

   (SELECT count(*)
      FROM (
           SELECT DISTINCT v."VAERS_ID"
           FROM vax_data AS vd
           LEFT JOIN vax AS v ON (v."VAERS_ID"=vd."VAERS_ID")
           WHERE v."VAX_TYPE" != 'COVID19' AND vd."DIED" IS NOT NULL
      ) as sub
   ) as non_covid
) AS deaths