Write SQL query to solve given problem: How many paragraphs are there in the longest chapter where Sir Richard Ratcliff appeared?. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT MAX(T2.ParagraphNum) FROM characters AS T1 INNER JOIN paragraphs AS T2 ON T1.id = T2.character_id WHERE T1.CharName = 'Sir Richard Ratcliff'