title: How to combine 2 queries to one query database in sql from single table?
body: <p>Faced such a problem - I can not combine these two requests, how to be? All data from one table</p>
  
  <pre><code>SELECT
    max(f.price) AS max_rent,
    min(f.price) AS min_rent
  FROM Commercial f
  WHERE f.type = 1;
  SELECT
    max(f.price) AS max_sale,
    min(f.price) AS min_sale
  FROM Commercial f
  WHERE f.type = 0;
  </code></pre>
  
  <hr>
  
  <p>Received Result. 2 tables with results</p>
  
  <pre><code>+---------+---------+ +---------+---------+
  | max_sale| min_sale| |max_sale | min_sale|
  +---------+---------+ +---------+---------+
  |  23     |  45     | |   15    |  52     | 
  +---------+---------+ +---------+---------+
  </code></pre>
  
  <p>Expected Result. 1 table with results</p>
  
  <pre><code>+---------+---------+---------+---------+
  | max_sale| min_sale| max_sale| min_sale|
  +---------+---------+---------+---------+
  |  23     |  45     |   15    |  52     | 
  +---------+---------+---------+---------+
  </code></pre>