What is the name of the good with the highest average rank?
select t1.title from item as t1 join review as t2 on t1.i_id = t2.i_id group by t2.i_id order by avg ( t2.rank ) desc limit 1
What is the ID of cup?
select i_id from item where title = "cup"
Now, can you please tell me the name and id of the good with the highest average rank?
select t1.title, t1.i_id from item as t1 join review as t2 on t1.i_id = t2.i_id group by t2.i_id order by avg ( t2.rank ) desc limit 1