Reference no: EM133055195
Question: Create queries for the following information requests:
List all staff that have been employed for more than 2 years.
List how many staff earn more than $30 per hour.
List a breakdown of movies by category. What is the most popular category?
List a breakdown of movies by the year in which they were released and their classification. Sort the list by year and classification.
The cinema company provides a day off on each staff member's birthday. List the number of lost working days in each month and show the trend over the year. Show the month name.
List the session period for each screening, where the periods are classified as
Midnight to 11AM - Morning, 11AM to 2PM - Midday, 2PM to 5PM - Afternoon, 5PM to 9PM - Evening, 9PM to Midnight - Late
Show the movie name, cinema number and seating capacity.
List the oldest and newest movie.
List the usage of all cinemas:
Which is the most used?
Which is the least used?
Which staff member has worked the hardest as a supervisor i.e. supervised most number of screenings?
Which staff members have been the operator for more than 3 screenings?
List the name and age of each staff member. Hint age is the difference between the current date and birth date. There are date functions that can assist you in performing these calculations.
List in separate columns the birth month using the full month name, birth day showing the full day name as well as the age.
List the staff showing whether they are currently employed or have resigned. Order the list by Name then by Employment Status as shown:
Order the list by Name then by Employment Status
The cinema company will be going international and will need to show screening times in a number of different formats to cater for different local time format preferences e.g. European, US, Australian, 12-hour, 24-hour etc. Sort the list by movie and start time.
Attachment:- Cinema_database.rar