I need to create a query that shows this below. Need to have a screenshot of the design view of the query.

4. For the movie theater database from Exercise 1, create a query that prompts for a date and return the movie show schedule for the selected date and the total number of tickets per show as follows.

These are the Relational Model and ER Model of the database.

This is what I have in Access

This is the data I have in Access for tables Movie, Show and ShowRoom. As this was from a previous question in the book.

ShowDay MovielD Title ShowTime TicketsSold CapacityAvailableTickets 1/2/2011 11/2/2011 11/2/2011 11/2/2011 1/2/2011 119 3 The Three Musketeers 3 The Three Musketeers 6 Paranormal Activity 3 6 Paranormal Activity 3 7 The Descendants 5:30:00 PM 7:30:00 PM 7:30:00 PM 10:00:00 PM 4:00:00 PM 120 120 130 130 100 129 129