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: Name the paper which is cited most times and the paper which is cited least times? Also, find the number of times each one is cited.

SQL:
SELECT cited_paper_id, COUNT(cited_paper_id), ( SELECT cited_paper_id FROM cites GROUP BY cited_paper_id ORDER BY COUNT(cited_paper_id) ASC LIMIT 1 ), ( SELECT COUNT(cited_paper_id) FROM cites GROUP BY cited_paper_id ORDER BY COUNT(cited_paper_id) ASC LIMIT 1 ) FROM cites GROUP BY cited_paper_id ORDER BY COUNT(cited_paper_id) DESC LIMIT 1