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