-- 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 ] |
-- -- Which Shakespeare tragedy has the most scenes? Give the long title.

SELECT T.LongTitle FROM ( SELECT T1.LongTitle, COUNT(T2.Scene) AS num FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T1.GenreType = 'Tragedy' GROUP BY T1.LongTitle, T2.Scene ) AS T ORDER BY T.num DESC LIMIT 1;