######### LUBM MV4
PREFIX lubm: <http://lubm.org/#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
SELECT ?profdept ?udp (SUM(?coCount) AS ?prCount)
FROM <http://lubm.org/data/>
FROM NAMED <http://lubm.org/mv5/>
WHERE{
	GRAPH <http://lubm.org/mv5/> {
		?id a qb:Observation ; 
			qb:dataSet lubm:dataset-aggview_5 ; 
			lubm:teacherdept ?profdept ; 
			lubm:coursetype ?cotype ;  
			lubm:coursecount ?coCount .
	}
	
	?profdept rdf:type lubm:Department ;
		lubm:subOrganizationOf ?udp .
	?udp rdf:type lubm:University .
	FILTER(?cotype = lubm:GraduateCourse)
}
GROUP BY ?profdept ?udp