CREATE OR REPLACE VIEW public.vw_guest_with_tutor AS
 SELECT g.email AS guest_email,
    g.name,
    g.surname,
    g.phone,
    g.country,
    g.zinzino_range,
    g.course_id,
    g.tutor_id,
    g.reg_date,
    pt.name AS tutor_name,
    pt.surname AS tutor_surname,
    pt.email AS tutor_email,
    btrim((pt.name::text || ' '::text) || COALESCE(pt.surname, ''::character varying)::text) AS tutor_full_name
   FROM guests g
     LEFT JOIN partners pt ON pt.partner_id = g.tutor_id;;