为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:dm7
【操作系统】：windows10
【CPU】:amd
【问题描述】*：
问题1：count(if(Risk_Contents != ‘’ and Risk_Contents is not NULL, Risk_Contents, null)) 这条语句中第二次使用risk_contents软件显示没有引用成功 白色字体，使用的datagrip
问题2：如标题所示，上文提及的语句执行会报无法解析的成员访问表达式错误
SELECT substr(fill_date, 1, 10) AS createDate,
count(fill_date) AS createCount,
sum(view_count) AS viewCount,
round(sum(Progress) / count(fill_date)) AS progress,
count(if(Risk_Contents is not NULL and Risk_Contents != ‘’ , Risk_Contents, null)) AS riskCount,
sum(if(File_ID is null OR File_ID = ‘’, 0, (length(File_ID) - length(REPLACE(File_ID, ‘,’ , ‘’))) +1)) AS fileCount
FROM pub_work_log_information
where 1 = 1
and fill_by = ‘d357acc0-f662-4733-be2e-17d07b24cf94’
and substr(fill_date,1,7)=‘2022-1’
GROUP BY
substr(fill_date, 1, 10)
ORDER BY
substr(fill_date, 1, 10)