예제 #1
0
    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);
    }