FOR SQL USERS. In my previous query which is displayed below I only used the extract function for the month. For the next problem, I need to use the extract function for both the month and year. I tried to solve it below. Any help would be greatly appreciated.

PREVIOUS QUERY:

SELECT CONCAT(s.state_code,' - ',s.state_name,' - ', w.city_name,' - ', w.IP) AS IP_location,

COUNT(*) AS number_of_locations,

EXTRACT(month FROM event_begin_time) AS month

FROM census_data w

INNER JOIN state_data s ON w.state_code = s.state_code

GROUP BY IP_location, month

ORDER BY number_of_locations DESC

LIMIT 50;

TRYING TO INCORPORATE BOTH EXTRACT FUNCTIONS for month and year. DOES NOT RETURN RESULT:

SELECT CONCAT(s.state_code,' - ',s.state_name,' - ', w.city_name,' - ', w.IP) AS IP_location,

COUNT(*) AS number_of_locations,

EXTRACT(month FROM event_begin_time) AS month

EXTRACT(year FROM event_begin_time) AS year

FROM census_data w

INNER JOIN state_data s ON w.state_code = s.state_code

GROUP BY IP_location, month

GROUP BY IP_location, year

ORDER BY number_of_locations DESC

LIMIT 50;