CREATE TABLE event (event_id NUMBER, date CLOB, venue CLOB, name CLOB, event_attendance NUMBER)
CREATE TABLE news_report (journalist_id NUMBER, event_id NUMBER, work_type CLOB)
CREATE TABLE journalist (journalist_id NUMBER, name CLOB, nationality CLOB, age CLOB, years_working NUMBER)

Show the nations that have both journalists with more than 10 years of working and journalists with less than 3 years of working.
SELECT nationality FROM journalist WHERE years_working > 10 INTERSECT SELECT nationality FROM journalist WHERE years_working < 3
SELECT "nationality" FROM "journalist" WHERE "years_working" > 10 INTERSECT SELECT "nationality" FROM "journalist" WHERE "years_working" < 3