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
Tell me the work types of Anna Powierza.
assistant
SELECT T1.Work_Type FROM journal_committee AS T1 JOIN editor AS T2 ON T1.Editor_ID = T2.Editor_ID WHERE T2.Name = 'Anna Powierza';
human
What is her age?
assistant
SELECT Age FROM editor WHERE Name = 'Anna Powierza';
human
Tell me the most common age of editors.
assistant
SELECT Age FROM editor GROUP BY Age ORDER BY COUNT( * ) DESC LIMIT 1 ;