which countries did participated in both Friendly and Tournament type competitions.
CREATE TABLE competition (country VARCHAR, competition_type VARCHAR)
SELECT country FROM competition WHERE competition_type = 'Friendly' INTERSECT SELECT country FROM competition WHERE competition_type = 'Tournament'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE competition (country VARCHAR, competition_type VARCHAR) Question: which countries did participated in both Friendly and Tournament type competitions. [/INST] SELECT country FROM competition WHERE competition_type = 'Friendly' INTERSECT SELECT country FROM competition WHERE competition_type = 'Tournament' </s>