No fours here. Dammit.

no-four.sql

CREATE PROCEDURE spGetChatUsersFlagged
	@threshold int
AS
BEGIN
	SET NOCOUNT ON;

	SELECT DISTINCT
		Students.username,
		Students.StudentID,
		COUNT(flagID) AS FlagCount
	FROM
		Students
		JOIN ChatMessages ON Students.StudentID = ChatMessages.studentID
		JOIN ChatMessageFlag ON ChatMessages.messageID = ChatMessageFlag.messageID
	GROUP BY
		Students.UserName,
		Students.StudentID
	HAVING
		COUNT(flagID) >= @threshold
END