### 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:
Among the comedy works of Shakespeare, what is the percentage of his works with a character named "antonio"?

### Extra Knowledge:
comedy works refers to GenreType = 'Comedy'; a character named "antonio" refers to CharName = 'antonio'; percentage = divide(sum(CharName = 'Antonio'), count(CharName)) as percentage
SELECT CAST(SUM(IIF(T4.CharName = 'antonio', 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 WHERE T1.GenreType = 'Comedy'