What is the name of the item with the highest average rating?
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.rating ) desc limit 1
What is its id?
select 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.rating ) desc limit 1
What is the name of the item with the lowest average rating?
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.rating ) limit 1
What is its item id?
select 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.rating ) limit 1
What item names have a rating of 5?
select t1.title from item as t1 join review as t2 on t1.i_id = t2.i_id where rating = 5