- sql查询的问题,求解Thefollowingistherela
- The follog is the relational database schema for Northwoods University
Student Registration Database:
Write a SQL query to find all students’ first and last name and their grade for the course
named as Database Programming.
写出sql查询语句:查找course name为Databa
- select S_LAST,S_FIRST,GRADE FROM STUDENT S,ENROLLMENT E
WHERE S.S_ID=E.S_ID
AND E.C_SEC_ID=COURSE SECTION.C_SEC_ID
AND COURSE SECTION.COURSE_ID IN
(SELECT C.COURSE_ID FROM COURSE C WHERE C.COURSE_NAME='Database Programming')