deegoods

3. total posts with at least one comment: 
select count(distinct(posts.id)) from posts left outer join comments on posts.id = comments.post_id where comments.id is not null and posts.deleted is null and comments.deleted is null;