\begin{table}[hbt]
\caption{Query instances}
\begin{center}
\begin{tabular}{|c|l l|}
\hline
    \textbf{Task} & \multicolumn{2}{|l|}{\textbf{Query}}\\
     \hline
     \hline
   \multicolumn{3}{|c|}{\textbf{\textit{Data retrieval}}}\\
   \hline
    \multirow{3}{*}{\#1} & Q1a & Retrieve documents written in \textit{French} \\
            % \hline
            & Q1b & Retrieve documents written in \textit{English} and edited in \textit{December} \\
            %\hline
           & Q1c  & Retrieve documents whose domains are \textit{math} or \textit{info}, 
             written in \textit{English} \\&& and edited in \textit{2010}, \textit{2012} or \textit{2014} \\
    \hline
     \multirow{2}{*}{\#2} & Q2a & Retrieve data files (documents or tables) containing the term \textit{university} \\
        & Q2b & Retrieve data files containing the terms \textit{university}, \textit{science} or \textit{research}\\
     \hline
     \multirow{2}{*}{\#3} & Q3a & Retrieve the top 5 documents similar to any given document \\
         & Q3b & Retrieve 5 tables joinable to table $t\_dc9442ed0b52d69c\_\_\_\_c11\_1\_\_\_\_1$\\ 
     \hline
    \hline
   \multicolumn{3}{|c|}{\textbf{\textit{ Textual Document Analysis/Aggregation}}}\\
     \hline
   \multirow{2}{*}{\#4} & Q4a & Calculate documents scores w.r.t. the terms \textit{university} and \textit{science}   \\
        & Q4b & Calculate documents scores w.r.t. the terms \textit{university}, \textit{research}, \\
        & & \textit{new} and \textit{solution}\\
    \hline
   \multirow{2}{*}{\#5} & Q5a & Retrieve documents concordance w.r.t. the terms \textit{university} and \textit{science}   \\
        & Q5b & Retrieve documents concordance w.r.t. the terms \textit{university}, \textit{science} \\
        & & \textit{new} and \textit{solution} \\
     \hline
      \multirow{1}{*}{\#6} & Q6a  & Find top 10 keywords from all documents (stopwords excluded) \\
     \hline
     \multirow{2}{*}{\#7} & Q7a & Run a PCA with documents merged by \textit{domains}   \\
        & Q7b & Run a 3-cluster KMeans clustering with documents merged by \textit{domains} \\
     \hline
     \hline
   \multicolumn{3}{|c|}{\textbf{\textit{Tabular Data Analysis/Queries}}}\\
     \hline
     \multirow{2}{*}{\#8} & Q8a & Retrieve all tuples from table $t\_e9efd5cda78af711\_\_\_\_c11\_1\_\_\_\_1$    \\
        & Q8b & Retrieve tuples from table $t\_e9efd5cda78af711\_\_\_\_c11\_1\_\_\_\_1$ \\
        & & whose column \textit{PROVINCE} bears the value \textit{BC} \\
     \hline
     \multirow{2}{*}{\#9} & Q9a & Calculate the average of columns \textit{Unnamed: 12}, \textit{13}, and \textit{20} \\  & & from table  $t\_356fc1eaad97f93b\_\_\_\_c15\_1\_\_\_\_1$ grouped by \textit{Unnamed: 2}   \\
        & Q9b & Run a left join query between tables $PED\_SK\_DTL\_SNF\_\_\_\_c7\_0\_\_\_\_1$ \\
        & & and $t\_285b3bcd52ec0c86\_\_\_\_c13\_1\_\_\_\_1$ w.r.t. columns named \textit{SOILTYPE} \\
     \hline
     \multirow{2}{*}{\#10} & Q10a & Run a PCA on the result of query \textit{Q9a}   \\
        & Q10b & Run a 3-cluster KMeans clustering on the result of query \textit{Q9a} \\
     \hline
\end{tabular}
\end{center}
\label{tab:query.instances}
\end{table}
Task Query
Data retrieval
#1 Q1a Retrieve documents written in French
Q1b Retrieve documents written in English and edited in December
Q1c Retrieve documents whose domains are math or info, written in English
and edited in 2010, 2012 or 2014
#2 Q2a Retrieve data files (documents or tables) containing the term university
Q2b Retrieve data files containing the terms university, science or research
#3 Q3a Retrieve the top 5 documents similar to any given document
Q3b Retrieve 5 tables joinable to table t dc9442ed0b52d69c c11 1 1
Textual Document Analysis/Aggregation
#4 Q4a Calculate documents scores w.r.t. the terms university and science
Q4b Calculate documents scores w.r.t. the terms university, research,
new and solution
#5 Q5a Retrieve documents concordance w.r.t. the terms university and science
Q5b Retrieve documents concordance w.r.t. the terms university, science
new and solution
#6 Q6a Find top 10 keywords from all documents (stopwords excluded)
#7 Q7a Run a PCA with documents merged by domains
Q7b Run a 3-cluster KMeans clustering with documents merged by domains
Tabular Data Analysis/Queries
#8 Q8a Retrieve all tuples from table t e9efd5cda78af711 c11 1 1
Q8b Retrieve tuples from table t e9efd5cda78af711 c11 1 1
whose column PROVINCE bears the value BC
#9 Q9a Calculate the average of columns Unnamed: 12, 13, and 20
from table t 356fc1eaad97f93b c15 1 1 grouped by Unnamed: 2
Q9b Run a left join query between tables PED SK DTL SNF c7 0 1
and t 285b3bcd52ec0c86 c13 1 1 w.r.t. columns named SOILTYPE
#10 Q10a Run a PCA on the result of query Q9a
Q10b Run a 3-cluster KMeans clustering on the result of query Q9a