public DataTable GetAllSubjectsMeans()
{
string query = "SELECT ET.Email, AVG(ET.HReales) as MediaHReales, TG.CodAsig " +
"FROM EstudiantesTareas ET " +
"JOIN TareasGenericas TG " +
"ON ET.CodTarea = TG.Codigo " +
"GROUP BY ET.Email, TG.CodAsig";
DataTable dataTable = dataAccess.CreateQueryDataTable(query);
dataTable.TableName = "SubjectsMeans";
return(dataTable);
}
