Count number of unique values

use

SELECT count( DISTINCT(email) ) FROM orders

Distinct provide unique email ids and then simply count them.

SELECT  count(DISTINCT(email)) FROM orders

its different from your posting, since its filters out the duplicates before counting it