How many directors have multiple show times?
select count ( distinct t2.directed_by ) from schedule as t1 join film as t2 on t1.film_id = t2.film_id where t1.show_times_per_day>1
What are the names of the two directors who have multiple show times?
select distinct t2.directed_by from schedule as t1 join film as t2 on t1.film_id = t2.film_id where t1.show_times_per_day>1
How many show times does BIll Schreiner have
select sum ( t1.show_times_per_day ) from schedule as t1 join film as t2 on t1.film_id = t2.film_id where t2.directed_by = 'Bill Schreiner' group by t2.directed_by
How many show times does Jesus Salvador Trevino have?
select sum ( t1.show_times_per_day ) from schedule as t1 join film as t2 on t1.film_id = t2.film_id where t2.directed_by = 'Jesus salvador Treviño' group by t2.directed_by
Which show director has the largest number of show times in total?
select t2.directed_by from schedule as t1 join film as t2 on t1.film_id = t2.film_id group by t2.directed_by order by sum ( t1.show_times_per_day ) desc limit 1