title: Alias in where query in SOQL
body: <p>I am trying to take the count from the object <strong>Lead</strong> using SOQL.
  When I am hitting the below mention query, I am getting the results.</p>
  
  <pre><code>select 'Lead' as source_table,count(*) as source_count from Lead
  </code></pre>
  
  <p>But when I am trying to give <code>where</code> condition with this query, then it is throwing me the error.</p>
  
  <blockquote>
    <p>select 'Lead' as source_table,count() as source_count from Lead where
    CreatedDate > 2020-02-24T09:43:51Z</p>
  </blockquote>
  
  <p>Is there anything that I am missing.</p>