Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Refer to the film, actor, and film_actor tables of the Sakila database. The tables in this lab have the same columns and data types but

image text in transcribed

Refer to the film, actor, and film_actor tables of the Sakila database. The tables in this lab have the same columns and data types but fewer rows. Write a query that: - Computes the average length of all films that each actor appears in. - Rounds average length to the nearest minute and renames the result column 'average". - Displays last name, first name, and average, in that order, for each actor. - Sorts the result in descending order by average, then ascending order by last name. The query should exclude films with no actors and actors that do not appear in films. Hint Use the ROUNDO) and AVGO functions

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Database Technology Edbt 88 International Conference On Extending Database Technology Venice Italy March 14 18 1988 Proceedings Lncs 303

Authors: Joachim W. Schmidt ,Stefano Ceri ,Michele Missikoff

1988th Edition

3540190740, 978-3540190745

More Books

Students also viewed these Databases questions

Question

b. Determine the 95% confidence intervals for the parameters.

Answered: 1 week ago

Question

The models used to analyse different national cultures.

Answered: 1 week ago

Question

The nature of the issues associated with expatriate employment.

Answered: 1 week ago