CREATE TABLE item (title VARCHAR2, i_id VARCHAR2)
CREATE TABLE review (rating NUMBER)

Find the titles of items whose rating is higher than the average review rating of all items.
SELECT T1.title FROM item AS T1 JOIN review AS T2 ON T1.i_id = T2.i_id WHERE T2.rating > (SELECT AVG(rating) FROM review)
SELECT "T1"."title" FROM "item" "T1" JOIN "review" "T2" ON "T1"."i_id" = "T2"."i_id" AND "T2"."rating" > (SELECT AVG("rating") FROM "review")