Selecting Multiple Values from Same Coulmn
You can use a not exists query:

select distinct t1.name_last, t1.name_first
from the_table t1
where not exists (select *
                  from the_table t2
                  where t1.name_last = t2.name_last
                    and t1.name_first = t2.name_first
                    and t2.role = 'create');


The NOT EXISTS operator returns "true" if the sub-select returns nothing. In this case the sub-select looks for any row with the same name as the outer row but with the role create