1、
delete from score where score < 60 ;
2、
select count(*)
from teacher where tname like '李%' ;
3、
select
row_number() over(order by s.score desc) rn,
(select sname from student st where st.sno=s.sno) sname,
score
from s
1、
delete from score where score < 60 ;
2、
select count(*)
from teacher where tname like '李%' ;
3、
select
row_number() over(order by s.score desc) rn,
(select sname from student st where st.sno=s.sno) sname,
score
from s