title: MySql Number of appointment by user based on DATE
body: <p>I would like to know how many appointment taken by particular user in ONE DAY.  </p>
  
  <p>table A</p>
  
  <p>Date_time                    user_id</p>
  
  <p>2014-08-25 21:00:00           1</p>
  
  <p>2014-08-25 01:00:00           1</p>
  
  <p>2014-08-25 03:00:00           2</p>
  
  <p>2014-08-25 16:00:00           1</p>
  
  <p>2014-08-26 015:00:00           1</p>
  
  <p>2014-08-26 011:00:00           2</p>
  
  <p>2014-08-26 010:00:00           2</p>
  
  <p>2014-08-26 010:00:00           1</p>
  
  <p>TABLE B</p>
  
  <p>user_id      user_name</p>
  
  <p>1            xyz</p>
  
  <p>2            abc</p>
  
  <p>RESULT SHOULD BE</p>
  
  <p>USER   DATE      NUMBER OF APP       </p>
  
  <p>xyz    2014-08-25      3</p>
  
  <p>abc    2014-08-25      1</p>
  
  <p>xyz    2014-08-26      2</p>
  
  <p>abc    2014-08-26      2         </p>