Count Employees Hired By Weekday

Question

Find the number of employees hired on each day of the week.

Accepted Answer

```sql
SELECT DAYNAME(hire_date) AS day_of_week, COUNT(*) AS employee_count
FROM employees
GROUP BY day_of_week;
```

This query groups the records from the "employees" table by the name of the day derived from the "hire_date" column and calculates the total count of employees for each respective day.