Subqueries and CTEs: Asking a Question Inside a Question

Some questions can't be answered in one pass. "Which hive produced the most honey?" needs the maximum...