Getting an error while using datename function with count fun in SQL Server

SELECT 
    DATENAME(dw, created_at) AS day_name, 
    COUNT(*) 
FROM
    users 
GROUP BY
    day_name

With this query, I am not able to get the count of the fetching dayname from from created_at column.

Please help me with this query.