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 8740
2006 9477
2007 9802
2008 10360
2009 13224
2010 7178
2011 4207
2012 6110
2013 4553
2014 17614
2015 6274
2016 20787
2017 30017
2018 67942
2019 42118
Powered by Datasette · Query took 7.146ms