Question: USE sakila; SELECT last _ name, first _ name, ROUND ( AVG ( length ) , 0 ) AS average FROM actor INNER JOIN film

USE sakila;
SELECT last_name, first_name, ROUND(AVG(length),0) AS average
FROM actor
INNER JOIN film_actor ON film_actor.actor_id = actor.actor_id
INNER JOIN film ON film_actor.film_id = film.film_id
WHERE title = "ALONE TRIP"
GROUP BY last_name, first_name
ORDER BY average;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

USE sakila; SELECT last _ name, first _ name, ROUND ( AVG ( length ) , 0 ) AS average FROM actor INNER JOIN film _ actor ON film _ actor.actor _ id = actor . actor _ id INNER JOIN film ON film _...

Q:

USE sakila; SELECT last _ name, first _ name, ROUND ( AVG ( length ) , 0 ) AS average FROM actor INNER JOIN film _ actor ON film _ actor.actor _ id = actor . actor _ id INNER JOIN film ON film _...

Q:

USE sakila; SELECT last _ name, first _ name, ROUND ( AVG ( length ) , 0 ) AS average FROM actor INNER JOIN film _ actor ON film _ actor.actor _ id = actor . actor _ id INNER JOIN film ON film _...

Q:

USE sakila; SELECT last _ name, first _ name, ROUND ( AVG ( length ) , 0 ) AS average FROM actor INNER JOIN film _ actor ON film _ actor.actor _ id = actor . actor _ id INNER JOIN film ON film _...

Q:

3 . 1 0 LAB - Multiple joins with aggregate ( Sakila ) types but fewer rows. The tables are initialized with LOAD rather than INSERT, statements. The LOAD statements read data from. csy files. In...

Q:

1.11 LAB - Query execution plans (Sakila) This lab illustrates how minor changes in a query may have a significant impact on the execution plan. MySQL Workbench exercise Refer to the film, actor, and...

Q:

Multiple joins with aggregate ( Sakila ) 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. The...

Q:

1.11 LAB - Query execution plans (Sakila) This lab illustrates how minor changes in a query may have a significant impact on the execution plan. MySQL Workbench exercise Refer to the film, actor, and...

Q:

MySQL Workbench exercise Refer to the film, actor, and film_actor tables of the Sakila database. This exercise is based on the initial Sakila installation. If you have altered these tables or their...

Q:

This lab illustrates how minor changes in a query may have a significant impact on the execution plan. The lab consists of a MySQL Workbench exercise followed by a zyLab exercise. The MySQL Workbench...

Q:

The following table gives information on the limited tread warranties (in thousands of miles) and the prices of 12 randomly selected tires at a national tire retailer as of July 2009 Pressure (psi)...

Q:

Jill Parsons purchases for $72,000 Jamar's interest in the Tholen-Jamar partnership. Assuming that Jamar has a $68,000 capital balance in the partnership, what journal entry is made by the...

Q:

Why might an accounting-based control system provide headquarters management with biased information about the performance of a foreign subsidiary? How can these biases best be corrected?

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

d. Describe any challenges in trying to communicate. If there were no challenges, explain why you think it was so easy.

Q:

f. Did they change their names? For what reasons?

Q:

2. Describe three approaches to the study of intercultural communication.