Jammink2/count_emails.sql

Created September 16, 2016 00:23

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Jammink2/3b7c3e30f95ad2045046410e218b6619.js"></script>
Save Jammink2/3b7c3e30f95ad2045046410e218b6619 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

count_emails.sql

SELECT SUM(c) AS total_subscribers, COUNT(email) AS distinct_subscribers FROM (SELECT email, COUNT(1) as c FROM email) tbl -- Get two columns, one total, another # of distinct email addresses

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment