title: Displaying postcode on mysql
body: <p>I'm trying to get the number of guests who have stayed into each of the hotels (three hotels in total). My code is below.</p>
  
  <pre><code>select hotelbook.hotelname, postcode, count(guestid)
  from hotel, hotelbook
  group by hotelname
  </code></pre>
  
  <p>I have to display the number of guests, which I have done successfully. I have to also display the name of the hotel, which I've done. And I also have to display the postcode, which is the problem for me at the moment. When I run this code, everything looks fine, but the postcode for the three hotels is the same. </p>
  
  <p>I looked back at my created table, but I've given unique postcodes to the three hotels. Help is, as ever, appreciated.</p>
  
  <p>EDIT - code has been changed to:</p>
  
  <pre><code>select hotel.hotelname, postcode, count(guestid)
  from hotel, hotelbooking
  group by hotelname
  </code></pre>
  
  <p>Post codes are unique for every hotel, thanks for the help. However, the count is the same for each hotel. Help appreciated, thanks.</p>