######### SSB Q7 over MatView #2 PREFIX qb: PREFIX skos: PREFIX ssb: SELECT ?c_nation ?s_nation ?Year (SUM(?revenue) AS ?lo_revenue) FROM FROM FROM FROM FROM NAMED WHERE { GRAPH { ?li a qb:Observation ; qb:dataSet ; ssb:date_month ?month ; ssb:customer_customer ?customer ; ssb:supplier_nation ?s_nation ; ssb:revenue ?revenue . } ?customer skos:broader ?c_city . ?c_city skos:broader ?c_nation . ?c_nation skos:broader ?c_region . ?c_region ssb:region_name ?c_reg_name . ?s_nation skos:broader ?s_region . ?s_region ssb:region_name ?s_reg_name . ?Month skos:broader ?Year . FILTER(?s_reg_name = 'ASIA') FILTER(?c_reg_name = 'ASIA') } GROUP BY ?c_nation ?s_nation ?Year ORDER BY ?Year DESC(?lo_revenue)