top_10_most_film_by_director.sql

CREATE OR REPLACE VIEW `tulisanmedium.digitalviews.top_10_most_film_by_director` 
OPTIONS(
  description="Top 5 most film by director for digital content purpose. requested by digital team"
)
AS
select 
  count(distinct title) number_of_films
  ,director
  ,string_agg(distinct title order by title limit 5) as films
from  
  `bigquery-public-data.san_francisco_film_locations.film_locations`  
group by
  director 
order by
  number_of_films desc
limit 
  10