title: How can the below 3 select statements be included in a single mySQL view
body: <p>Need to create a single view that executes the below 3 select statements</p>
  
  <p>I am able execute them in a SQL editor and get the ratio.</p>
  
  <pre><code>select @lag := count(twitter_handles) from handle_impressions where today_impressions &gt; yest_impressions;
  select @decay := count(twitter_handles) from handle_impressions where today_impressions &lt; yest_impressions;
  select @ratio := @lag/@decay;
  </code></pre>
  
  <p>The intent is to have a single view encapsulating the 3 select statements to return lag, decay and ratio</p>