-- Database schema
| runs : run_at [ TEXT ] , max_rowid [ INTEGER ] , reviews_added [ INTEGER ] | podcasts : podcast_id [ TEXT ] primary_key , itunes_id [ INTEGER ] , slug [ TEXT ] , itunes_url [ TEXT ] , title [ TEXT ] | reviews : podcast_id [ TEXT ] , title [ TEXT ] , content [ TEXT ] , rating [ INTEGER ] , author_id [ TEXT ] , created_at [ TEXT ] | categories : podcast_id [ TEXT ] , category [ TEXT ] |
-- -- What is the average rating of all the podcasts with reviews created in 2019?

SELECT AVG(rating) FROM reviews WHERE created_at BETWEEN '2019-01-01T00:00:00-07:00' AND '2019-12-31T23:59:59-07:00';