Show 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'
The one I asked before
select t1.journal_id from journal as t1 join journal_committee as t2 on t1.journal_id = t2.journal_id where t2.work_type = 'Photo'