For the intermediate level:

match (q:Question)-[:TAGGED]->(Tag { name: 'perl'})
with q.title as title, q.score as score, q.createdAt.day as day, q.createdAt.month as month
where month = 4 and day = 1
return title order by score desc limit 1

The same query, but a little bit shorter:

match (q:Question)-[:TAGGED]->(t:Tag { name: 'perl' })
where datetime(q.createdAt).day = 1 and datetime(q.createdAt).month = 4
return q.title order by q.score desc limit 1

Built With

Share this project: