Question

List the name of the production companies that have at least one movie with gross higher than average. Each production company name should appear only once, even if they have multiple movies with

Answer 1

To identify production companies with movies grossing higher than average, calculate the average gross of all movies and compare each movie's gross to the average.

Step-by-step explanation:

To list the name of the production companies that have at least one movie with a gross higher than the average, you would need to calculate the average gross of all movies first. Then, you would compare the gross of each movie to the average and identify the production companies associated with the movies that have a higher gross. Here is a step-by-step explanation:

1. Calculate the average gross of all movies.
2. For each movie, compare its gross to the average gross.
3. If a movie's gross is higher than the average, note the production company associated with that movie.
4. Make sure to only include each production company name once, even if they have multiple movies with a higher gross.

By following this process, you will obtain a list of the production companies that have at least one movie with a gross higher than the average.