How to Count records in Query SQL Server database with and without duplicate values

Published --