gistfile1.sql

with exploitability_count AS (
    select count(*) from exploitability_reports
      WHERE
     report_date BETWEEN %(start_date)s AND %(end_date)s

)

SELECT
exploitability_count.count
signature,
report_date,
null_count,
none_count,
low_count,
medium_count,
high_count
FROM exploitability_reports
WHERE
report_date BETWEEN %(start_date)s AND %(end_date)s
ORDER BY
report_date DESC;