Auto assigning a User based on comparison of summary fields

When a new Ticket is added in the Tickets Table, how would I auto assign a Team Member based on the who has the fewest open assignments in the Assignments Table?

------------------------------
Chris Swirtz
------------------------------