Running SQL:
SELECT
    mvs.serial,
    CASE
        WHEN reg.email IS NULL THEN '--no match'
        WHEN (
            CAST(REPLACE(IFNULL(reg.location, 'Kes 0.00'), 'Kes ', '') AS DECIMAL(10, 2)) >= 50.00
            AND
            CAST(REPLACE(IFNULL(reg.password, 'Kes 0.00'), 'Kes ', '') AS DECIMAL(10, 2)) >= 50.00
        ) THEN '--quality'
        ELSE '--not-quality'
    END AS airtime
FROM
    (
        SELECT professors.name, serial AS serial
        FROM movies, professors
        WHERE professors.Id_no = 867996409
          AND professors.Id_no = movies.Id_no
          AND date_time LIKE '%2025-08%'
    ) mvs
LEFT JOIN
    (
        SELECT email, location, password
        FROM reg
    ) reg
ON reg.email = mvs.serial