Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT doc_type, AVG(data) as average FROM
- (
- SELECT date_filed, doc_type, count(*)
- AS data
- FROM record
- WHERE date_filed > '2009-01-01'
- GROUP BY date_filed, doc_type
- ) AS stats
- GROUP BY doc_type with rollup;
Add Comment
Please, Sign In to add comment