you can use execute sql task in the control flow to determine count of records of your query, and store this value in a variable (countofRecords).

In the precedence constraints that connects between execute sql task and email task, use "expression" as evaluation operation to execute email task. your expression would be @countofRecords > 0 . So email task executes only when record count is equal to or greater than 1.

In the email task, use attachment options to send the result of your query.