How do you write a query to get the average salary of all active employees by job title?