133/224
\begin{frame}
  \frametitle{Subqueries under From}

  \begin{block}{}
    A \emph{view declaration} registers a \emph{query (not a query result)} 
    under a given identifier in the database.
  \end{block}
  \bigskip
    \pause

  \begin{code}{\textwidth}{View: homework points}
    \small
    \BUseVerbatim{view}
  \end{code}
  \pause\vspace{0ex}

  In queries, views may be used like stored tables:
  \begin{code}{\textwidth}{}
    \small
    \BUseVerbatim{query}
  \end{code}
  \vspace{0ex}
  
  Views may be thought of as \emph{subquery macros}
\end{frame}