added new methods for new sql for getting closed graffiti by type and
count and sum by type