Show the nations that have both journalists with more than 10 years of working and journalists with less than 3 years of working.
CREATE TABLE journalist (Nationality VARCHAR, Years_working INTEGER)
SELECT Nationality FROM journalist WHERE Years_working > 10 INTERSECT SELECT Nationality FROM journalist WHERE Years_working < 3
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE journalist (Nationality VARCHAR, Years_working INTEGER) Question: Show the nations that have both journalists with more than 10 years of working and journalists with less than 3 years of working. [/INST] SELECT Nationality FROM journalist WHERE Years_working > 10 INTERSECT SELECT Nationality FROM journalist WHERE Years_working < 3 </s>