UFN_CLASS_GETNUMBERENROLLED

CREATE function dbo.UFN_CLASS_GETNUMBERENROLLED
(
    @ID uniqueidentifier
)
returns integer
with execute as caller
as begin
    return coalesce((
        select MAX(CT)
        from (
            select
                COUNT(STUDENTCLASSMEETINGGROUP.ID) as CT
            from dbo.STUDENTCLASSMEETINGGROUP
                inner join dbo.CLASSMEETINGGROUP on dbo.STUDENTCLASSMEETINGGROUP.CLASSMEETINGGROUPID = dbo.CLASSMEETINGGROUP.ID
            where CLASSMEETINGGROUP.CLASSID = @ID
                and STUDENTCLASSMEETINGGROUP.STATUSCODE = 0        
            group by CLASSMEETINGGROUP.ID
        ) T
    ), 0)
end