Find each target user's name and average trust score.
create table trust (target_u_id varchar, PRIMARY KEY (target_u_id)); create table useracct (name varchar, u_id varchar, PRIMARY KEY (name))
select t1.name, avg(trust) from useracct as t1 join trust as t2 on t1.u_id = t2.target_u_id group by t2.target_u_id