Question: Question 3. More SQL Queries (20 points) Download the database conference.mdb. This database describes the sessions and speakers at a conference Again, for each of

 Question 3. More SQL Queries (20 points) Download the database conference.mdb.

Question 3. More SQL Queries (20 points) Download the database conference.mdb. This database describes the sessions and speakers at a conference Again, for each of the queries specified below, write the corresponding SQL code in a Word file or PDF (you can test your SQL code in Access to make sure it returns the correct data, but you do not need to submit the Access file with the queries). 1. Create a "master schedule" table for the conference. For each talk at the conference, this table should list the date, session start time, session title, room, speaker first name, and speaker last name. It should be sorted by date, then by session start time, then by session title, then by speaker last name. 2. Create a table containing the ID, name, date, and start time of each session, along with the number of speakers scheduled for the session. Sort the results by date (earliest to latest), and for sessions on the same date, sort from the largest number of speakers to the smallest. 3. Show the average capacity of rooms that either have a large screen or have the ability to serve refreshments (or both). The result of this query should be single cell For each session, show the title of the session and a single count of the number of speakers in the session whose expertise is either "Wellness" or "Counseling Center". If there are no such speakers in a session, make sure the session is shown anyway. 4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!