Question

Find all the people who have meetings in the Main Street building Construct the SQL statement to find all the

people who have meetings in the Main Street building. Display the following columns:

 Person’s first name

 Person’s last name

 Building name

 Room number

 Meeting ID

 Meeting start date and time

 Meeting end date and time

This is what I have now, what am I missing?

 SELECT first_name, last_name, building_name

room_number, meeting_id, meeting_start, meeting_end

FROM person

JOIN room ON room.room_id = building_id

JOIN meeting ON meeting.meeting_id = meeting_id 

WHERE person.person_id

GROUP BY building_name = “main street”;

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"