71/224
\begin{frame}
  \frametitle{Not In}
  
  \begin{block}{}
    With 
    \begin{itemize}
      \item \sql{in} 
      \item \sql{not in} 
    \end{itemize}  
    it is possible to check whether an attribute value appears in a set of
    values computed by another SQL \emph{subquery.}
  \end{block}
  \medskip
  
  \begin{code}{\textwidth}{Students without any homework result}
    \small
    \BUseVerbatim{query}
  \end{code}
  \vspace{-1ex}
    
  \footnotesize\ttfamily\centering
  \colorbox{rellight}{%
    \begin{tabular}[t]{|r|r|}
      \multicolumn{2}{c}{Query Result} \\ \hline
      \hd{first} & \hd{last} \\ \hline
      Bart & Simpson \\ 
      George & Washington \\
      \hline
    \end{tabular}%
  }%
\end{frame}