\begin{frame}
  \frametitle{Where vs. Having}

  \begin{goal}{}
    The \sql{having} clause should not contain direct attribute references, only aggregation functions.
  \end{goal}
  
  \begin{alertblock}{This is wrong}
    {\footnotesize\BUseVerbatim{where}}
  \end{alertblock}
  \pause\smallskip
  
  \begin{code}{\textwidth}{This is correct}
    {\footnotesize\BUseVerbatim{having}}
  \end{code}
\end{frame}

\theme{Aggregation Subqueries}