select user_id from cc_users where upper(screen_name) = upper(:screen_name)
select user_id from cc_users where upper(screen_name) = upper(:screen_name)
select email from parties where party_id = :party_id
select group_id from groups where group_name = :name
select first_names, last_name
from persons
where person_id = :person_id
update persons
set first_names = :first_names,
last_name = :last_name
where person_id = :person_id
select first_names||' '||last_name as person_name
from persons
where person_id = :person_id