What is the average ranking episodes that are nominated for an award?
average ranking = divide(sum(rating), sum(episode_id))
SELECT SUM(T1.rating) / COUNT(T1.episode) FROM Episode AS T1 INNER JOIN Award AS T2 ON T1.episode_id = T2.episode_id