144/224
\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}