List the ratings of all goods.
select rating from review
Include the names of the goods.
select t1.title, t2.rating from item as t1 join review as t2 on t1.i_id = t2.i_id
How many received a rating of 10?
select count(*) from item as t1 join review as t2 on t1.i_id = t2.i_id where t2.rating = 10
What are the names of these goods?
select t1.title from item as t1 join review as t2 on t1.i_id = t2.i_id where t2.rating = 10