MSSQL

 SELECT DISTINCT count(pv.CandidateId) ,Month(pv.DatePaid) FROM dfadfasdf AS pv INNER JOIN dfadfasdf.Candidate AS cd ON cd.CandidateID = pv.CandidateId INNER JOIN dfadfasdf.Province AS p ON p.ID = cd.ProvinceID  WHERE Year(DatePaid) = '2022' AND Month(DatePaid) IN ('01', '02', '03') GROUP BY Month(pv.DatePaid) ORDER BY count(pv.CandidateId) SELECT DISTINCT count(pv.CandidateId) AS "Candidate Count" ,cd.ProvinceID ,Month(pv.DatePaid) AS "Month" FROM dfadfasdf.dbo.PayrollVIPFile AS pv INNER JOIN dfadfasdf.dbo.Candidate AS cd ON cd.CandidateID = pv.CandidateId INNER JOIN dfadfasdf.dbo.Province AS p ON p.ID = cd.ProvinceID  WHERE Year(DatePaid) = '2021' AND Month(DatePaid) IN ('01', '02', '03') GROUP BY cd.ProvinceID, Month(pv.DatePaid) ORDER BY count(pv.CandidateId), Month(pv.DatePaid)

  SET IDENTITY_INSERT (Transact-SQL) Article 01/30/2021 2 minutes to read 14 contributors Applies to:   SQL Server (all supported versions)  Azure SQL Database  Azure SQL Managed Instance  Azure Synapse Analytics Allows explicit values to be inserted into the identity column of a table.   Transact-SQL Syntax Conventions Syntax syntaxsql SET IDENTITY _ INSERT [ [ database_name . ] schema_name . ] table_name { ON | OFF }