Category variable name
month
Chart type
LineChart
Query
Sales by month
Series variable name
revenue
Title
Monthly sales trend
30 March 2026 22:43

Knowledge Graph representation of the Northwind Traders sample database

_1
page-header
_2
overview-intro
_3
Monthly sales trend
_4
Revenue by country
_5
top-selling-products
_6
top-manager-header
_7
top-manager
_8
navigation-prompt
_9
select-children
Date Modified
30 March 2026 22:43
Description
Knowledge Graph representation of the Northwind Traders sample database
Title
Northwind Traders
Category variable name
country
Chart type
BarChart
Query
Revenue by country
Series variable name
revenue
Title
Revenue by country

Revenue by country

Text
PREFIX schema: <https://schema.org/>

SELECT ?country (SUM(?sale) AS ?revenue)
WHERE {
    GRAPH ?orderGraph {
        ?order schema:orderedItem ?orderItem ;
               schema:orderDelivery ?delivery .
        ?orderItem schema:orderQuantity ?quantity ;
                   schema:price ?price .
        ?delivery schema:deliveryAddress ?address .
        ?address schema:addressCountry ?country .
        BIND(?quantity * ?price AS ?sale)
    }
}
GROUP BY ?country
ORDER BY DESC(?revenue)
LIMIT 10
Title
Revenue by country

Sales by month

Text
PREFIX schema: <https://schema.org/>

SELECT ?month (SUM(?sale) AS ?revenue)
WHERE {
    GRAPH ?orderGraph {
        ?order a schema:Order ;
               schema:orderDate ?orderDate ;
               schema:orderedItem ?orderItem .
        ?orderItem schema:orderQuantity ?quantity ;
                   schema:price ?price .
        BIND(?quantity * ?price AS ?sale)
        BIND(SUBSTR(STR(?orderDate), 1, 7) AS ?month)
    }
}
GROUP BY ?month
ORDER BY ?month
Title
Sales by month