What items were ranked?
select distinct t1.title from item as t1 join review as t2 on t1.i_id = t2.i_id
How many have a rank that is greater than 3?
select count(distinct t1.title) from item as t1 join review as t2 on t1.i_id = t2.i_id where t2.rank > 3
List the names of these items.
select distinct t1.title from item as t1 join review as t2 on t1.i_id = t2.i_id where t2.rank > 3
Out of these items, which ones also have an average rating that is above 5?
select t1.title from item as t1 join review as t2 on t1.i_id = t2.i_id where t2.rank > 3 intersect select t1.title from item as t1 join review as t2 on t1.i_id = t2.i_id group by t2.i_id having avg(t2.rating) > 5