For each of the following questions write a SQL query:

What is the average length of films in each category? List the results in alphabetic order of categories.

Which categories have the longest and shortest average film lengths?

Which customers have rented action but not comedy or classic movies?

Which actor has appeared in the most English-language movies?

How many distinct movies were rented for exactly 10 days from the store where Mike works?

Alphabetically list actors who appeared in the movie with the largest cast of actors.

the question is complete

EMIE actor country country_id country IFK) Foreign vey tuinige constraint rental rental id rental.date inventory.id customer id return, date staff.id tu, FI CU, FI IFK address.id (PK) loustons customer_id store.id First name lastane (PR) CFKI inventory inventory.id Filmid store,id [PKI (F) PO (PK1 district city.id postal code (FKI addressid active staff.id First name laste addressid langue language_id [PK cila cal store.id active usernme password category.id (PX) filmid title description celease language.id pant pament id customer id statt.id rental id [PK X city store.id CPI payment date city.id city country_id FRO address id EFKI rental_duration rental rate length replacement cost rating special features Film category Filmid category.id CPK, FK PK, FK) Fictor actor_id inid (PK, FK [PK, FK