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