title: Hotels that took orders more than 5 times (MYSQL)
body: <p>I want to SELECT the Hotels that took orders more than 5 times. for that first I need to count the number of orders each hotels took.</p>
  <p><a href="https://i.stack.imgur.com/hF6Cp.png" rel="nofollow noreferrer">This is SCHEMA of database</a></p>
  <p>I tried this query to count number of orders from hotels</p>
  <pre><code>SELECT h.hotel_id , h.hotel_name , COUNT(o.hotel_id) 
  FROM hotel_details h
  JOIN orders o ON h.hotel_id=o.hotel_id
  </code></pre>
  <p>I got this output:</p>
  <pre><code>hotel_id    hotel_name    COUNT(o.hotel_id)
  H1001         A2B           16
  </code></pre>
  <p>16 is the number total number of orders is orders table</p>