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

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" AS "T1" JOIN "journal_committee" AS "T2" ON "T1"."journal_id" = "T2"."journal_id" AND "T2"."work_type" = 'Photo'