List the names of all items
select title from item
Show the average rating of each one as well.
select t1.title, avg(t2.rating) from item as t1 join review as t2 on t1.i_id = t2.i_id group by t2.i_id
Order by increasing average rating.
select t1.title, avg(t2.rating) 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)
Which one has the lowest?
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