download the file conference.mdb, which describes the sessions and speakers at a conference. Write SQL queries for the following:

(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)

find the cost of your paper

Give a flannel board presentation.

Give a flannel board presentation. 1. Set up area with board. 2. Check pieces. 3. Practice. 4. Place pieces in order of appearance. 5. Gather children. 6. Place pieces out….

What is a dramatic play kit?

Answer the following questions related to speaking goals. 1. How can the goals of a program be met? 2. When children are interested in an object or event, what should….

Write down teacher questions that could lead a child to a discovery and promote the child’s verbal expression of the discovery in the following situations. 1. A bird’s nest is….