instruction: How many professors whose office is located in DRE 102 are hired in each weekday? Return a bar chart, and could you sort in ascending by the Y-axis?
response: SELECT EMP_HIREDATE, COUNT(EMP_HIREDATE) FROM EMPLOYEE AS T1 JOIN PROFESSOR AS T2 ON T1.EMP_NUM = T2.EMP_NUM WHERE T2.PROF_OFFICE = 'DRE 102' ORDER BY COUNT(EMP_HIREDATE)