java - springboot - jpa - query(

季度查询
    @Query(value = "select SUM(reward_amount) from  表名 where wallet_id=:walletId and QUARTER(create_time)=QUARTER(now())",nativeQuery = true)
    BigDecimal getQuarterReward(@Param("walletId") Integer walletId);
年度查询
    @Query(value = "select SUM(reward_amount) from  表名 where wallet_id=:walletId and  YEAR(create_time)=YEAR(now())",nativeQuery = true)
    BigDecimal getYearReward(@Param("walletId") Integer walletId);
季度 按月 分组
    @Query(value = "select MONTH (create_time) AS MONTH,  SUM(reward_amount) from 表名 where wallet_id=:walletId and  QUARTER(create_time)=QUARTER(now()) GROUP BY MONTH (create_time)",nativeQuery = true)
    List getQuarterMonthReward(@Param("walletId") Integer walletId);
年度 按月 分组
    @Query(value = "select MONTH (create_time) AS MONTH,  SUM(reward_amount) from 表名 where wallet_id=:walletId and reward_type!=2 and YEAR(create_time)=YEAR(now()) GROUP BY MONTH (create_time)",nativeQuery = true)
    List getYearMonthReward(@Param("walletId") Integer walletId);