Which Shakespeare tragedy has the most scenes? Give the long title.
tragedy refers to GenreType = 'Tragedy'; most scenes refers to max(count(Scene))
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
database name:db_id shakespeare
chapters table chapters Cols: id dtype integer, Act dtype integer, Scene dtype integer, Description dtype text, work id dtype integer, 
characters table characters Cols: id dtype integer, char name dtype text, abbreviation dtype text, Description dtype text, 
paragraphs table paragraphs Cols: id dtype integer, paragraph number dtype integer, Plain Text dtype text, character id dtype integer, chapter id dtype integer, 
works table works Cols: id dtype integer, Title dtype text, Long Title dtype text, character id dtype integer, genre type dtype text, 
