Revision released per month
The statistics show the number of revisions commited every month
SELECT YEAR(tstart), MONTH(tstart), COUNT(*) FROM PRISM_VERSIONS WHERE schema_name LIKE ? GROUP BY YEAR(tstart), MONTH(tstart)
Revision Lifetime
The statistics show the lifetime, in days, of each revision
SELECT schema_unique_name, DATEDIFF(tend,tstart) FROM PRISM_VERSIONS WHERE schema_unique_name like ? AND tend < (SELECT MAX(tend) FROM PRISM_VERSIONS WHERE schema_unique_name like ?) ORDER BY tstart