title: Neo4j value in a time range and total value
body: <p>I am new to neo4j. I am writing queries for bitcoin transactions. I want the miners, their reward in a time range and their total reward in row</p>
  <p>for example (name, value in time range, total value)</p>
  <pre><code>Binance  1500 100000
  Slush    1000 29900000
  </code></pre>
  <p>My first query for the value in time range:</p>
  <pre><code>MATCH (m:Miner)-[rel:GUESSED]-&gt;(b:Block)
  with m as m, rel as rel, b as b
  WHERE apoc.date.parse(b.time,'s') &gt;= apoc.date.parse(&quot;2021-04-01 05:29:58&quot;, 's') and apoc.date.parse(b.time,'s') &lt;= apoc.date.parse(&quot;2021-04-01 08:15:45&quot;, 's')
  return m.name, b.time, sum(rel.reward)
  
  </code></pre>
  <p>My second query for the total value</p>
  <pre><code>MATCH (m:Miner)-[rel:GUESSED]-&gt;(b:Block)
  with m as m, rel as rel, b as b
  return m.name, b.time, sum(rel.reward)
  </code></pre>
  <p>Is there a way to combine the two results in one row?</p>