instruction: Publicity badges awarded within a given period.
response: SELECT UserId AS "user_link", SUM(CASE WHEN Name = 'Publicist' THEN 1 ELSE 0 END) AS Publicist, SUM(CASE WHEN Name = 'Booster' THEN 1 ELSE 0 END) AS Booster, SUM(CASE WHEN Name = 'Announcer' THEN 1 ELSE 0 END) AS Announcer, SUM(CASE WHEN (Name = 'Announcer') OR (Name = 'Booster') OR (Name = 'Publicist') THEN 1 ELSE 0 END) AS total FROM Badges WHERE Date >= '##Date1?2019-12-12##' AND Date <= '##Date2?2019-12-14##' GROUP BY UserId ORDER BY Publicist DESC, Booster DESC, Announcer DESC, total DESC LIMIT 200