-- 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 paragraph number with plain text "This is Illyria, lady"?

SELECT ParagraphNum FROM paragraphs WHERE PlainText = 'This is Illyria, lady.';