Database: cre_Doc_Template_Mgt
Question: What are the ids of documents that contain the paragraph text 'Brazil' and 'Ireland'?
SQL:
SELECT document_id FROM Paragraphs WHERE paragraph_text  =  'Brazil' INTERSECT SELECT document_id FROM Paragraphs WHERE paragraph_text  =  'Ireland'