and forgot to include the sql for counting tickets with severities...