Database schema:

CREATE TABLE cites (
	cited_paper_id TEXT NOT NULL -- example: ['100157', '100598'],
	citing_paper_id TEXT NOT NULL -- example: ['364207', '100157'],
	PRIMARY KEY (cited_paper_id, citing_paper_id)
)


CREATE TABLE content (
	paper_id TEXT NOT NULL -- example: ['100157', '100598'],
	word_cited_id TEXT NOT NULL -- example: ['word1163', 'word1509'],
	PRIMARY KEY (paper_id, word_cited_id), 
	CONSTRAINT fk_content_paper FOREIGN KEY(paper_id) REFERENCES paper (paper_id)
)


CREATE TABLE paper (
	paper_id TEXT NOT NULL -- example: ['100157', '100598'],
	class_label TEXT NOT NULL -- example: ['IR', 'Agents'],
	PRIMARY KEY (paper_id)
)

Question: On average, how many papers are under the ML class?
Evidence: class refers to class_label; average = divide(count(paper_id where class_label = 'M')), (count(paper_id)));

SQL:
SELECT CAST(COUNT(CASE WHEN class_label = 'ML' THEN paper_id ELSE NULL END) AS REAL) / COUNT(paper_id) FROM paper