FOR SQL USERS. CAN you use concat and extract in a query simultaneously. So far I have the following, It does not work with EXTRACT. If anyone could give me any advice, it would be appreciated.

SELECT CONCAT(s.state_code,' - ',s.state_name,' - ', w.city_name,' - ', w.IP) AS IP_location, COUNT(*) AS number_of_locations EXTRACT(month, event_begin_time) AS month, FROM census_data w INNER JOIN state_ data ON w.state_code = s.state_code GROUP BY CONCAT(s.state_code,' - ',s.state_name,' - ', w.city_name,' - ', w.IP) ORDER BY number_of_locations DESC LIMIT 50;