Guest User

Untitled

a guest
Jun 22nd, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. SELECT doc_type, AVG(data) as average FROM
  2. (
  3. SELECT date_filed, doc_type, count(*)
  4. AS data
  5. FROM record
  6. WHERE date_filed > '2009-01-01'
  7. GROUP BY date_filed, doc_type
  8. ) AS stats
  9. GROUP BY doc_type with rollup;
Add Comment
Please, Sign In to add comment