### Database Schema:
CREATE TABLE paragraphs (
	id	INTEGER	NULL	PRIMARY KEY,
	ParagraphNum	INTEGER	NOT NULL,
	PlainText	TEXT	NOT NULL,
	character_id	INTEGER	NOT NULL,
	chapter_id	INTEGER	NOT NULL	DEFAULT 0,
	foreign key (character_id) references characters (id),
	foreign key (chapter_id) references chapters (id)
);

CREATE TABLE chapters (
	id	INTEGER	NULL	PRIMARY KEY,
	Act	INTEGER	NOT NULL,
	Scene	INTEGER	NOT NULL,
	Description	TEXT	NOT NULL,
	work_id	INTEGER	NOT NULL,
	foreign key (work_id) references works (id)
);

CREATE TABLE works (
	id	INTEGER	NULL	PRIMARY KEY,
	Title	TEXT	NOT NULL,
	LongTitle	TEXT	NOT NULL,
	Date	INTEGER	NOT NULL,
	GenreType	TEXT	NOT NULL
);

CREATE TABLE characters (
	id	INTEGER	NULL	PRIMARY KEY,
	CharName	TEXT	NOT NULL,
	Abbrev	TEXT	NOT NULL,
	Description	TEXT	NOT NULL
);

### User's Query:
Between Rome and Juliet, which character was mentioned the most in the The Tragedy of Romeo and Juliet? Calculate for Romeo and Juliet's individual amount of appearance in percentage against the overall number of characters that appeared in the said work.

### Extra Knowledge:
Rome and Juliet refers to CharName = 'Romeo' and CharName = 'Juliet'; The Tragedy of Romeo and Juliet refers to LongTitle = 'The Tragedy of Romeo and Juliet'; percentage = divide(sum(charater.id) when CharName = 'Romeo', sum(charater.id)) as percentage and percentage = divide(sum(charater.id) when CharName = 'Juliet', count(charater.id)) as percentage
SELECT SUM(IIF(T4.CharName = 'Romeo', 1, 0)), SUM(IIF(T4.CharName = 'Juliet', 1, 0)), CAST(SUM(IIF(T4.CharName = 'Romeo', 1, 0)) + SUM(IIF(T4.CharName = 'Juliet', 1, 0)) AS REAL) * 100 / COUNT(T1.id) FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id INNER JOIN paragraphs AS T3 ON T2.id = T3.chapter_id INNER JOIN characters AS T4 ON T3.character_id = T4.id