category inventory customer * category_id * inventory_id film_id store_id last_update * customer_id store_id first_name last_name + email address_id activebool name last_update film_category * film_id...


Assume there're n film categories. Let L = Min(L1, L2, .. Ln)  where Li = the length of the longest film in the ith category.


Please write a single SQL query that finds all films whose lengths are greater than L.


category<br>inventory<br>customer<br>* category_id<br>* inventory_id<br>film_id<br>store_id<br>last_update<br>* customer_id<br>store_id<br>first_name<br>last_name<br>+ email<br>address_id<br>activebool<br>name<br>last_update<br>film_category<br>* film_id<br>* category_id<br>last_update<br>create_date<br>last_update<br>active<br>rental<br>* rental_id<br>rental_date<br>inventory_id<br>customer_id<br>return_date<br>staff_id<br>last_update<br>address<br>film<br>* address_id<br>* film_id<br>title<br>address<br>address2<br>district<br>description<br>release_year<br>language_id<br>rental_duration<br>rental_rate<br>length<br>replacement_cost<br>rating<br>last_update<br>special_features<br>city_id<br>postal_code<br>phone<br>last_update<br>payment<br>* payment_id<br>customer_id<br>staff_id<br>rental_id<br>amount<br>payment_date<br>city<br>* city_id<br>city<br>country_id<br>last_update<br>fulltext<br>staff<br>* staff_id<br>first_name<br>last_name<br>address_id<br>email<br>language<br>store_id<br>* language_id<br>active<br>country<br>name<br>username<br>last_update<br>* country_id<br>password<br>last_update<br>picture<br>country<br>last_update<br>film_actor<br>´ actor_id<br>* film_id<br>last_update<br>actor<br>store<br>* store_id<br>manager_staff_id<br>address_id<br>last_update<br>* actor_id<br>王<br>first_name<br>last_name<br>last_update<br>

Extracted text: category inventory customer * category_id * inventory_id film_id store_id last_update * customer_id store_id first_name last_name + email address_id activebool name last_update film_category * film_id * category_id last_update create_date last_update active rental * rental_id rental_date inventory_id customer_id return_date staff_id last_update address film * address_id * film_id title address address2 district description release_year language_id rental_duration rental_rate length replacement_cost rating last_update special_features 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 fulltext staff * staff_id first_name last_name address_id email language store_id * language_id active country name username last_update * country_id password last_update picture country last_update film_actor ´ actor_id * film_id last_update actor store * store_id manager_staff_id address_id last_update * actor_id 王 first_name last_name last_update

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here