Advertisement
Guest User

Untitled

a guest
May 16th, 2015
28
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. # select extract(year from last_modified) as year, count(*) from package group by year order by year;
  2. year | count
  3. ------+-------
  4. 2002 | 4
  5. 2003 | 75
  6. 2004 | 115
  7. 2005 | 167
  8. 2006 | 168
  9. 2007 | 201
  10. 2008 | 247
  11. 2009 | 410
  12. 2010 | 447
  13. 2011 | 638
  14. 2012 | 804
  15. 2013 | 23311
  16. 2014 | 16979
  17. 2015 | 15522
  18. (14 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement