title: How to get the number of booking for a given day?
body: <p>I have three tables: </p>
  
  <p>Booking (C_Name, C_Phone, B_Date, S_Time, S_Location, S_PCode, F_Location, F_PCode, Ach, Driver_ID_FK) </p>
  
  <p>C_NAME: customer name</p>
  
  <p>C_Phone: customer phone number</p>
  
  <p>B_Date date of booking</p>
  
  <p>S_Time: booking start time</p>
  
  <p>S_Location: booking start location</p>
  
  <p>S_PCode: start postcode</p>
  
  <p>F_Location: booking finish location</p>
  
  <p>F_PCode: finish postcode</p>
  
  <p>Ach: achieved</p>
  
  <p>Driver_ID_FK: assigned driver</p>
  
  <p>Driver (Driver_ID, Driver_Name, Driver_Phone)</p>
  
  <p>Issue (BookID, B_Date_FK, QTY) </p>
  
  <p>Desired output: </p>
  
  <p>B_DATE                           16-04-2018<br>
  Number of bookings        5</p>
  
  <p>etc</p>
  
  <p>How do I write a query ? please help me </p>