title: Join Multiple Sql statements from the same table
body: <p>I have read many post on this topic but I am not yet satisfied.</p>
  
  <p>I have a table called <code>ticket</code> with the following columns</p>
  
  <pre><code>TicketID | AirlineID | PassengerID | TicketPrice | TicketVolume | DestinationCountry | ExitCountry | TicketDate`
  </code></pre>
  
  <p>I have multiple queries like</p>
  
  <pre><code>SELECT AVG(TicketPrice) 
  FROM ticket 
  WHERE TicketPrice between 552 and 1302
  AND AirlineID=1 
  AND TicketDate between '2016-01-01' and '2016-12-31' 
  GROUP BY TicketDate
  
  SELECT AVG(TicketPrice) 
  FROM ticket 
  WHERE TicketPrice between 552 and 1302 
  AND AirlineID=1 
  AND TicketDate between '2017-01-01' and '2017-12-31' 
  GROUP BY TicketDate
  </code></pre>
  
  <p>Please how can I join both queries to form another table side by side</p>
  
  <pre><code>+--------------------------------++-----------
  | AirlineID || Average Ticket Price 2016/2017|
  +--------------------------------++-----------
  </code></pre>
  
  <p>they are actually more queries.</p>