Posted by swetha, Dec. 11, 2023, 9:56 p.m.

question 41

hi leon, i am working on question 41 and not sure why my results is not matching with expected output

i am using this code


with cte1 as (
select actor_id,count( film_id) as film_cnt
from film_actor
group by actor_id
order by count(film_id) desc
cte2 as(
select *,
case when film_cnt>=30 then 'Productive'
else 'less-productive'
end as actor_cat
from cte1
  select actor_cat,count(*)
  from cte2
  group by actor_cat



SQLPad user: Leon Wei

- Leon (934)

Dec. 16, 2023, 12:38 p.m.