title: SQL select all records from one table which appear < 3 times in another
body: <p>I have got two tables:</p>
  
  <pre><code>Event
  +----------+---------+--------------+
  | event_id | name    | date         |
  +----------+------+-----------------+
  | 1        | Event 1 | 26/03/2012   |
  +----------+------+-----------------+
  | 2        | Event 2 | 27/03/2012   |
  +----------+------+-----------------+
  
  Reservation
  +----------------+------------+--------------+
  | reservation_id | date       | themed_id    |
  +----------------+------------+--------------+
  | 1              | 26/03/2012 | 1            |
  +----------------+------------+--------------+
  | 2              | 26/03/2012 | 1            |
  +----------------+------------+--------------+
  | 3              | 27/03/2012 | 2            |
  +----------------+------------+--------------+
  | 4              | 26/03/2012 | 1            |
  +----------------+------------+--------------+
  </code></pre>
  
  <p>How will I display all the events which appear less than 3 times in the reservation table.</p>
  
  <p>The output will be:</p>
  
  <pre><code>+----------+---------+--------------+
  | event_id | name    | date         |
  +----------+------+-----------------+
  | 2        | Event 2 | 27/03/2012   |
  +----------+------+-----------------+
  </code></pre>
  
  <p>As event two has only appeared once in reservation</p>
  
  <p>thanks</p>