Query Employees Joined Last Thirty Days

Find employees who joined in the last 30 days.

sql

SELECT id, name, created_at FROM employees WHERE created_at >= DATE_SUB(CURDATE(), INTERVAL 30 DAY);

This query selects the "id", "name", and "created_at" columns from the "employees" table for records where the "created_at" date is within the last 30 days relative to the current date.

PromptDB can make mistakes. Please double-check responses.