What are all of the users’ names?
select name from useracct
Only show the names of source users.
select distinct t1.name from useracct as t1 join trust as t2 on t1.u_id = t2.source_u_id
Order them by decreasing average trust score.
select t1.name from useracct as t1 join trust as t2 on t1.u_id = t2.source_u_id group by t2.source_u_id order by avg(trust) desc
Who has the highest average trust score?
select t1.name from useracct as t1 join trust as t2 on t1.u_id = t2.source_u_id group by t2.source_u_id order by avg(trust) desc limit 1