title: SQL query (if possible)
body: <p>I have a table like</p>
  
  <pre>
  +------------------------+
  | DATE       | INT       |  
  +------------------------+
  | [DATE]     | [TICKETS] |  
  | ---------- | ----------|  
  | 01/01/2016 | 100       |  
  | 01/02/2016 | 10        |  
  | 01/03/2016 | 30        |  
  | 02/15/2016 | 28        |  
  | 02/29/2016 | 80        |  
  | 01/01/2017 | 25        |  
  | 01/02/2017 | 120       |  
  | 01/03/2017 | 60        |  
  | 02/15/2017 | 72        |  
  | 02/28/2017 | 12        |  
   ------------------------
  </pre>
  
  <p>I would like a (SELECT) query (if possible) to have something like</p>
  
  <pre>
                       ---------------------------------------------
                      | [DATE]     | [TICKETS2016]  | [TICKETS2017] |  
                     _| ---------- | -------------- | ------------- |  
  highest           / | 01/01/2017 | 100            |  25           | 
  year for the     /  | 01/02/2017 | 10             |  120          | 
  common days.     \  | 01/03/2017 | 30             |  60           | 
                    \_| 02/15/2017 | 28             |  72           | 
  Exists only at 2017>| 02/28/2017 | NULL           |  12           | 
  Exists only at 2016>| 02/29/2016 | 80             |  NULL         | 
                       ---------------------------------------------
  </pre>
  
  <p>Since I am a newbie with SQL, I would like to ask for your help.</p>
  
  <p>Thank you very much for your time.</p>