title: Teradata SQL - two counts from same column
body: <p>I'm new to SQL and Teradata. I tried searching for an answer to this but have been unsuccessful so far.</p>
  
  <p>I created a volatile table with a column that holds a value of &lt;100 (can include negatives). I want to get a total count, a count of all "0"values, a count of all values where 0
  
  <p>I know I could just do a separate statement for each type but for my own knowledge I want to learn the "proper" way. I tried using a similar solution found at this link - <a href="https://stackoverflow.com/questions/18297185/different-value-counts-on-same-column">Different value counts on same column</a> - but that doesn't seem to work since I need to use <code>&gt;</code>, <code>&lt;</code>, and similar operators.</p>
  
  <p>A layout similar to the table in that thread would be sufficient.</p>
  
  <p>Thanks for the help.</p>