yes
select name from useracct where u_id = 1
What is the name of user id 3?
select name from useracct where u_id = 3
What is the rank of user id 3?
select t2.rank from useracct as t1 join review as t2 on t1.u_id = t2.u_id where t2.u_id = 3
What is the average rating of reviews of user id1?
select avg ( t2.rating ) from useracct where t2.u_id = 1 as t1 join review as t2 on t1.u_id = t2.u_id group by t2.u_id
Find out the average rating of every user?
select t1.name, avg ( t2.rating ) from useracct as t1 join review as t2 on t1.u_id = t2.u_id group by t2.u_id