2个回答

1\select a.bj,b.xk,b.score from stu a
left inner join sco b on b.xh=a.xh
group by a.bj,b.xk
2、select a.xh,a.bj,b.xk,b.score from stu a
left inner join sco b on b.xh=a.xh
where b.score<'60'
3\select dinstinct a.xh,a.bj,b.xm from stu a
left inner join sco b on b.xh=a.xh
where b.score is NULL
3\select a.bj,b.xk,avg(b.score) c1 from stu a
left inner join sco b on b.xh=a.xh
group by a.bj,b.xk
order by c1 desc

1、
select a.bj, b.xk, avg(b.cj) as pjcj
from xsxxb a
inner join cjb b
on a.xh = b.xh
group by a.bj, b.xk
order by a.bj, b.xk;

2、
select a.bj, b.xk, a.xh, a.xm, b.cj
from xsxxb a
inner join cjb b
on a.xh = b.xh
where b.cj < 60
order by a.bj, b.xk, a.xh;

3、
select a.bj, a.xh, a.xm
from xsxxb a
left join cjb b
on a.xh = b.xh
where b.xh is null;

4、
select a.bj, b.xk, avg(b.cj) as pjcj
from xsxxb a
inner join cjb b
on a.xh = b.xh
group by a.bj, b.xk
order by b.xk, avg(b.cj) desc;

-
oracle 11g安装不上跪求大神帮忙解决
-
oracle sql求大神教育
-
Oracle恢复dmp文件报错问题，请大神帮忙看一下。
-

-

-
oracle问题跪求大神解答！！！
-
Oracle触发器的问题求大神帮忙解决
-
oracle问题，哪位大神帮忙解答一下喽，谢谢！
-
oracle登录时出现“ORA-03114:未连接到ORACLE”求各位大神相助！！
-
oracle语句求大神解释
-

-
oracle监听启动不来，修改了配置之后，不知道怎么办，头都炸了！！！！求大神帮忙！！
-
[oracle] 求9月份连续两天打电话的记录，求大神帮忙 纠结一天了
-
oracle性能问题，是否有大神帮忙解答！万分感激！！
-

-

-
oracle添加字段not null的问题，求大神解答
-
oracle导入数据问题，请大神帮忙
-

《C++ Primer》学习笔记/习题答案 总目录

GitHub开源的10个超棒后台管理面板

100 个网络基础知识普及，看完成半个网络高手

C语言实现推箱子游戏