instruction: For those employees who did not have any job in the past, return a bar chart about the distribution of hire_date and the average of employee_id bin hire_date by weekday.
response: SELECT HIRE_DATE, AVG(EMPLOYEE_ID) FROM employees WHERE NOT EMPLOYEE_ID IN (SELECT EMPLOYEE_ID FROM job_history)