I would like to ask mysql how to query the query statement of the sales volume of new products in the current season, because the season will involve new years, so it is difficult to determine whether it is the sales volume of new products in the current season according to the sales date. .
select DATE_FORMAT(updated_at,'%m') from instances where DATE_FORMAT(updated_at,'%m') between 10 and 12
However, this method is not recommended, because the function used in the query criteria will make the query very slow. in general, this situation will create another field [quarter] for table, and this field will be maintained when updating the sales date. previously, chart items that are counted by hour, morning, afternoon, evening, week, month and quarter have been maintained by another field considering the large amount of data.