a ; ; "laura.jpg"; "laura.jpg"; "a938e380e798d8cf0a7f5bb9305ea74a870e292e" . a ; ; "Employees"; "employees.csv"; "eec487aa3be31050014d897aa732262b6c9edc35" . a ; ; "steven.jpg"; "steven.jpg"; "97d5bd0f95a59e38564302c49a188041697e8fe2" . a ; "Select employees"; "PREFIX schema: \n\n SELECT DISTINCT ?employee\n WHERE\n { GRAPH ?doc\n { ?employee a schema:Person ;\n schema:familyName ?lastName\n OPTIONAL\n { ?employee schema:areaServed ?territory }\n OPTIONAL\n { ?employee schema:sponsor ?reportsToEmployee }\n FILTER NOT EXISTS { GRAPH ?supplierGraph\n { ?supplier a schema:Corporation ;\n schema:employee ?employee\n }\n }\n }\n }\n ORDER BY ?lastName" . a ; "
\n
\n

Sales performance

\n

Revenue booked per sales rep — the basis for recognising top performers and rebalancing\n territory assignments.

\n
\n
"^^ . a ; ; "andrew.jpg"; "andrew.jpg"; "85035ad6281696a74a3f060ddbc16bf5f31d10f1" . a ; ; "nancy.jpg"; "nancy.jpg"; "35fd362792e8c4bc3560a6de02f25ee551d68d02" . a ; "Employees"; ; "2026-09-29T23:29:45.319Z"^^; "2026-09-29T23:29:41.617Z"^^; ","; . a ; "Sales by employee"; ; "employeeName"; ; "totalSales" . a ; "Employee territories"; "PREFIX dct: \nPREFIX schema: \n\nCONSTRUCT\n{\n GRAPH ?graph\n {\n # the employee's title, exactly as employees.rq writes it (the CSV carries the last name for that\n # alone): the two imports run concurrently, and whichever reaches an employee's document first\n # creates it, which a document without a dct:title cannot be\n ?graph dct:title ?lastName .\n\n ?employee schema:areaServed ?territory\n }\n}\nWHERE\n{\n ?employee_territory <#employeeID> ?employeeID ;\n <#lastName> ?lastName ;\n <#territoryID> ?territoryID .\n\n BIND(uri(concat(str($base), \"employees/\")) AS ?container)\n BIND(uri(concat(str(?container), encode_for_uri(?employeeID), \"/\")) AS ?graph)\n BIND(uri(concat(str(?graph), \"#this\")) AS ?employee)\n BIND(uri(concat(str($base), \"territories/\", encode_for_uri(?territoryID), \"/#this\")) AS ?territory)\n}\n" . a ; "All employees"; ; . a ; ; "margaret.jpg"; "margaret.jpg"; "be8a7e398df569e2a0fe0071543e90eef30077ce" . a ; ; "Employee territories"; "employee_territories.csv"; "e92899742b1baf3a8ec9aed484690b6cc7795a52" . a ; "9"^^; "166"^^; . a ; "49"^^; "147"^^; . a ; ; ; ; ; "2026-09-29T23:29:11.851Z"^^; ; "2026-09-29T23:29:44.286Z"^^; "Employees"; ; . a ; ; "anne.jpg"; "anne.jpg"; "5d75b1f3af23c47f17630ffcc8e4f5f32883c086" . a ; ; "michael.jpg"; "michael.jpg"; "db4caa9067579e36a2ff973370763b862be32b4a" . a ; "Employee territories"; ; "2026-09-29T23:30:25.726Z"^^; "2026-09-29T23:29:44.445Z"^^; ","; . a ; "
\n
\n

The team

\n

Everyone on the Northwind payroll, who they report to and the territories they cover. Open a\n record to see the orders they booked.

\n
\n
"^^ . a ; ; "Sales by employee" . a ; ; "robert.jpg"; "robert.jpg"; "0040f22788c8513a2c622f67a0ab231cde61b96b" . a ; ; "employees.rq"; "employees.rq"; "65392261093a85c606dbadf5b3d04dafaf96e973" . a ; ; "All employees" . a ; "Employees"; "PREFIX foaf: \nPREFIX dct: \nPREFIX schema: \nPREFIX xsd: \nPREFIX geo: \n\nCONSTRUCT\n{\n GRAPH ?graph\n {\n ?graph dct:title ?lastName ;\n foaf:primaryTopic ?employee ;\n foaf:topic ?postalAddress .\n\n ?employee a schema:Person ;\n schema:identifier ?employeeID ;\n dct:title ?lastName ;\n dct:description ?title ;\n schema:givenName ?firstName ;\n schema:familyName ?lastName ;\n schema:jobTitle ?title ;\n schema:honorificPrefix ?titleOfCourtesy ;\n schema:birthDate ?birthDate;\n # ?hireDate\n schema:address ?postalAddress ;\n schema:telephone ?homePhone ;\n schema:telephone ?extension ;\n schema:description ?notes ;\n schema:sponsor ?reportsToEmployee ;\n geo:lat ?lat ;\n geo:long ?long ;\n foaf:img ?photo .\n\n ?postalAddress a schema:PostalAddress ;\n foaf:page ?graph ;\n schema:addressCountry ?country ;\n schema:addressLocality ?city ;\n schema:postalCode ?postalCode ;\n schema:streetAddress ?address ;\n schema:addressRegion ?region .\n }\n}\nWHERE\n{\n ?employee_row <#employeeID> ?employeeID ;\n <#lastName> ?lastName ;\n <#firstName> ?firstName ;\n <#title> ?title ;\n <#titleOfCourtesy> ?titleOfCourtesy ;\n <#birthDate> ?birthDateString ;\n <#hireDate> ?hireDateString ;\n <#address> ?address ;\n <#city> ?city ;\n <#postalCode> ?postalCode ;\n <#country> ?country ;\n <#homePhone> ?homePhone ;\n <#extension> ?extension ;\n <#photoHash> ?photoHash ;\n <#notes> ?notes ;\n <#lat> ?lat_string ;\n <#long> ?long_string .\n\n OPTIONAL {\n ?employee_row <#region> ?region\n }\n OPTIONAL {\n ?employee_row <#reportsTo> ?reportsTo\n BIND(uri(concat(str($base), \"employees/\", encode_for_uri(?reportsTo), \"/#this\")) AS ?reportsToEmployee) # cannot use ?container since it's undefined in the OPTIONAL scope\n }\n\n BIND(uri(concat(str($base), \"employees/\")) AS ?container)\n BIND(uri(concat(str(?container), encode_for_uri(?employeeID), \"/\")) AS ?graph)\n BIND(uri(concat(str(?graph), \"#this\")) AS ?employee)\n BIND(uri(concat(str(?graph), \"#address\")) AS ?postalAddress)\n BIND(xsd:float(?lat_string) AS ?lat)\n BIND(xsd:float(?long_string) AS ?long)\n BIND(strdt(substr(?birthDateString, 1, 10), xsd:date) AS ?birthDate)\n BIND(strdt(substr(?hireDateString, 1, 10), xsd:date) AS ?hireDate)\n BIND(uri(concat(str($base), \"uploads/\", encode_for_uri(?photoHash))) AS ?photo)\n}\n" . a ; ; "employee_territories.rq"; "employee_territories.rq"; "a42cb3f2eabdea1ba69e88639778af22e6493008" . a ; ; "janet.jpg"; "janet.jpg"; "0978d23da4dad02afa585b127870c566836294ca" . a ; "Sales by employee"; "PREFIX schema: \n\nSELECT ?employeeName (SUM(?sale) AS ?totalSales)\nWHERE {\n GRAPH ?orderGraph {\n ?order schema:broker ?employee ;\n schema:orderedItem ?orderItem .\n ?orderItem schema:price ?sale .\n }\n GRAPH ?employeeGraph {\n ?employee schema:givenName ?givenName ;\n schema:familyName ?familyName .\n BIND(CONCAT(?givenName, \" \", ?familyName) AS ?employeeName)\n }\n}\nGROUP BY ?employee ?employeeName\nORDER BY DESC(?totalSales)" .