What is the user id of Helen
select u_id from useracct where name = "Helen"
What is Helen rating?
select t2.rating from useracct as t1 join review as t2 on t1.u_id = t2.u_id where t1.name = 'Helen'
And what is helen rank
select t2.rank from useracct as t1 join review as t2 on t1.u_id = t2.u_id where t1.name = 'Helen'
What is helen item id
select t2.i_id from useracct as t1 join review as t2 on t1.u_id = t2.u_id where t1.name = 'Helen'
How about her a id
select t2.a_id from useracct as t1 join review as t2 on t1.u_id = t2.u_id where t1.name = 'Helen'
Who gave the most reviews
select t1.name from useracct as t1 join review as t2 on t1.u_id = t2.u_id group by t2.u_id order by count ( * ) desc limit 1
How many review did he have
select count ( * ) from useracct as t1 join review as t2 on t1.u_id = t2.u_id group by t2.u_id order by count ( * ) desc limit 1
Yes what is mark rank?
select t2.rank from useracct as t1 join review as t2 on t1.u_id = t2.u_id where t1.name = 'Mark'
What is matk user id
select u_id from useracct where name = 'Mark'
What is his a id
select t2.a_id from useracct as t1 join review as t2 on t1.u_id = t2.u_id where t1.name = 'Mark'