title: MySQL group by does not work
body: <p>I have a table called nasdaq_transactions looks like below</p>
  
  <pre><code>Ticker  Close   Date
  GOOG    1195.06 08/15/2018
  AAPL    215.15  08/15/2018
  MSFT    104.56  08/15/2018
  GOOG    1198.11 08/16/2018
  AAPL    216.1   08/16/2018
  MSFT    105.1   08/16/2018
  GOOG    1200.96 08/17/2018
  AAPL    217.58  08/17/2018
  MSFT    107.58  08/17/2018
  </code></pre>
  
  <p>Want to build a query that gives a output</p>
  
  <pre><code>Ticker  08/15/2018  08/16/2018  08/17/2018
  GOOG    1196.06      1198.11     1200.96
  AAPL    215.15       216.1       217.58
  MSFT    104.56       105.1       107.58
  </code></pre>
  
  <p>Wrote a query </p>
  
  <pre><code>select tabl.ticker, CASE WHEN tabl.date = '2018-08-15' THEN tabl.close END AS '2018-08-15',CASE WHEN tabl.date = '2018-08-16' THEN tabl.close END AS '2018-08-16', CASE WHEN tabl.date = '2018-08-17' THEN tabl.close END AS '2018-08-15'(select ticker, close, date from nasdaq_transactions where date in ('2018-08-15', '2018-08-16','2018-08-17'))tabl
  </code></pre>
  
  <p>Partial output for this query is </p>
  
  <pre><code>+------------+------------+------------+-----------+
  | Ticker     | 2018-08-15 | 2018-08-16 |2018-08-17 |
  +------------+------------+------------+-----------+
  | GOOG       |    1196.06 |     NULL   |     NULL  |
  | GOOG       |      NULL  |    1198.11 |     NULL  | 
  | GOOG       |      NULL  |     NULL |     1200.96 | 
  | AAPL       |    215.15  |     NULL |     NULL    |
  </code></pre>
  
  <p>Not allowing group by so that I can get a single row for a ticker, am not a DB expert. Appreciate a working fix.</p>