UPDATE dtf.madelines_contacts
SET email = concat(lower(first_name), '.', lower(last_name),'@roger_roger.com');