CREATE
    ALGORITHM = TEMPTABLE
VIEW bd_hospital.noDoctor_patients AS
    SELECT
        pn.name
    FROM
        bd_hospital.patient AS pt
            JOIN
        bd_hospital.person AS pn ON (pt.id_person = pn.id
            AND pt.id_doctor IS NULL)
    GROUP BY pn.id;