Hi @upi
Here is the query that will give you sent,open and click for all your campaigns.
select c.name as name, c.emails_sent as total_sent, count(e.scheduled_id) as total_opened , SUM(e.is_clicked) as total_clicked
from campaign_schedules as c
left join email_opened as e
ON c.id =...