What is 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
Which ones received a rating higher than 8?
select t1.title from item as t1 join review as t2 on t1.i_id = t2.i_id where t2.rating > 8
Out of those items, which ones also received a rating less than 5?
select t1.title from item as t1 join review as t2 on t1.i_id = t2.i_id where t2.rating > 8 intersect select t1.title from item as t1 join review as t2 on t1.i_id = t2.i_id where t2.rating < 5