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)
CREATE TABLE review (a_id NUMBER, u_id NUMBER, i_id NUMBER, rating NUMBER, rank NUMBER)

Find the name and id of the good with the highest average rank.
SELECT T1.title, T1.i_id FROM item AS T1 JOIN review AS T2 ON T1.i_id = T2.i_id GROUP BY T2.i_id ORDER BY AVG(T2.rank) DESC LIMIT 1
SELECT "T1"."title", "T1"."i_id" FROM "item" "T1" JOIN "review" "T2" ON "T1"."i_id" = "T2"."i_id" GROUP BY "T2"."i_id" ORDER BY AVG("T2"."rank") DESC FETCH FIRST 1 ROWS ONLY