title: MySQL Count name greater than a value
body: <p>Please how can i check if a particular name is greater than a value in MySQL database. I want to do something like.
      SELECT id FROM table WHERE COUNT(name = 'john') > 2
  i know this does not work, but i really need to do something like this.</p>
  
  <p>An Example: A student studying CS, From New York, and grad point is 4.5 wants to check into a hostel.
  I have a hostel tables with fields course, state, and Grade_Point. i want to select the hostel_id where no same user with the same course > 2, state > 2 and grade_point > 2 are in the same room.</p>