adding sql for get count closed and get count and days open to also get
by graffiti type