Google BigQuery

Google BigQuery does not have distinct clause. The work around is to use Group by clause and get the distinct values with record count.