CREATE TABLE journal_committee (editor_id NUMBER, journal_id NUMBER, work_type CLOB)
CREATE TABLE journal (journal_id NUMBER, date CLOB, theme CLOB, sales NUMBER)
CREATE TABLE editor (editor_id NUMBER, name CLOB, age NUMBER)

What is the average sales of the journals that have an editor whose work type is 'Photo'?
SELECT AVG(T1.sales) FROM journal AS T1 JOIN journal_committee AS T2 ON T1.journal_id = T2.journal_id WHERE T2.work_type = 'Photo'
SELECT AVG("T1"."sales") FROM "journal" "T1" JOIN "journal_committee" "T2" ON "T1"."journal_id" = "T2"."journal_id" AND "T2"."work_type" = 'Photo'