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.

1
2
3
SELECT 
FROM 
WHERE 
X