BI Q21: use OPTIONAL MATCH to consider persons with zero messages
@@ -11,8 +11,9 @@ WITH
$endDate/10000000000000 AS endDateYear,
$endDate/100000000000%100 AS endDateMonth
MATCH
- (country)<-[:IS_PART_OF]-(:City)<-[:IS_LOCATED_IN]-
- (zombie:Person)<-[:HAS_CREATOR]-(message:Message)
+ (country)<-[:IS_PART_OF]-(:City)<-[:IS_LOCATED_IN]-(zombie:Person)
+OPTIONAL MATCH
+ (zombie)<-[:HAS_CREATOR]-(message:Message)
WHERE zombie.creationDate < $endDate
AND message.creationDate < $endDate
WITH
