Example of a sql routine that counts and return the number of times an id appears on sql

DECLARE @AA INT
SET @AA=(SELECT COUNT(*) as TheCount From Coursework_Validation Where Outside_Institution_ID = @Outside_Institution_ID )
return @AA