solution

A database that describes sections and speakers at a conference is given in MS Access.
3-1. Write SQL SELECT queries to display following information (2 points each):
(a) The first and last name of each speaker.
(b) A list of all areas of expertise claimed by speakers, with no repetition in the case of multiple
speakers with the same expertise area.
(c) The entirety of the rooms table.
3-2. Using WHERE to express joins between tables, write SQL queries to display
the following information. A “presentation” consists of a single speaker appearing
in a single session (2 points each).
(d) The total combined seating capacity of all rooms.
(e) The smallest room seating capacity, the average room seating capacity, and the largest room
seating capacity.
(f) The number of speakers attending the conference.
(g) The number of presentations being given at the conference.
(h) The total combined seating capacity of all rooms.
(i) The number of presentations being given in rooms whose capacity is below 100.
(j) The number of sessions taking in place in rooms that can serve refreshments.