Show the names of editors and the theme of journals for which they serve on committees.
create table journal_committee (editor_id varchar, journal_id varchar, PRIMARY KEY (editor_id)); create table editor (name varchar, editor_id varchar, PRIMARY KEY (name)); create table journal (theme varchar, journal_id varchar, PRIMARY KEY (theme))
select t2.name, t3.theme from journal_committee as t1 join editor as t2 on t1.editor_id = t2.editor_id join journal as t3 on t1.journal_id = t3.journal_id