mybatis中xml

SELECT player_id, name, goals, shots, (goals * 1.0 / NULLIF(shots, 0)) AS goal_rate FROM player_stats ORDER BY goal_rate DESC ORDER BY goals DESC ORDER BY player_id ASC LIMIT #{offset}, #{limit}

List selectPlayersWithStatsAndPaging(
@Param(“sortByRate”) Boolean sortByRate,
@Param(“sortByGoals”) Boolean sortByGoals,
@Param(“offset”) Integer offset,
@Param(“limit”) Integer limit);