Task List

The following tables have already been created for you. Each table is already populated with all of the necessary records.

Use the "scheduling" database

Task One: Find all the meetings that Tom Hanks has to attend

Construct the SQL statement to find all the meetings that Tom Hanks has to attend. Display the following columns:

• Persons first name
• Persons last name
• Building name
• Room number
• Meeting start date and time
• Meeting end date and time

Task Two: Find all the people that are attending meeting ID 2

Construct the SQL statement to find all the people that are attending meeting ID 2. Display the following columns:

• Persons first name
• Persons last name
• Building name
• Room number
• Meeting start date and time
• Meeting end date and time

Task Three: 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:

• Persons first name
• Persons last name
• Building name Room number
• Meeting ID
• Meeting start date and time
• Meeting end date and time

Task Four: Find the number of attendees for every meeting

Construct the SQL statement to find the number of attendees for every meeting. Display the following columns:

• Count of meeting attendees
• Meeting ID
• Meeting start date and time
• Meeting end date and time

Task Five: Find All of the People that Have Meetings Only Before Dec. 25, 2016 at Noon Using INNER JOINs

Construct the SQL statement to find all of the people that have meetings only before Dec. 25, 2016 at noon using INNER JOINs. Display the following columns:

• Persons first name
• Persons last name
• Meeting ID
• Meeting start date and time
• Meeting end date and time

Field Notes Type Notes .Primary key person id inB) Primary key Required int(B) Required meetine id int(B) . Primary key Field Notes varchar(25) Required Required int(8) Primary key varchar(25) Required .Required int(8) Required meetine start datetime Required Field Type Required int(8) .Primary key Field Notes Required buildi int(8) Primary key room number archar(1o) ' Requirad Required int(B) Required buildine name cso) varchar(50) .Required ing(8) *Required