title: Counting new Customers per Month
body: <p>I am crazy confused about this for some reason. </p>
  
  <p>Basically, I'm looking for a query that will find the number of new customers per month, since 2010.</p>
  
  <p>I have the customer's email address(email), all orders placed(OrderID), and what date it was placed on(OrderDate). The table is tblOrder.</p>
  
  <p>I know that a "new customer" is: (a) someone who's never ordered <em>before</em> the date/month and (b) who has at least one order <em>after</em> the date/month</p>
  
  <p>I'd want the output to be something like this in the end, with a simpler method being better:</p>
  
  <pre><code>      01   02   03   04   05   06   07   08   09   10   11   12
  2010  ##   ##   ##   ##   ##   ##   ##   ##   ##   ##   ##   ##
  2011  ##   ##   ##   ##   ##   ##   ##   ##   ##   ##   ##   ##
  2012  ##   ##   ##   ##   ##   ##   ##   ##   ##   ##   ##   ##
  </code></pre>
  
  <hr>
  
  <p>And I was given this to work with, but guys, I'm seriously not a programmer, and it may look simple to some of y'all but it's over my head and not clicking with me at all.</p>
  
  <pre><code>SELECT &lt;customer info&gt; 
  FROM &lt;customer table&gt; 
  WHERE (SELECT COUNT(&lt;order info&gt;) 
      FROM &lt;order table&gt; 
      WHERE &lt;customer info&gt; = &lt;current customer&gt; 
          AND &lt;date&gt; &lt; &lt;target date&gt;) = 0 
          AND (SELECT COUNT(&lt;order info&gt; 
              FROM &lt;order table&gt; 
              WHERE &lt;customer info&gt; = &lt;current customer&gt; 
              AND &lt;date&gt; &gt; &lt;target date&gt;) &gt; 0
  </code></pre>
  
  <p>I know this isn't valid SQL either. So I don't know what to do with it. And I think it just pulls a list of applicable customers (meaning those who haven't ordered before the inputted month) rather than counting them all up and totaling them like I ultimately want.</p>