mysql 查询 按条件求和 排序

MSSQL里：

select t_no,sum_value=sum(t_value) from t

group by t_no

order by sum_value desc

已知表一，用什么语句能把数据写入表2

分数 FROM 表1 WHERE 考试科目=' AND 表2.姓名数学'.姓名 = 表1语文',数学)

SELECT 姓名

INSERT INTO 表2(语文)

SELECT 分数 FROM 表1 WHERE 考试科目='INSERT INTO 表2(姓名

SELECT userid,sum(onlineTimeLong) FROM u_onlinetimelong

group by userid

order by sum(onlineTimeLong)

---