SELECT emails_sent.id_type As "Type", DAYNAME(emails_clicks.date_click) AS "Day", COUNT(*) / COUNT(DISTINCT emails_sent.id) AS "CTR" FROM emails_sent
INNER JOIN emails_clicks ON emails_sent.id = emails_clicks.id_email
GROUP BY emails_sent.id_type, DAYNAME(emails_clicks.date_click);