use scheduling;


SELECT first_name,last_name ,building_name,
room_number ,meeting_start,meeting_end
FROM person P, building B,person_meeting PM,meeting M,room R
WHERE
P.person_id=PM.person_id
AND M.room_id=R.room_id
AND B.building_id=R.building_id
AND PM.meeting_id=M.meeting_id
AND P.first_name='Tom'
AND P.last_name='Hanks';

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;

SELECT first_name, last_name, building_name,
room.room_id, meeting_start,meeting_end
FROM person
WHERE
building.building_id =2
AND building.building_id = room.building_id
AND room.room_id = meeting.room_id
AND person.person_id=person_meeting.person_id
AND meeting.meeting_id=person_meeting.meeting_id;

select count(person_meeting.person_id) as number_attendees,
meeting.meeting_id, meeting.meeting_start, meeting.meeting_end
from meeting
join person_meeting
on meeting.meeting_id = person_meeting.meeting_id
group by meeting.meeting_id, meeting.meeting_start, meeting.meeting_end;

select person.first_name, person.last_name,
person_meeting.meeting_id, meeting.meeting_start, meeting.meeting_end
from person
join person_meeting on person_meeting.person_id = person.person_id
join meeting on meeting.meeting_id = person_meeting.meeting_id
where meeting.meeting_end > "2016-12-25 12:00:00" ;