-- Database schema
| chapters : id [ INTEGER ] primary_key , Act [ INTEGER ] , Scene [ INTEGER ] , Description [ TEXT ] , work_id [ INTEGER ] | characters : id [ INTEGER ] primary_key , CharName [ TEXT ] , Abbrev [ TEXT ] , Description [ TEXT ] | paragraphs : id [ INTEGER ] primary_key , ParagraphNum [ INTEGER ] , PlainText [ TEXT ] , character_id [ INTEGER ] , chapter_id [ INTEGER ] | works : id [ INTEGER ] primary_key , Title [ TEXT ] , LongTitle [ TEXT ] , Date [ INTEGER ] , GenreType [ TEXT ] |
-- -- What is the title which has character named "Froth"?

SELECT DISTINCT T1.title 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 T4.CharName = 'Froth';