Can someone please assist with this string literal code error

df_department_id = pd.read_sql('SELECT d.department_id, department_name, COUNT() FROM department d INNER JOIN department d ON d.department_id = p.department_id GROUP BY d.department_name ORDER BY COUNT() DESC', conn)