Some questions can't be answered in one pass. "Which hive produced the most honey? " needs the maximum honey figure before it can find the hive that matches it.
Source: [Dev.to](https://dev.to/david_mwandairo_777f888b4/subqueries-and-ctes-asking-a-question-inside-a-question-3lpk)