\begin{frame}
  \frametitle{Aggregation Subqueries}
  
  \begin{code}{\textwidth}{Who has the best result for homework 1?}
    \small
    \BUseVerbatim{query}
  \end{code}
  \remark{%
    Remember: earlier we solved this using \sql{any}/\sql{all}.
  }
  \medskip
  
  \begin{goal}{}
    The aggregate in the subquery is guaranteed to yield exactly one row as required.
  \end{goal}
  
\end{frame}