Give the design view of the query in the ACCESS database for both quesations 8 and 10

exercise 1 is ..>>

8. For the movie theater database from Exercise 1, design a query that prompts for a movie title and return the movie schedule for that movie and the total number of tickets available per show. The query result for the movie "The Thing" is shown as follows. ShowTime Count Of TicketNo Capacity Available Tickets MovieID Title 2 The Thing 150 10:00:00 AM 148 1 2 The Thing 130 12:00:00 PM 2 The Thing 129 4:30:00 PM 130