\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}