select s.* from s where S# in (select S# from sc group by S# having count(*) >= 5)
select S.S#,max(S.SD) SD from S join SC on S.S# = SC.S# group by S.S# having(count(1)) >= 5
34,587
社区成员
254,588
社区内容
加载中
试试用AI创作助手写篇文章吧