Show the document id with paragraph text 'Brazil' and 'Ireland'.
CREATE TABLE Paragraphs (document_id VARCHAR, paragraph_text VARCHAR)
SELECT document_id FROM Paragraphs WHERE paragraph_text = 'Brazil' INTERSECT SELECT document_id FROM Paragraphs WHERE paragraph_text = 'Ireland'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Paragraphs (document_id VARCHAR, paragraph_text VARCHAR) Question: Show the document id with paragraph text 'Brazil' and 'Ireland'. [/INST] SELECT document_id FROM Paragraphs WHERE paragraph_text = 'Brazil' INTERSECT SELECT document_id FROM Paragraphs WHERE paragraph_text = 'Ireland' </s>