Be careful using count(distinct col1, col2, col3,...) !
If any of the columns which are used in the count(distinct xxx) function that have NULL values, the count is not accurate!