Count number of unique values

use

SELECT count( DISTINCT(email) ) FROM orders

Distinct provide unique email ids and then simply count them.