title: Sqlite query - column with sum from first column
body: <p>Let's say that I have this query</p>
  
  <pre><code>select 
      count(customerid) as Count_Own,
      (select count(customerid) from Customers) Count_ALL 
  from 
      Customers
  where 
      EmployeeID = 1
  </code></pre>
  
  <p>It's showing count of customers for employeeid = 1 in first columns and all employees in second column.</p>
  
  <p>Now I want to write similar query by instead of table <code>Customers</code>, I have big subquery:</p>
  
  <pre><code>select 
      count(customerid) as Count_Own,
      (select count(customerid) from /*BIG QUERY*/) Count_ALL 
  from 
      ( /*BIG QUERY*/   )
  where 
      EmployeeID = 1
  </code></pre>
  
  <p>I have a problem now with column <code>Count_ALL</code>, because I wanted count this quick, without using my subquery. I wonder if it's simply solution for it.</p>