Query 2

SELECT stock_symbol, VARIANCE(share_price) var
  FROM trade
  GROUP BY stock_symbol
  ORDER BY var DESC;