For a simple user awards system: Show all users who received more than 3 awards in a single calendar week. Exclude awards that have already been issued.

count-in-a-week.sql

SELECT 		user_id, 
		COUNT(*) AS num, 
		date_format(creation_date, '%Y%u') AS theweek,
FROM 		awards 
WHERE 		issued = 0 
GROUP BY 	user_id, theweek		
HAVING 		num >= 3;