Q&A for active researchers, academics and students of physics
SELECT 'Deleted Questions' AS Type, COUNT(*) AS Count FROM PostsWithDeleted WHERE PostTypeId = 1 AND DeletionDate IS NOT NULL UNION SELECT 'Not deleted questions with deleted answers' AS Type, COUNT(DISTINCT Q.Id) AS Count FROM PostsWithDeleted Q, PostsWithDeleted A WHERE A.ParentId = Q.Id AND Q.DeletionDate IS NULL AND A.DeletionDate IS NOT NULL UNION SELECT PostTypes.Name AS Type, COUNT(*) AS Count FROM PostsWithDeleted, PostTypes WHERE PostsWithDeleted.DeletionDate IS NOT NULL AND PostsWithDeleted.PostTypeId = PostTypes.Id GROUP BY PostTypes.Name ORDER BY Type;