Database: bbc_channels
Question: Find the number of programs for each channel. Return the name of each channel as well.
SQL:
SELECT t1.name ,  count(*) FROM channel AS t1 JOIN program AS t2 ON t1.channel_id  =  t2.channel_id GROUP BY t1.channel_id