SELECT
actor_name,
MAX(movie_count) AS max_movie_count,
MIN(movie_count) AS min_movie_count
FROM
(SELECT
actors.actor_name,
COUNT(movies.movie_id) AS movie_count
FROM
actors
INNER JOIN movie_actors ON actors.actor_id = movie_actors.actor_id
INNER JOIN movies ON movie_actors.movie_id = movies.movie_id
WHERE
movies.year BETWEEN 1991 AND 2001
GROUP BY
actors.actor_name) AS actor_movie_count
GROUP BY
actor_name;
说明: 该查询语句首先使用内部连接(INNER JOIN)将演员、电影演员关系和电影数据集合在一起,并进行筛选(WHERE)以限制只考虑1991年至2001年之间的电影。接着利用聚合函数COUNT统计每位演员参演的电影数量,并按演员名分组(GROUP BY)。最后,再次进行分组,并分别使用聚合函数MAX和MIN计算每位演员参演电影数量的最大值和最小值。