human
Schema:
event (Event_ID, Date, Venue, Name, Event_Attendance)
journalist (journalist_ID, Name, Nationality, Age, Years_working)
news_report (journalist_ID, Event_ID, Work_Type)
Please answer with SQL.
assistant
Sure, I understand.
human
Which journalists have been working for less than 3 years?
assistant
SELECT * FROM journalist WHERE Years_working < 3;
human
Also add those that have been working for over 10!
assistant
SELECT * FROM journalist WHERE Years_working < 3 OR Years_working > 10 ;