title: Combine two Cloudwatch insights queries
body: <p>I have two Cloudwatch insights queries that I would love to be able to run side by side and compare the results of both two.</p>
  
  <pre><code>stats count(*) as requestIdCount by @requestId 
  | filter @message like /START RequestId/
  | filter requestIdCount &gt; 1
  </code></pre>
  
  <pre><code>stats count(*) as requestIdCount by @requestId 
  | filter @message like /END RequestId/
  | filter requestIdCount &gt; 1
  </code></pre>
  
  <p>It would be great to be able to do</p>
  
  <pre><code>fields (
      stats count(*) as requestIdCount by @requestId 
      | filter @message like /END RequestId/
      | filter requestIdCount &gt; 1) as EndRequestCount,
         (
      stats count(*) as requestIdCount by @requestId 
      | filter @message like /START RequestId/
      | filter requestIdCount &gt; 1) as StartRequestCount 
  </code></pre>
  
  <p>But I don't see any way to do subqueries in insights right now. Is there a method to combine queries like this?</p>