CREATE TABLE review (a_id NUMBER, u_id NUMBER, i_id NUMBER, rating NUMBER, rank NUMBER)
CREATE TABLE useracct (u_id NUMBER, name CLOB)
CREATE TABLE item (i_id NUMBER, title CLOB)
CREATE TABLE trust (source_u_id NUMBER, target_u_id NUMBER, trust NUMBER)

Find the names of goods that receive a rating of 10.
SELECT T1.title FROM item AS T1 JOIN review AS T2 ON T1.i_id = T2.i_id WHERE T2.rating = 10
SELECT "T1"."title" FROM "item" "T1" JOIN "review" "T2" ON "T1"."i_id" = "T2"."i_id" AND "T2"."rating" = 10