If you provide 2 queries, SSIS will consider only first provided query and export result to excel.
1) You may run the query manually in SSMS and copy paste the result set to excel by yourself.
2) You may export the data twice to 2 excel sheets
3) You may also create SSIS package which will extract the data from SQL and load to Excel sheet1 and sheet2 but this one is time consuming.
-Vaibhav Chaudhari