\begin{frame}
  \frametitle{Aggregation Subqueries in Select}

  \begin{goal}{}
    Aggregation subqueries may be used in the \sql{select} clause.
  \end{goal}
  \remark{%
    This sometimes can be used to replace \sql{group by}.
  }
  \bigskip
    
  \begin{code}{\textwidth}{The homework points of the individual Students.}
    \small
    \BUseVerbatim{query}
  \end{code}
\end{frame}