filter by status for subscription and modify the typo of title and add drop statement of db sql