title: Count in SQL server
body: <pre><code>select
  hotel.hotel_name 'Hotel Name',
  Address 'Address',
  Description 'Description',
  Contact_No 'Contact Number'
  from hotel, customer_profile, booking_details where
  customer_profile.email = booking_details.email
  and hotel.hotel_name = booking_details.hotel_name
  and booking_details.email = 'davidho@yahoo.com'
  order by 1
  </code></pre>
  
  <p>I can't add images /:</p>
  
  <p>So for example currently my result is</p>
  
  <pre><code>+-----------------------+
  | Name   | Address      |
  +-----------------------+
  | Hotel1 | Beach Road1  | 
  | Hotel2 | Beach Road2  |
  | Hotel2 | Beach Road2  |
  +-----------------------+
  </code></pre>
  
  <p>I want it to remove the duplicates, and add a new column "Number of times" which indicate how many times it appeared.</p>
  
  <p>I want it to be</p>
  
  <pre><code>+------------------------------------+
  | Name   | Address     | No of Times |
  +------------------------------------+
  | Hotel1 | Beach Road1 | 1           |
  | Hotel2 | Beach Road2 | 2           |
  +------------------------------------+
  </code></pre>