Original query:

SELECT date_of_run, count(distinct hulu_title) as total_titles, tv_or_movie as number_movies, tv_or_movie as number_tv
FROM public.hulu_front group by date_of_run 
where tv_or_movie = 'movie' as number_movies and where tv_or_movie = 'tv' as number_tv 
;