\begin{frame}
\frametitle{Simple Aggregations}
\structureAll
\begin{code}{\textwidth}{How many Students have submitted a homework?}
\pause
{
\small
\BUseVerbatim{howmany}
}
\begin{center}
\colorbox{rellight}{%
\footnotesize\centering\ttfamily
\begin{tabular}{|r|}
\hline
\hd{count(distinct sid)}
\\
3
\\
\hline
\end{tabular}%
}
\end{center}
\end{code}
\pause\vspace{-1.75ex}
\begin{code}{\textwidth}{What is the total number of points student 101 got for her homeworks?}
\pause
{
\small
\BUseVerbatim{total}
}
\begin{center}
\colorbox{rellight}{%
\footnotesize\centering\ttfamily
\begin{tabular}{|r|}
\hline
\hd{total points}
\\
18
\\
\hline
\end{tabular}%
}
\end{center}
\end{code}
\end{frame}