Pages per year

How many pages did I read in which year?

Custom SQL query returning 22 rows (hide)

select substr(reviews.read_at, 0, 5) as year, sum(books.pages) as n from reviews join reviews_shelves on reviews.id = reviews_shelves.reviews_id join shelves on reviews_shelves.shelves_id = shelves.id join books on reviews.book_id = books.id where shelves.name="read" and reviews.read_at group by year;

yearn
1998 284
1999 1128
2000 1200
2001 5573
2002 3731
2003 10032
2004 7130
2005 8760
2006 9153
2007 9802
2008 10360
2009 13224
2010 7178
2011 4207
2012 5925
2013 4553
2014 16815
2015 6274
2016 20787
2017 30047
2018 66666
2019 36034
Powered by Datasette · Query took 10.197ms