title: SQL stats for customers that have not ordered a type of product ever
body: <p>In a SQL DB I have a table with a list of customer IDs.  I Also have a table of orders with foreign IDs Price, Quantity and type(1 or 0).</p>
  
  <p>I want to know overall for the list of customers the total Price, the total quantity and the count of orders for customers that have only ever ordered type 0.</p>
  
  <p>I was thinkining I need to first get a list of customers that only ever use type 0 first and then get the stats but not sure how to do this easily. </p>
  
  <p>Order table:</p>
  
  <pre><code>|OrderNo| CustomerCD| Type|Price|Quantity|
  </code></pre>
  
  <p>list of customers table( subset of all customers):</p>
  
  <pre><code>|customer ID|
  </code></pre>
  
  <p>Looking for a simple query that outputs the overall metrics for customers that have never used type 1</p>