SQLize Online / PHPize Online  /  SQLtest Online

select distinct a.actor_id as actor_id, a.first_name as first_name, a.last_name as last_name, count(fc.film_id) as film_count from actor as a inner join film_actor as fc on a.actor_id = fc.actor_id group by a.actor_id having count(fc.film_id) > (select count(t1.film_id) from film_actor as t1 inner join actor as t2 on t1.actor_id = t2.actor_id where concat(t2.first_name,' ',t2.last_name) = 'HENRY BERRY' group by t2.actor_id ) order by film_count asc; ; show status like 'Last_query_cost';