instruction: Count of posts where more than 10 comments.
response: SELECT Id FROM (SELECT p.Id, COUNT(*) AS CommentCount FROM Posts AS p INNER JOIN Comments AS c ON c.PostId = p.Id GROUP BY p.Id, p.Title, p.CreationDate, CommentCount HAVING CommentCount > 100) AS t