原神表新查询

脚底儿

于 2024-06-27 15:46:34 发布

阅读量160

点赞数 4

文章标签： sql 数据库 mysql

本文链接：https://blog.youkuaiyun.com/weixin_46729014/article/details/140015476

版权

SELECT 
    u.userName,
    wt.weapon_type,
    AVG(w.rarity) AS avg_rarity
FROM 
    user u
JOIN 
    weapon w ON u.weapon_id = w.id
JOIN 
    weapon_type wt ON w.weapon_type_id = wt.id
GROUP BY 
    u.userName, wt.weapon_type
ORDER BY 
    u.userName, avg_rarity DESC;