Report generation expression

[Badminton_Scori]

Hi

I am have a audit management app
I am having agent table and task table
Agent table has email id has key
Task table I have column agent name and I made it has ref to agent table

I need help on creating a automation for sending a daily report of task for each agent and audit manager

How to send. Filtered data in schedule ?

What expression should I need to use in email body template