\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}