SQL查询结果作SELECT排序字段

NFT对Goods为一对多关系，按照NFT下Goods的在售最低价升序或者在售最高价降序排列NFT，通过SQL实现排序。

查询Goods在售最低价或最高价作为SELECT字段，并使用其排序，返回nft_template_id字符串。

@Select(
        "SELECT t.`nft_template_id`,\n"
                + "       CASE\n"
                + "           WHEN (SELECT sale_price\n"
                + "                 FROM `s_nft_goods` b\n"
                + "                 WHERE t.`nft_template_id` = b.`nft_template_id`\n"
                + "                   AND `goods_status` = 1\n"
                + "                   AND destroy = 0\n"
                + "                 ORDER BY sale_price DESC\n"
                + "                 LIMIT 1) IS NULL THEN 0\n"
                + "           ELSE (SELECT sale_price\n"
                + "                 FROM `s_nft_goods` b\n"
                + "                 WHERE t.`nft_template_id` = b.`nft_template_id`\n"
                + "                   AND `goods_status` = 1\n"
                + "                   AND destroy = 0\n"
                + "                 ORDER BY sale_price DESC\n"
                + "                 LIMIT 1) END AS price\n"
                + "FROM `s_nft_base` t,\n"
                + "     `s_nft_biz` a\n"
                + "WHERE t.`nft_template_id` = a.`nft_template_id`\n"
                + "  AND a.`sec_market_sale` = 1\n"
                + "  AND (SELECT COUNT(id)\n"
                + "       FROM s_nft_goods AS sng\n"
                + "       WHERE sng.nft_template_id = a.nft_template_id\n"
                + "         AND sng.destroy = 0\n"
                + "       GROUP BY sng.nft_template_id) > 0\n"
                + "ORDER BY price DESC, t.id ASC")
List<String> selectMarketNftAllSeriesOrderByGoodsPriceDesc();

@Select(
        "SELECT t.`nft_template_id`,\n"
                + "       CASE\n"
                + "           WHEN (SELECT sale_price\n"
                + "                 FROM `s_nft_goods` b\n"
                + "                 WHERE t.`nft_template_id` = b.`nft_template_id`\n"
                + "                   AND `goods_status` = 1\n"
                + "                   AND destroy = 0\n"
                + "                 ORDER BY sale_price ASC\n"
                + "                 LIMIT 1) IS NULL THEN 99999\n"
                + "           ELSE (SELECT sale_price\n"
                + "                 FROM `s_nft_goods` b\n"
                + "                 WHERE t.`nft_template_id` = b.`nft_template_id`\n"
                + "                   AND `goods_status` = 1\n"
                + "                   AND destroy = 0\n"
                + "                 ORDER BY sale_price ASC\n"
                + "                 LIMIT 1) END AS price\n"
                + "FROM `s_nft_base` t,\n"
                + "     `s_nft_biz` a\n"
                + "WHERE t.`nft_template_id` = a.`nft_template_id`\n"
                + "  AND a.`sec_market_sale` = 1\n"
                + "  AND (SELECT COUNT(id)\n"
                + "       FROM s_nft_goods AS sng\n"
                + "       WHERE sng.nft_template_id = a.nft_template_id\n"
                + "         AND sng.destroy = 0\n"
                + "       GROUP BY sng.nft_template_id) > 0\n"
                + "ORDER BY price ASC, t.id ASC")
List<String> selectMarketNftAllSeriesOrderByGoodsPriceAsc();