Group Employees by Joined Day Name
Find employees who joined on the same day of the week.
sql
SELECT DAYNAME(joined_at) AS day_of_week, GROUP_CONCAT(name) AS employees FROM employees GROUP BY DAYNAME(joined_at) HAVING COUNT(*) > 1;
This query groups employees by the name of the day they joined and returns the day name along with a comma-separated list of employee names for all days where more than one employee was hired.
PromptDB can make mistakes. Please double-check responses.