List the title and rating for each item.
select t1.title, t2.rating from item as t1 join review as t2 on t1.i_id = t2.i_id
Order by increasing 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 asc
How many received a rating below 5?
select count(*) from item as t1 join review as t2 on t1.i_id = t2.i_id where t2.rating < 5
What are the names of these items?
select t1.title from item as t1 join review as t2 on t1.i_id = t2.i_id where t2.rating < 5