GRZ-eco-wage.md

Garzoni economy: about wage policy

Salary progressive vs. non-progressive, and in which professions (ok)

SELECT COUNT (distinct ?salNonProg) AS ?NonProgressive COUNT (distinct ?salProg) as ?Progressive
WHERE 
{
  ?salProg a grz-owl:Salary .
  ?salProg grz-owl:progressive 1 .
  ?salNonProg a grz-owl:Salary .
  ?salNonProg grz-owl:progressive 0 .
}

Salary in good vs. in money (ok)

SELECT COUNT (distinct ?salMoney) AS ?InMoney COUNT (distinct ?salGood) as ?InGood
WHERE 
{
  ?salGood a grz-owl:Salary .
  ?salGood grz-owl:inGoods 1 .
  ?salMoney a grz-owl:Salary .
  ?salMoney grz-owl:inGoods 0 .
}

Who pays the salary? (ok)

SELECT  ?payer COUNT (distinct ?sal) 
WHERE 
{
  ?sal a grz-owl:Salary .
  ?sal grz-owl:paidBy ?payer .
}
GROUP BY (?payer)

In which profession the salary is payed by the apprentice? (ok)

SELECT  ?profSF COUNT (distinct ?sal) 
WHERE 
{
  ?c grz-owl:reports ?finCond .
  ?finCond grz-owl:hasConditionComponent ?sal .
  ?sal a grz-owl:Salary .
  ?sal grz-owl:paidBy "Apprentice".
  ?c grz-owl:introduces ?master .
  ?master grz-owl:role/grz-owl:roleType grz-owl:master .
  ?master grz-owl:profession/grz-owl:standardForm  ?profSF .
}
GROUP BY (?profSF)
ORDER BY DESC (COUNT (distinct ?sal) )

How many contracts have which type of financial conditions? (ok)

SELECT  ?type COUNT (distinct ?c) 
WHERE 
{
  ?c grz-owl:reports ?finCond .
  ?finCond grz-owl:hasConditionComponent ?cc .
  ?cc rdf:type ?type .
}
GROUP BY (?type)

How many contracts have which type of financial conditions per profession?

SELECT  ?type COUNT (distinct ?c) 
WHERE 
{
  ?c grz-owl:reports ?finCond .
  ?finCond grz-owl:hasConditionComponent ?cc .
  ?cc rdf:type ?type .
  ?c grz-owl:introduces ?master .
  ?master grz-owl:role/grz-owl:roleType grz-owl:master .
  ?master grz-owl:profession/grz-owl:professionCategory  "musica" .
}
GROUP BY (?type)