Find the names of items whose rank is higher than 3 and whose average rating 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
items whose rank is higher than 3 refers to T2.rank > 3; whose average rating is above 5 refers to HAVING avg(T2.rating) > 5; names of items refers to T1.title; combining conditions from different relations requires JOIN and INTERSECT.