𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
You have 2 minutes to solve this SQL query.

Find the employees who joined in the last 30 days.

Assume the table structure:
employees(employee_id, employee_name, department, joining_date)

𝗠𝗲: Challenge accepted! 💪

SELECT
employee_id,
employee_name,
department,
joining_date
FROM employees
WHERE joining_date >= CURRENT_DATE - INTERVAL '30 days';

💡 Explanation:
This query filters employees whose joining date falls within the last 30 days.

• CURRENT_DATE returns today's date.
• INTERVAL '30 days' subtracts 30 days from the current date.
• The WHERE clause returns employees who joined on or after that date.

This question tests your understanding of:
✅ Date Functions
✅ Date Arithmetic
✅ Filtering Records with Dates

🎯 Expected Output Example
Employee Department Joining Date
John IT 2026-06-10
Sarah HR 2026-06-22

🚀 Database-Specific Alternatives

MySQL
SELECT *
FROM employees
WHERE joining_date >= CURDATE() - INTERVAL 30 DAY;

SQL Server
SELECT *
FROM employees
WHERE joining_date >= DATEADD(DAY, -30, GETDATE());

Oracle
SELECT *
FROM employees
WHERE joining_date >= SYSDATE - 30;

🚀 Tip for SQL Job Seekers:
Date-related SQL questions are very common. Make sure you're comfortable with:
• Finding records from the last N days
• Current month/year filters
• Date differences
• Date formatting
• Database-specific date functions

❤️ React with ❤️ for more SQL interview challenges!