1. Consider the Sakila Database :

category category_id name last_update + inventory inventory_id film_id store_id last_update + customer customer_id store_id first_name last_name email address_id activebool create_date last_update active film_category "category_id last_update rental rental_id rental date inventory_id customer_id return_date Her staff_id last_update ++ + film film_id title description release_year language_id rental_duration rental_rate length replacement_cost rating last update special_features fulltext address address_id address address2 district city_id postal code phone last_update payment payment_id customer_id staff_id rental_id amount payment date city city_id city country_id last_update language "language_id name last_update staff staff_id first_name last_name address_id email store_id active username password last_update picture country * country_id country last_update film_actor actor_id film_id last_update HO + actor actor_id first name last_name last_update store store_id manager_staff_id address_id last_update and the query : List each film and the number of actors who are listed for that film. SELECT film.title, film_actor.film_id, COUNT(film_actor.actor_id) FROM film_actor INNER JOIN film ON film_actor.film_id = film.film_id GROUP BY film.film_id; a) Consider OLAP(no joins, only aggregations) queries in SQL. Make the same query using the SYNTAX : "TRANSFORM ... SELECT ... PIVOT