TicketSQL query to give a count

Anybody know how to make a TicketSQL query for RT that would list each
tech and then give a summary of their open/resolved tickets over a
specific period of time?
That would be handy!
Thanks
Mike