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

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")