【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“209.sql”一文,供大家参考学习
SELECT 编号,,
(高数+语文) AS 总成绩
FROM tb_stuScore09
WHERE (高数+语文) >150
UNION
SELECT a.编号,a.,
((a.语文成绩+a.数学成绩+a.英文成绩)+(b.语文成绩+b.数学成绩+b.英文成绩))/2
FROM tb_midsemester07 a,tb_final07 b
WHERE a.=b.
AND
((a.语文成绩+a.数学成绩+a.英文成绩)
+(b.语文成绩+b.数学成绩+b.英文成绩))/2>275
ORDER BY 总成绩 DESC