SQL 1

select  r.datenew::date, r.datenew::date,  at.name, atv.value empl, tl.units*tl.price amount,  tl.units*tl.price*(select content::char::numeric from resources where name='Employee.Tips%')/100 tips
from attribute at, attributeset ats, attributeuse atu, attributevalue atv, receipts r, ticketlines tl, tickets t,
attributesetinstance asi, attributeinstance ai
where ats.id=atu.attributeset_id
and at.id=atu.attribute_id
and at.id=atv.attribute_id
and t.id=r.id
and t.id=tl.ticket
and tl.attributesetinstance_id=asi.id
and atu.attributeset_id=asi.attributeset_id
and asi.id=ai.attributesetinstance_id
and ai.attribute_id=atu.attribute_id
and  atv.value = ai.value