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

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