What is item number 4?
select * from item where i_id = 4
What is the avocado's rating?
select rating from review where i_id = ( select i_id from item where title = "avocado" )
And what about the avocado's rank?
select rank from review where i_id = ( select i_id from item where title = "avocado" )