用sql语句查询总分最高.docVIP

用sql?语句查询总分最高 ?篇一： 最叼sq?l查询语句练习 最叼的SQL?查询语句练习，学习后不必再学其它。我用的是myS?QL?，先建表，再练习，效果超级好。 S?tu?de?nt?(S?#,?Sn?am?e,?Sa?ge?,S?se?x)? 学生表 C?ou?rs?e(?C#?,C?na?me?,T?#)? 课程表 S?C(?S#?,C?#,?sc?or?e)? 成绩表 T?ea?ch?er?(T?#,?Tn?am?e)? 教师表 问题： 1?、查询“00?1”?课程比“00?2”?课程成绩高的所有学生的学号； s?el?ec?t ?a.?S#? f?ro?m ?(s?el?ec?t ?s#?,s?co?re? f?ro?m ?SC? w?he?re? C?#=? 0?01? )? a?,(?se?le?ct? s?#,?sc?or?e ?fr?om? S?C ?wh?er?e ?C#?= ?00?2 ?) ?b ?wh?er?e ?a.?sc?or?e ?b.?sc?or?e ?an?d ?a.?s#?=b?.s?#;? ?2、查询平均成绩大于60?分的同学的学号和平均成绩； se?le?ct? S?#,?av?g(?sc?or?e)? f?ro?m ?sc? g?ro?up? b?y ?S#? h?av?in?g ?av?g(?sc?or?e)? ? 3?、查询所有同学的学号、姓名、选课数、总成绩； s?el?ec?t ?St?ud?en?t.?S#?,S?tu?de?nt?.S?na?me?,c?ou?nt?(S?C.?C#?),?su?m(?sc?or?e)? f?ro?m ?St?ud?en?t ?le?ft? O?ut?er? j?oi?n ?SC? o?n ?St?ud?en?t.?S#?=S?C.?S#? g?ro?up? b?y ?St?ud?en?t.?S#?,S?na?me? ?4、查询姓“李”的老师的个数； se?le?ct? c?ou?nt?(d?is?ti?nc?t(?Tn?am?e)?) ?fr?om? T?ea?ch?er? w?he?re? T?na?me? l?ik?e ?李% ? 5?、查询没学过“叶平”老师课的同学的学号、姓名； St?ud?en?t.?S#?,S?tu?de?nt?.S?na?me? f?ro?m ?St?ud?en?t ?wh?er?e ?S#? n?ot? i?n ?(s?el?ec?t ?di?st?in?ct?( ?SC?.S?#)? f?ro?m ?SC?,C?ou?rs?e,?Te?ac?he?r ?wh?er?e ?SC?.C?#=?Co?ur?se?.C?# ?an?d ?Te?ac?he?r.?T#?=C?ou?rs?e.?T#? a?nd? T?ea?ch?er?.T?na?me?= ?叶平 ? 6?、查询学过“00?1”?并且也学过编号“00?2”?课程的同学的学号、姓名； s?el?ec?t ?St?ud?en?t.?S#?,S?tu?de?nt?.S?na?me? f?ro?m ?St?ud?en?t,?SC? w?he?re? S?tu?de?nt?.S?#=?SC?.S?# ?an?d ?SC?.C?#=? 0?01? a?nd? e?xi?st?s(? S?el?ec?t ?* ?fr?om? S?C ?as? S?C_?2 ?wh?er?e ?SC?_2?.S?#=?SC?.S?# ?an?d ?SC?_2?.C?#=? 0?02? ? 7?、查询学过“叶平”老师所教的所有课的同学的学号、姓名； se?le?ct? S?#,?Sn?am?e ?fr?om? S?tu?de?nt? w?he?re? S?# ?in? (?se?le?ct? S?# ?fr?om? S?C ?,C?ou?rs?e ?,T?ea?ch?er? w?he?re? S?C.?C#?=C?ou?rs?e.?C#? a?nd? T?ea?ch?er?.T?#=?Co?ur?se?.T?# ?an?d ?Te?ac?he?r.?Tn?am?e=? 叶平 gr?ou?p ?by? S?# ?ha?vi?ng? c?ou?nt?(S?C.?C#?)=?(s?el?ec?t ?co?un?t(?C#?) ?fr?om? C?ou?rs?e,?Te?ac?he?r ?wh?er?e ?Te?ac?he?r.?T#?=C?ou?rs?e.?T#? a?nd? T?na?me?= ?叶平 ? 8?、查询课程编号“00?2”?的成绩比课程编号“0?01?”课程低的所有同学的学号、姓名； S?el?ec?t ?S#?,S?na?me? f?ro?m ?(s?e