Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # select extract(year from last_modified) as year, count(*) from package group by year order by year;
- year | count
- ------+-------
- 2002 | 4
- 2003 | 75
- 2004 | 115
- 2005 | 167
- 2006 | 168
- 2007 | 201
- 2008 | 247
- 2009 | 410
- 2010 | 447
- 2011 | 638
- 2012 | 804
- 2013 | 23311
- 2014 | 16979
- 2015 | 15522
- (14 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement