title: How to make a query to a table generated by a select?
body: <p>As an example:</p>
  
  <pre><code>SELECT name, address, phone FROM USER;
  </code></pre>
  
  <p>Generates the table</p>
  
  <pre><code>name | address | phone 
  ...  |   ...   |  ...
  </code></pre>
  
  <p>How can i use this table generated to make another query to it?</p>
  
  <p>For example:</p>
  
  <pre><code>SELECT count(address) FROM (SELECT name, address, phone, from user);
  </code></pre>
  
  <p>I know it's not the best example, but is there any way to do this?</p>