Based on the 4 tables below, use "WHERE" to express joins between tables and write SQL queries for problems 1-6.(these are more examples of SQL compounds joins)

A presentation consists of a single speaker appearing in a single session.

room table

session speaker table

session table

speaker table

problems 1 to 6:

1. Show the title, starting time, room ID, and room capacity for each session.

2. For each presentation at the conference, show the speaker first name, speaker last name, speaker area of expertise, session title, room ID, and session start time.

3. Show the same information as part (b), but only for speakers from Florida (state code FL).

4. Show the same information as part (b), but only for speakers who are from Florida or whose area of expertise is Wellness.

5. For each presentation being given in a room with a capacity of at least 100, show the speaker ID, speaker first name, speaker last name, room ID, and room capacity.

6. Show the speaker ID, first name, and last name for all speakers giving any presentations in a room with a seating capacity of at least 100.

Room Table on speaker Session Table \begin{tabular}{|r|l|r|r|l|} \hline SessionID & \multicolumn{1}{|c|}{ SessionTitle } & RoomID & \multicolumn{1}{|c|}{ Date } & StartingTime \\ \hline 1 & UnderstandingDiversitywithintheUniversity & 101 & 20030801 & 10:00:00 \\ \hline 2 & VolunteerServicesandtheUniversityStudent & 103 & 20030801 & 10:00:00 \\ \hline 3 & Outreach Initiatives & 104 & 20030801 & 14:00:00 \\ \hline 4 & Creating Active Citizens & 101 & 20030801 & 14:00:00 \\ \hline 5 & Interdisciplinary Service Learning & 101 & 20030802 & 10:00:00 \\ \hline 6 & Living and Learning & 102 & 20030802 & 10:00:00 \\ \hline 7 & Student Leadership Opportunities & 105 & 20030802 & 10:00:00 \\ \hline 8 & A One-Day Service Project & 105 & 20030802 & 14:00:00 \\ \hline 9 & Engaging Student Leaders & 104 & 20030802 & 14:00:00 \\ \hline 10 & Building Service Teams & 102 & 20030803 & 11:00:00 \\ \hline 11 & Alternative Spring Break & 103 & 20030803 & 10:00:00 \\ \hline 12 & Involving Faculty in Service Projects & 101 & 20030803 & 15:00:00 \\ \hline 13 & University Collaboration & 104 & 20030803 & 14:00:00 \\ \hline \end{tabular}