SELECT DATE_PART('Year', joining_date) AS joining_year, COUNT(emp_id) AS total_employees FROM emp_info GROUP BY DATE_PART('Year', joining_date);date_trunc('month', col_date)
SELECT DATE_PART('Year', joining_date) AS joining_year, COUNT(emp_id) AS total_employees FROM emp_info GROUP BY DATE_PART('Year', joining_date);date_trunc('month', col_date)