\begin{frame} \frametitle{Maximizing Aggregations} \begin{code}{\textwidth}{View: total number of homework points for each student.} \small \BUseVerbatim{view} \end{code} \bigskip \begin{code}{\textwidth}{Alternative formulation of query on previous slide.} \small \BUseVerbatim{query} \end{code} \end{frame} \theme{Union \& Case \& Coalesce}