title: SQLite filter on a renamed column not working
body: <p>I'm trying to apply a filter on a renamed field while selecting it but it doesn't work</p>
  <p>here's the table of transactions I want to filter:</p>
  <pre><code>id      stock   buy sell    price       trans_date              buy_sell
  2       AAPL    10  0       141.77      28-Jan-2021 04:59:58    Buy
  2       AAPL    5   0       141.77      28-Jan-2021 04:59:19    Buy
  2       SSSS    5   0       14.83       28-Jan-2021 04:59:47    Buy
  2       NFLX    5   0       522.8       28-Jan-2021 05:00:11    Buy
  2       MSFT    5   0       232.88      28-Jan-2021 05:01:47    Buy
  2       NFLX    2   0       522.8       28-Jan-2021 04:59:37    Buy
  2       SSSS    0   2       14.83       28-Jan-2021 05:00:52    Sell
  2       SSSS    0   3       14.83       28-Jan-2021 05:02:47    Sell
  2       AAPL    0   4       141.83      28-Jan-2021 05:06:18    Sell
  2       AAPL    0   2       141.77      28-Jan-2021 05:06:18    Sell
  </code></pre>
  <p>And below is the query which I'm Trying to run</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT stock, sum(buy - sell) as share, trans_date, avg(price) as price FROM stocks 
  WHERE user_id = 2  GROUP BY stock;
  </code></pre>
  <p>I'm trying to get all data displayed but to not display whichever stock with 0 like the ssss tock below</p>
  <pre><code>stock   share   trans_date              price
  AAPL    9       28-Jan-2021 04:59:19    141.77
  MSFT    5       28-Jan-2021 05:01:47    232.88
  NFLX    7       28-Jan-2021 04:59:37    522.8
  SSSS    0       28-Jan-2021 04:59:47    14.83
  </code></pre>
  <p>Any suggestions? to remove that <strong>SSSS</strong> from the filtered table ?</p>