I know that Transform and Pivot are not recognized commands in SQL and I have looked everywhere on how to covert the below query from Access to run properly in SQL, but I can't seem to find the answer.
If someone could help, that would be awesome.
Thanks!

TRANSFORM Count(ConfirmOriginRecords.PHNum) AS [The Value]
SELECT ConfirmOriginRecords.SendZip, Count(ConfirmOriginRecords.PHNum) AS [Total Of PHNum]
FROM ConfirmOriginRecords
GROUP BY ConfirmOriginRecords.SendZip
PIVOT ConfirmOriginRecords.SendDay