\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} % \overview{3} \theme{Aggregation Functions}