(Conference database): From the textbook website, download the file conference.mdb, which describes the sessions and speakers at a conference. Write SQL queries for the following: A Show the first name, last name, e‐mail address, and area of expertise for every speaker, along with the number of sessions they are speaking in, labeled NumSessions. If a speaker is not yet scheduled as appearing in any sessions, they should still appear, but the number of session should be zero. Sort the output from most session appearances to least session appearances; for speakers with the same number of session appearances, sort them alphabetically by last name. B Show the ID, capacity and number of sessions (labeled NumSessions) being held in each room, sorted alphabetically by room ID. Rooms with no sessions should still appear in the output, but with a zero for their number of sessions. C A “presentation” consists of a speaker appearing in a session. Create a query called Presentations which shows, for every presentation in the conference, all the associated fields from the Speakers table and the Sessions table. Using this query as a subquery, write a query that shows the ID of each room, its capacity, and the number of presentations taking place in it. D Write a query called SpeakersRooms that shows every possible combination of SpeakerID and RoomID for which the speaker is appearing in a session being held in the room. If a speaker is appearing more than once in a room, the combination should only appear once (hint: use SELECT DISTINCT)
The post download the file conference.mdb, which describes the sessions and speakers at a conference. Write SQL queries for the following: appeared first on Best Custom Essay Writing Services | EssayBureau.com.
