title: Returning subquery in neo4j based on two different where conditions
body: <p>I have this query in SQL:</p>
  
  <pre><code>  Select Id, CrawlerId,CrawlerName,
   (SELECT Count(*) from CrawlerResult cr where cr.CrawlerId = cs.CrawlerId  and            IsNew=1) as LastRunResult ,
   (SELECT Count(*) from CrawlerResult cr where cr.CrawlerId = cs.CrawlerId  ) as TotalResult
    FROM CrawlerScheduler cs 
  </code></pre>
  
  <p>How to convert this query to neo4j cypher by combining CrawlerScheduler and CrawlerResult nodes?</p>