title: How to display output like this in SQL?
body: <p>I have a table like the one shown below:</p>
  
  <pre><code>+----------------+-------+----------+---------+
  | Name           | Model | system   | ItemTag |
  +----------------+-------+----------+---------+
  | Alarm Id       | T58   | ASC      |         |
  +----------------+-------+----------+---------+
  | Door Lock      | F48   | ASC      |         |
  +----------------+-------+----------+---------+
  | AlarmSounder   | T58   | ASC      |         |
  +----------------+-------+----------+---------+
  | Card Reader    | K12   | ASC      |         |
  +----------------+-------+----------+---------+
  | Magnetic Lock  | F48   | ASC      |         |
  +----------------+-------+----------+---------+
  | T2 Card Reader | K12   | ASC      |         |
  +----------------+-------+----------+---------+
  | Power   Supply | Null  | ASC      |         |
  +----------------+-------+----------+---------+
  | Battery         |  Null| ASC      |         |
  +----------------+-------+----------+---------+
  </code></pre>
  
  <p>Now I want to display the data  like this:</p>
  
  <pre><code>+-------------+-------+--------+--------+
  | Name        | Model | system | count  |
  +-------------+-------+--------+--------+
  | Alarm       | T58   | ASC    | 2      |
  +-------------+-------+--------+--------+
  | Door Lock   | F58   | ASC    | 2      |
  +-------------+-------+--------+--------+
  | Card Reader | K12   | ASC    | 2      |
  +-------------+-------+--------+--------+
  |Power supply | Null   | ASC    | 1     |
  +-------------+-------+--------+--------+
  | Battery    | Null   | ASC    | 1     |
  +-------------+-------+--------+--------+
  </code></pre>
  
  <p>How to do it in SQL? </p>
  
  <p>Updated 
  I also included null column as my second update. </p>