-- 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 ] |
-- -- How many chapters include the character name "First Witch"?

SELECT COUNT(T2.chapter_id) FROM characters AS T1 INNER JOIN paragraphs AS T2 ON T1.id = T2.character_id WHERE T1.CharName = 'First Witch';