Question

2. Consider the following database and answer the questions below SPORT ENROLLMENT STUDENT COURSE ST ST TITLE 313 1313 50s0 Basketbal 8989 Basketbal 007 COMP203A 7007 COMP20e 007 ames Bond 302 Database Systems COMP203 Computer Or n Brown 00 CoMP302 A o0 3un SmuCOMP42daedDatabase Systems 3 13 COMP 209 70 5050 Susan Smith COMP447 nced Database S 1313 COMP2O3A 1313 COMP302 5050 COMP20 C 1313 COMP42 7007 Write the SQL statement that displays the names of the students who have enrolled in the "Database Systems" course a) b) Write the SQL statement that displays a list of the students whose names start with S c) Write the SQL statement that displays the Student ID, Student Name, Course ID, and Grade for students who passed at least one course with a grade better than B+ (i.e. A-, A, and A+) d) Write the SQL statement that displays the total number of credit hours for the courses enrolled in by the student with ID 1313.

Answer 1

SELECT STUDENT STNAHE FRON CC STUDENT THINER JOLN SNROLLHENT ON ENROLL MENT COURsETD STUDENT, gunDRST STID) STUDENT ST.TD) · SELECT . st.NAHE FRory STUDENT WHERE SELECT STODENT SLED, STUDEAT. S1 NANE, STUDENT STED İOHERE ENRO LL rJE ,IT.GRADEこ A.OR A OR A ャ e) SELECT count () SELECT Ceset (n) IINER TOTN ENROLLMENT ON ENROLLNENT SLID WHERE CpoRT. SPORT. NAME "Basketba :

Select s.s id sest nome いhene.Ass.d n 9) Pnom ENTallment e ( Select p.stid 유elett gt.td ondet.name honngtudent, tabe ohene st.id ot gtudent table pmesent in st.id of enmollment table ushere st.tarf student % egual, toat. dde enolinen and Cat.fa ot tdat takk not phest at f 6 tudent Pa aqual et.ta