如何在Android房间数据库中使用GROUPBY date？

@Ignore
public int getYearFromDate(String date) {
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd", Locale.getDefault());
    try {
        Date parsedDate = sdf.parse(date);
        Calendar calendar = Calendar.getInstance();
        calendar.setTime(parsedDate);
        return calendar.get(Calendar.YEAR);
    } catch (ParseException e) {
        e.printStackTrace();
    }
    return 0;
}

@Query("SELECT yearFromDate(date) AS year, COUNT(*) AS count FROM your_table GROUP BY year")
List<YearCount> getCountByYear();

public class YearCount {
    private int year;
    private int count;

    // 构造函数、getter和setter方法
}