\begin{frame}
  \frametitle{Unnecessary Joins}
  
  \begin{alertblock}{}
    Do not join \emph{more} tables than needed.\\
    \remark{Query will run slowly if the optimizer overlooks the redundancy.}
  \end{alertblock}
  \smallskip
  \pause
  
  \structureAll
  \smallskip
  
  \begin{code}{\textwidth}{Results for homework 1}
    \small
    \BUseVerbatim{query}
  \end{code}%
  \medskip
  \pause
    
  \begin{quiz}{\textwidth}{\raggedright Will the following query produce the same Results?}
    \small
    \BUseVerbatim{nojoin}
  \end{quiz}
  %% Yes
\end{frame}