Including multiple SQL statements in a single RMarkdown Chunk

I am running SQL statements within my RMarkdown script but it seems that I can only execute 1 statement per chunk. For example running these individually works fine “`{sql} select…