Choice? C.Cno, s.Sname, s.Sno, how many people were selected? From where? Sure? c?
Left? Join? SC? Open? c.cno=sc.cno?
Left? Join? Student? s? Open? s.Sno=SC。 Sno
Left? Join? (choose? c.cno,? Count (s.Sno)? How many students are registered? From where?
Sure? c? Left? Join? SC? Open? c.cno=sc.cno?
Left? Join? Student? s? Open? s.Sno=SC。 Sno?
Group? By who? c.Cno)? As? t? Open? t Cno = c Cno