PPT Slide

column classname format a20;

select s.studentid, s.studentname,

sc.classid, c.classname

from student s, stud_class sc, a_class c

where s.studentid = sc.studentid

and sc.classid = c.classid

order by s.studentname, sc.classid;