Yes!  That is correct!
select i_id, title from item
I would like to filter the list to show the entries which have a rank value that is higher than 3 please.
select t1.title, t1.i_id from item as t1 join review as t2 on t1.i_id = t2.i_id where t2.rank > 3
Excellent.  Can you  include to this list the review rating for each of these items?
select t1.title, t1.i_id, rating from item as t1 join review as t2 on t1.i_id = t2.i_id where t2.rank > 3