56/289
\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}
  \medskip
  \pause
  
  \myexample
  \smallskip
  
  \begin{code}{\textwidth}{Results for homework 1}
    \small\centering
    \BUseVerbatim{query}
  \end{code}%
  \smallskip
  
  \begin{quiz}{\textwidth}{\raggedright Will the following query produce the same results?}
    \small\centering
    \BUseVerbatim{nojoin}
  \end{quiz}
  %% Yes
\end{frame}