COUNT DISTINCT ELEMENT AND SUBTRACT FROM TOTATL IN SQL QUERY code example

Example: select count of distinct values sql

SELECT COUNT (DISTINCT column-name)  FROM table-name