163/224
\begin{frame}
  \frametitle{Having}

  \structureAll
  \medskip
  
  \begin{code}{\textwidth}{Which Students got at least 18 homework points?}
    \small
    \pause
    \BUseVerbatim{query}
  
    \medskip
    \begin{tcenter}
    \colorbox{rellight}{%
      \ttfamily\footnotesize
      \begin{tabular}{|r|r|}
        \hline
        \hd{first} & \hd{last} 
        \\
        \hline
        George & Orwell \\
        Elvis & Presley \\
        \hline      
      \end{tabular}%
    }
    \end{tcenter}
  \end{code}
  \pause
  
  \begin{goal}{}
    \begin{itemize}
      \item The \sql{where} clause refers to single tuples.
      \item The \sql{having} clause applies to entire groups.
    \end{itemize}
  \end{goal}
\end{frame}