title: YEAR as an input
body: <p>There is a table in my SQL Server called <code>Product</code> and the columns are <code>ID, NAME, YEAR, COST</code></p>
  
  <p><strong>Sample data:</strong></p>
  
  <pre><code>ID   NAME     YEAR            COST
  ----------------------------------                                           
  1        A      2006 05 03     4
  2        B      2006 04 01     5
  3        C      2001 05 01     6
  4        D      2002 05 02     7
  5        E      2003 04 01     8
  </code></pre>
  
  <p>I want to take only the YEAR as an input like 2006 as an input and i want an output that shows all the added cost of that year. HOW can i do this?</p>
  
  <p><strong>Expected output:</strong></p>
  
  <pre><code>ID   NAME    YEAR         TOTAL
  -------------------------------
  1     A      2006 05 03     9
  2     B      2006 02 01     9
  3     C      2001 05 01     6
  4     D      2002 05 02     7
  5     E      2003 04 01     8
  </code></pre>