SHARE
TWEET

Untitled

a guest Oct 21st, 2019 67 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 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
  2. INNER JOIN emails_clicks ON emails_sent.id = emails_clicks.id_email
  3. GROUP BY emails_sent.id_type, DAYNAME(emails_clicks.date_click);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top