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

Find the id of the item whose title is 'orange'.
SELECT i_id FROM item WHERE title = "orange"
SELECT "i_id" FROM "item" WHERE "orange" = "title"