Guest User

Untitled

a guest
Jun 22nd, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. select
  2. doc_type,
  3. avg(data) as Average
  4. from (
  5. select doc_type, count(*) as data from docs group by docs.id, date_filled
  6. ) as stats
  7. group by doc_type with rollup;
Add Comment
Please, Sign In to add comment