Database schema:

CREATE TABLE categories (
	podcast_id TEXT NOT NULL -- example: ['a00043d34e734b09246d17dc5d56f63c', 'a00018b54eb342567c94dacfb2a3e504'],
	category TEXT NOT NULL -- example: ['arts-performing-arts', 'arts'],
	PRIMARY KEY (podcast_id, category), 
	CONSTRAINT fk_categories_podcasts FOREIGN KEY(podcast_id) REFERENCES podcasts (podcast_id)
)


CREATE TABLE podcasts (
	podcast_id TEXT -- example: ['a00043d34e734b09246d17dc5d56f63c', 'a00018b54eb342567c94dacfb2a3e504'],
	itunes_id INTEGER NOT NULL -- example: ['158973461', '1313466221'],
	slug TEXT NOT NULL -- example: ['cornerstone-baptist-church-of-orlando', 'scaling-global'],
	itunes_url TEXT NOT NULL -- example: ['https://podcasts.apple.com/us/podcast/scaling-glob', 'https://podcasts.apple.com/us/podcast/cornerstone-'],
	title TEXT NOT NULL -- example: ['Cornerstone Baptist Church of Orlando', 'Scaling Global'],
	PRIMARY KEY (podcast_id)
)


CREATE TABLE reviews (
	podcast_id TEXT NOT NULL -- example: ['ad4f2bf69c72b8db75978423c25f379e', 'c61aa81c9b929a66f0c1db6cbe5d8548'],
	title TEXT NOT NULL -- example: ['Must listen for anyone interested in the arts!!!', 'really interesting!'],
	content TEXT NOT NULL -- example: ['Super excited to see this podcast grow. So many fu', 'Thanks for providing these insights.  Really enjoy'],
	rating INTEGER NOT NULL -- example: ['5', '1'],
	author_id TEXT NOT NULL -- example: ['F6BF5472689BD12', 'F7E5A318989779D'],
	created_at TEXT NOT NULL, 
	CONSTRAINT fk_reviews_podcasts FOREIGN KEY(podcast_id) REFERENCES podcasts (podcast_id)
)


CREATE TABLE runs (
	run_at TEXT NOT NULL -- example: ['2021-05-10 02:53:00', '2021-06-06 21:34:36'],
	max_rowid INTEGER NOT NULL -- example: ['3300773', '3266481'],
	reviews_added INTEGER NOT NULL -- example: ['1215223', '13139']
)

Question: What is the percentage of reviews added each year of the total reviews added?
Evidence: review added each year refers to runs_at like '2021%' and runs_at like '2022%'; percentage for 2021 = Divide (Sum(reviews_added(runs_at like '2021%)), Sum(reviews_added)) * 100; percentage of 2022 = Divide (Sum(reviews_added(runs_at like '2022%')), Sum(reviews_added)) * 100

SQL:
SELECT CAST((SUM(CASE WHEN run_at LIKE '2022-%' THEN reviews_added ELSE 0 END) - SUM(CASE WHEN run_at LIKE '2021-%' THEN reviews_added ELSE 0 END)) AS REAL) * 100 / SUM(reviews_added) OR '%' "percentage" FROM runs