PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT (COUNT(?X) as ?MasterTheses) WHERE { ?X rdf:type bb:Master_Thesis } PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT (COUNT(?X) as ?MasterThesesWithMention) WHERE { ?X rdf:type bb:Master_Thesis . ?Y rdf:type bb:Mention . ?Y bb:mentionGivenTo ?X } PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT (COUNT(?X) as ?studentsWithBachelorDegree) WHERE { ?X rdf:type bb:Student . ?X bb:endsBachelorStudiesOn ?end . Filter (xsd:dateTime(?end) < NOW()) } PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT (COUNT(?Y) as ?studentsEnrolledAtMaster) WHERE { ?Y rdf:type bb:Student . ?Y bb:enrolledForMasterStudiesOn ?start . Filter (xsd:dateTime(?start) < NOW()) } PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT (SUM(?credits) as ?ECTSCredits) WHERE { ?X rdf:type bb:Student . ?Y rdf:type bb:Evaluation . ?Z rdf:type bb:Teaching_Unit . ?X bb:hasFamilyName "Department0StudentFamilyName0"^^ . ?X bb:hasFirstName "Department0StudentFirstName0"^^ . ?Y bb:performedByStudent ?X . ?Y bb:evaluatesTeachingUnit ?Z . ?Y bb:hasMark ?M . ?Z bb:hasNumberOfECTS ?credits } PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT ?S WHERE{ ?S rdf:type bb:Student . ?S bb:hasFamilyName ?ln FILTER (regex(?ln, "^D")) } PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT ?P1 ?O1 ?P2 ?O2 WHERE { ?S rdf:type bb:Student . ?S bb:hasFamilyName "Department0StudentFamilyName0"^^ . ?S bb:hasFirstName "Department0StudentFirstName0"^^ . ?S ?P1 ?O1 . ?O1 ?P2 ?O2 } PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT DISTINCT ?X (count(?E) as ?FailuresForTeachingUnit) WHERE { ?X rdf:type bb:Teaching_Unit . ?E rdf:type bb:Evaluation . ?E bb:evaluatesTeachingUnit ?X . ?E bb:hasMark ?Y . FILTER (?Y < 3) } GROUP BY ?X PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT ?X (count(?E) as ?EvaluationsForTeachingUnit) WHERE { ?X rdf:type bb:Teaching_Unit . ?E rdf:type bb:Evaluation . ?E bb:evaluatesTeachingUnit ?X } GROUP BY ?X PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT ?X (COUNT(?Y) as ?numOfThesisSupervised) WHERE { ?X rdf:type bb:Professor . ?Y rdf:type ?tType . ?Y bb:supervisedBy ?X . FILTER REGEX (?tType, 'Thesis', 'i') } ORDER BY DESC(?numOfThesisSupervised) LIMIT 1 PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT ?X (AVG(?M) as ?avgMark) WHERE { ?X rdf:type bb:Student . ?Y rdf:type bb:Evaluation . ?T rdf:type bb:Study_Track . ?S rdf:type bb:Semester . ?T bb:hasName "Department6Study_Track0"^^ . ?S bb:hasName "Semester0"^^ . ?X bb:isInStudyTrack ?T. ?Y bb:isForSemester ?S . ?Y bb:performedByStudent ?X . ?Y bb:hasMark ?M } GROUP BY ?X ORDER BY DESC(?avgMark) LIMIT 5 PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT ?T (AVG(year(xsd:dateTime(?end))-year(xsd:dateTime(?start))) as ?CompletionTime) WHERE { ?T rdf:type bb:Study_Track . ?X rdf:type bb:Student . ?X bb:enrolledForBachelorStudiesOn ?start . ?X bb:endsBachelorStudiesOn ?end . ?X bb:isInStudyTrack ?T } GROUP BY ?T PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT (AVG(?mark) as ?AverageSemester1) WHERE { ?X rdf:type bb:Evaluation . ?Y rdf:type bb:Teaching_Unit . ?Z rdf:type bb:Semester . ?X bb:evaluatesTeachingUnit ?Y . ?X bb:isForSemester ?Z . ?Z bb:hasName "Semester1"^^ . ?X bb:hasMark ?mark } PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT ?FamName ?FirstName WHERE { ?X rdf:type bb:Student . ?Y rdf:type bb:Professor . ?Z rdf:type bb:Evaluation . ?D rdf:type bb:Department . ?Z bb:performedByStudent ?X . ?Z bb:evaluatedByProfessor ?Y . ?Y bb:isAffiliatedWithDepartment ?D . ?X bb:hasFamilyName ?FamName . ?X bb:hasFirstName ?FirstName . ?D bb:hasName "Department0"^^ } PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT ?X WHERE{ ?X rdf:type bb:Teaching_Unit . ?X bb:isTaughtInLang "EN"^^ . ?X bb:hasName "Department0Teaching_Unit0"^^ } PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT (COUNT(?X) as ?BachelorStudentsSemester0) WHERE { ?X rdf:type bb:Student . ?S rdf:type bb:Semester . ?S bb:hasName "Semester0"^^ . ?S bb:beginsOnDate ?start . ?S bb:endsOnDate ?end . ?X bb:enrolledForBachelorStudiesOn ?Y . FILTER (xsd:dateTime(?Y) <= xsd:dateTime(?end) && xsd:dateTime(?Y) >= xsd:dateTime(?start)) } PREFIX rdf: PREFIX bb: PREFIX xsd: SELECT (COUNT(?X) as ?MasterStudentsSemester0) WHERE { ?X rdf:type bb:Student . ?S rdf:type bb:Semester . ?S bb:hasName "Semester0"^^ . ?S bb:beginsOnDate ?start . ?S bb:endsOnDate ?end . ?X bb:enrolledForMasterStudiesOn ?Y . FILTER (xsd:dateTime(?Y) <= xsd:dateTime(?end) && xsd:dateTime(?Y) >= xsd:dateTime(?start)) }