0 - 1 of 1 tags for renaming name field to return date value

I have a query and want to return the date as the field name. What do I need to do to turn the date value as a field name?

select Suppress_Cd, supp_desc,

count(distinct STHD_KY)  as CAST((CAST(DATE AS FORMAT 'MMMDD')) AS CHAR(5)) from testble

 

thanks