Pages per year

How many pages did I read in which year?

Custom SQL query returning 23 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 5474
2002 3731
2003 10032
2004 7130
2005 8740
2006 9491
2007 9802
2008 10353
2009 13224
2010 7178
2011 4207
2012 6110
2013 4553
2014 17330
2015 6274
2016 20807
2017 30021
2018 67937
2019 42515
2020 24567
Powered by Datasette · Query took 52.632ms