db_blog_short

Database schema

SQL query to do

Please provide data about all posts and the number of comments each one has. Only the posts written from the 1 July 2014 (inclusive) are needed. Required attributes are the post date, post title and number of comments. That latter has to be renamed into NbOfComments.

{{flash_text1}}