PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?programme ?assYear ?progTitle
(COUNT(DISTINCT ?student) AS ?noStudents)
(SUM(?score) AS ?assTotalScore)
(MIN(?score) AS ?assMinScore)
(MAX(?score) AS ?assMaxScore)
(COUNT(DISTINCT ?currStudAss) AS ?totalNumAss)
(AVG(?score) AS ?assAvgScore)
            WHERE {
                ?student a <prefix/vocab/Student> .
                ?student <prefix/vocab/studentRecord> ?sr.
                ?sr <prefix/vocab/fileYear> '2000'.
                ?sr <prefix/vocab/assessmentRecord> ?ar.
                ?ar <prefixhttp://data.latize.com/vocab/assessment> ?currStudAss.
                ?currStudAss <prefix/vocab/date>  ?assDate.
                ?currStudAss <prefix/vocab/programme> ?programme.
                ?currStudAss <prefix/vocab/score> ?score.
                ?programme <prefix/vocab/progTitle> ?progTitle.
                {
                    SELECT DISTINCT ?programme ?level
                    WHERE {
                      <student2000> <prefix/vocab/studentRecord> ?sr.
                      ?sr <prefix/vocab/fileYear> '2000'.
                      ?sr <prefix/vocab/levelHouseTutorGroup> ?lHTG
                      ?sr <prefix/vocab/assessmentRecord> ?ar.
                      ?ar <prefix/vocab/assessment> ?ass.
                      ?ass <prefix/vocab/programme> ?programme.
                      ?programme rdfs:label ?progTitle.
                      BIND( SUBSTR( ?lHTG, 1, 1 ) AS ?level )
                    }
                }
                BIND (YEAR(?assDate) AS ?assYear)
            } GROUP BY ?programme ?assYear ?progTitle