select
    a.policy_number,
    b.first_name || ' ' || b.family_name          as policy_holder,
    c.make || ' ' || c.model                      as vehicle,
    c.license_number,
    cast(date_trunc('day', a.inception) as date)  as inception_date,
    a.premium
from 
    policy a
    left outer join
    party b
    on a.policy_holder_id = b.id
    left outer join
    vehicle c
    on a.vehicle_id = c.id;