human
Schema:
journal (Journal_ID, Date, Theme, Sales)
editor (Editor_ID, Name, Age)
journal_committee (Editor_ID, Journal_ID, Work_Type)
Please answer with SQL.
assistant
Sure, I understand.
human
show the names of editors that are on at least two journal committees?
assistant
SELECT T1.Name FROM editor AS T1 JOIN journal_committee AS T2 ON T1.Editor_ID = T2.Editor_ID GROUP BY T1.Name HAVING COUNT( * ) > = 2;
human
what is the work type of Kamila Porczyk?
assistant
SELECT T2.Work_Type FROM editor AS T1 JOIN journal_committee AS T2 ON T1.Editor_ID = T2.Editor_ID WHERE T1.Name = 'Kamila Porczyk';
human
how much years old is Anna Powierza ?
assistant
SELECT T1.Age FROM editor AS T1 WHERE T1.Name = "Anna Powierza" ;