Untitled

select 
createdbyid."Name" as created_by,
saib."CreatedOn" + interval '3 hour' as created_on,
modifiedbyid."Name" as modified_by,
saib."ModifiedOn" + interval '3 hour' as modified_on,
saib."SmAccountId" as account_identificator,
saib."SmBrandId" as brand_identificator,
saib."SmAccountBillingInfoId" as account_billing_info_identificator
from "SmAccountInBrand" saib 
left join "Contact" createdbyid
    on createdbyid."Id"  = saib."CreatedById" 
left join "Contact" modifiedbyid
    on modifiedbyid."Id" = saib."ModifiedById"