title: sql table's count() function
body: <p>How can I count names as total </p>
  
  <p>TABLE 1 is </p>
  
  <pre><code>PROGRAM, PART,COLOR 
  </code></pre>
  
  <p>TABLE 2 is</p>
  
  <pre><code>SERIAL,NAME
  </code></pre>
  
  <p>Query:</p>
  
  <pre><code>select program,table_1.part_customer,color, table_2.[serial],table_2.operator
  from table_1 
  inner join table_2 
  on Table_1.[PART_customer]=table_2.[PART_customer_1]
  </code></pre>
  
  <p><strong>OUTPUT is shown below;</strong></p>
  
  <pre><code>PROGRAM     PART    COLOR     SERIAL    NAME              
  -------     ----    -----      ----     -----
  BMW          100    BLUE      1         STEVE
  BMW          100    BLUE      1         STEVE
  BMW          100    BLUE      1         STEVE
  MERCEDES     200    SILVER    2         NEIL
  MERCEDES     200    SILVER    2         NEIL
  AUDI         300    GREEN     3         JOHN
  AUDI         300    GREEN     3         JOHN  
  MERCEDES     200    SILVER    2         NEIL
  MERCEDES     200    SILVER    3         NEIL
  BMW          100    BLUE      1         STEVE
  BMW          100    BLUE      1         STEVE
  GM           500    RED       5         MIKE
  GM           500    RED       5         MIKE
  GM           500    RED       5         MIKE
  VOLKSWAGEN   400    BLACK     4         DAVID
  VOLKSWAGEN   400    BLACK     4         DAVID
  VOLKSWAGEN   400    BLACK     4         DAVID
  VOLKSWAGEN   400    BLACK     4         DAVID
  VOLKSWAGEN   400    BLACK     4         DAVID
  </code></pre>
  
  <p><strong>I would like to get an output as;</strong></p>
  
  <pre><code>PROGRAM     PART    COLOR     SERIAL    NAME      TOTAL          
  -------     ----    -----      ----     -----     -----
  BMW         100    BLUE       1        STEVE      5
  MERCEDES    200    SILVER     2        NEIL       4
  AUDI        300    GREEN      3        JOHN       2
  GM          500    RED        5        MIKE       3
  VOLKSWAGEN  400    BLACK      4        DAVID      5
  </code></pre>