Neil Teng
SELECT approx_distinct(id) AS "count" FROM table WHERE start_date <= current_date() AND end_date >= current_date()
Mayank