title: MS Access SQL Query - Showing total number of orders in a certain year
body: <p>SQL appears to be more complex than I anticipated. My problem: for each customer, I would like to show the Customer ID and the total number of orders placed in 2011.</p>
  
  <p>My table looks like this</p>
  
  <pre><code>Table: Order_t
  Order_ID    Order_Date    Customer_ID
  --------    ----------    -----------
  1001        10/21/2011    1
  1002        10/25/2011    8
  1003        10/26/2011    15
  1004        10/27/2011    5
  1005        11/24/2011    3
  1006        11/27/2011    2
  1007        11/28/2011    11
  1008        12/3/2011     12
  1009        12/5/2011     1
  1010         1/16/2012    4
  </code></pre>
  
  <p>I would like my query to display a table like this:</p>
  
  <pre><code>Customer_ID    Orders_Placed
  -----------    -------------
  1              2
  2              1
  3              1
  5              1
  8              1
  11             1
  12             1
  15             1
  </code></pre>
  
  <p>My current query is this (I am currently completely neglecting the Date part because I haven't even figured out the grouping yet:</p>
  
  <pre><code>SELECT Customer_ID, SUM(Order_ID) AS Orders_Placed
  FROM Order_t
  GROUP BY Order_ID, Customer_ID
  </code></pre>
  
  <p>And this is my obviously wrong query: </p>
  
  <pre><code>Customer_ID    Orders_Placed
  -----------    -------------
  1              1001
  8              1002
  15             1003
  5              1004
  3              1005
  2              1006
  11             1007
  12             1008
  1              1009
  4              1010
  </code></pre>
  
  <p>Thanks for help, but I would also like to understand where the problem is in my logic. What crucial part do I seem to not understand?</p>