which item has the highest rating?
select t1.title from item as t1 join review as t2 on t1.i_id = t2.i_id order by rating desc limit 1
what is the average rating?
select avg ( rating ) from review
what items have higher rating than 7?
select t1.title from item as t1 join review as t2 on t1.i_id = t2.i_id where t2.rating > 7
what is item id of cup?
select i_id from item where title = 'cup'
what is item id 4?
select title from item where i_id = 4
please list all items
select * from item
please list each item and rating from highest to lowest rating
select t1.title, t2.rating from item as t1 join review as t2 on t1.i_id = t2.i_id order by t2.rating