35/289
\begin{frame}
  \frametitle{Joins}
  
  A \emph{join} needs to be explicitly specified in the \sql{WHERE} clause:
  \begin{tcenter}
    \begin{code}{.9\textwidth}{}
      \small\centering
      \BUseVerbatim{query}
    \end{code}
  \end{tcenter}
  \pause
  
  \begin{exampleblock}{}
    \begin{tcenter}
    \scalebox{.8}{
    \parbox[t]{0.55\linewidth}{
      \tablestudents
    }\quad
    \parbox[t]{0.45\linewidth}{%
      \tableresults
    }}
    \end{tcenter}
  \end{exampleblock}

  \begin{quiz}{\textwidth}{Output of this query?}
    \centering\small
    \BUseVerbatim{wrong}
  \end{quiz}
\end{frame}