text: CREATE TABLE editor (Name VARCHAR, editor_id VARCHAR); CREATE TABLE journal_committee (Name VARCHAR, editor_id VARCHAR) -- List the names of editors that are not on any journal committee. SELECT Name FROM editor WHERE NOT editor_id IN (SELECT editor_id FROM journal_committee) CREATE TABLE journal_committee (journal_ID VARCHAR); CREATE TABLE journal (date VARCHAR, theme VARCHAR, sales VARCHAR); CREATE TABLE journal (date VARCHAR, theme VARCHAR, sales VARCHAR, journal_ID VARCHAR) -- List the date, theme and sales of the journal which did not have any of the listed editors serving on committee. SELECT date, theme, sales FROM journal EXCEPT SELECT T1.date, T1.theme, T1.sales FROM journal AS T1 JOIN journal_committee AS T2 ON T1.journal_ID = T2.journal_ID CREATE TABLE journal_committee (journal_ID VARCHAR, work_type VARCHAR); CREATE TABLE journal (sales INTEGER, journal_ID VARCHAR) -- 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' CREATE TABLE Accounts (Id VARCHAR) -- How many accounts do we have? SELECT COUNT(*) FROM Accounts CREATE TABLE Accounts (account_id VARCHAR, customer_id VARCHAR, account_name VARCHAR) -- Show ids, customer ids, names for all accounts. SELECT account_id, customer_id, account_name FROM Accounts