title: Why does my Query return "Empty set (0.00 sec)"?
body: <p>SOLVED-run UPDATE building SET building_name = "Main Street Building" WHERE building_id = 2;
  From there, the task 3 query will return proper results.</p>
  
  <p><strong>Task One:</strong></p>
  
  <p>Query:</p>
  
  <pre><code>SELECT first_name, last_name, building_name, room.room_id, meeting_start,meeting_end
  FROM meeting, person, person_meeting,room, building
  WHERE room.room_id=meeting.room_id
  AND meeting.meeting_id=person_meeting.meeting_id
  AND person.person_id=person_meeting.person_id
  AND room.building_id=building.building_id
  AND person.first_name='Tom'
  AND person.last_name='Hanks';
  </code></pre>
  
  <p><strong>Task Two:</strong></p>
  
  <p>Query:</p>
  
  <pre><code>SELECT first_name, last_name, building_name, room.room_id, meeting_start,meeting_end
  FROM meeting, person, person_meeting,room, building
  WHERE room.room_id=meeting.room_id
  AND meeting.meeting_id=person_meeting.meeting_id
  AND person.person_id=person_meeting.person_id
  AND room.building_id=building.building_id
  AND meeting.meeting_id=2;
  </code></pre>
  
  <p><strong>Task Three:</strong></p>
  
  <p>Query:</p>
  
  <pre><code>SELECT first_name, last_name, building_name, room.room_id,meeting.meeting_id, meeting_start, meeting_end
  FROM meeting, person, person_meeting,room, building
  WHERE room.room_id=meeting.room_id
  AND meeting.meeting_id=person_meeting.meeting_id
  AND person.person_id=person_meeting.person_id
  AND room.building_id=building.building_id
  AND building_name='Main Street Building';
  </code></pre>
  
  <p><strong>Task Four:</strong></p>
  
  <p>Query:</p>
  
  <pre><code>SELECT count(person_id) 'Count of meeting attendees', meeting.meeting_id,meeting_start,meeting_end
  FROM meeting, person_meeting
  WHERE meeting.meeting_id=person_meeting.meeting_id
  GROUP BY meeting.meeting_id;
  </code></pre>
  
  <p><strong>Task Five:</strong></p>
  
  <p>Query:</p>
  
  <pre><code>SELECT first_name, last_name, meeting.meeting_id, meeting_start, meeting_end
  FROM meeting INNER JOIN person_meeting ON meeting.meeting_id=person_meeting.meeting_id
  INNER JOIN person ON person.person_id=person_meeting.person_id
  AND meeting_start&lt;'2016-12-25 12.00.00';
  </code></pre>
  
  <p>Task 1,2,4,5 and 5 all run perfectly. if you all need the task prompts, let me know.</p>