for selecting dates during a year, use BETWEEN with a range of dates rather than the YEAR() function: this allows the database to take better advantage of indexes