分组月份和年份时的外部参考错误(Outer Reference error when grouping month and years)

 出现以下错误： 
 
Each GROUP BY expression must contain at least one column that is not an outer reference
 
 我想列出按设施，月份和年份分组的calculatedDrugDistributionHistory列表。 我只想了解哪些设施已经导入我们的系统。 
 
 我有这个问题： 
 
select 
    f.name,
    MONTH(cddh.dateGiven) as 'date_month',
    YEAR(cddh.dateGiven) as 'date_year' 
from 
    calculatedDrugDistributionHistory cddh
        inner join facilityIndividuals fi on fi.facilityIndividualId = cddh.facilityIndividualId
        inner join facilities f on fi.facilityId = f.facilityId
group by 
    f.name,
    'date_month',
    'date_year'
order by
    f.name,
    'date_month',
    'date_year'

Getting the following error:
 
Each GROUP BY expression must contain at least one column that is not an outer reference
 
I'd like to have a listing of calculatedDrugDistributionHistory grouped by facilty, month, and year. I just want to take inventory of which facilities for which months have been imported into our system.
 
I have this query:
 
select 
    f.name,
    MONTH(cddh.dateGiven) as 'date_month',
    YEAR(cddh.dateGiven) as 'date_year' 
from 
    calculatedDrugDistributionHistory cddh
        inner join facilityIndividuals fi on fi.facilityIndividualId = cddh.facilityIndividualId
        inner join facilities f on fi.facilityId = f.facilityId
group by 
    f.name,
    'date_month',
    'date_year'
order by
    f.name,
    'date_month',
    'date_year'

原文：https://stackoverflow.com/questions/17859310