Which gives me the total number of reports by status, which is either 'published' or 'finalized'.
What I don't get is an 'all' rollup. Which I could do with another flat table and a cross join on a table of report statuses, but I'd love to keep this is as a view if possible.
Using 9.3, so I have the "latest and greatest". What are my options here?