Question

plz help me this little assignmnet

ENROLL
ClassCode	StudID	Enrollment Date	Grade
CL001	PP001	9/1/2017
CL002	PP001	9/1/2017
CL003	PP001	9/1/2017
CL009	AA001	9/1/2017
CL010	AA001	9/1/2017
CL004	WS001	9/1/2017
CL005	AB001	9/1/2017
CL006	AB001	9/1/2017
CL008	AB001	9/1/2017
CL009	JE001	9/1/2017
CL010	JE002	9/1/2017
CL001	JE002	9/1/2017
CL004	LC001	9/1/2017
CL008	JM001	9/1/2017
CL009	MB002	9/1/2017
CL006	MG001	9/1/2017
CL005	AA002	9/1/2017
CL006	AA002	9/1/2017
CL003	KN001	9/1/2017
CL010	CA001	9/1/2017 Create update queries that will change the grades for the following students and classes: StudID ClassCode           Grade PP001 CL001                    A PP001 CL002                    B AA001 CL009                   B+ JE001 CL009                    C KN001   CL003                    F You only need to include the update queries in the Word document. Using Management Studio, enter grades for all the other rows in the Enroll table. After all the grades have been entered, create a query that returns Student Last Name, Student First Name, Course Title, Grade, and Number of Credits. Sort by

Answer 1

If you have any doubts, please give me comment...

-- Create update queries that will change the grades for the following students and classes:

-- StudID ClassCode Grade

-- PP001 CL001 A

-- PP001 CL002 B

-- AA001 CL009 B+

-- JE001 CL009 C

-- KN001 CL003 F

UPDATE ENROLL SET Grade = 'A' WHERE StudID ='PP001' AND ClassCode = 'CL001';

UPDATE ENROLL SET Grade = 'B' WHERE StudID ='PP001' AND ClassCode = 'CL002';

UPDATE ENROLL SET Grade = 'B+' WHERE StudID ='AA001' AND ClassCode = 'CL009';

UPDATE ENROLL SET Grade = 'C' WHERE StudID ='JE001' AND ClassCode = 'CL009';

UPDATE ENROLL SET Grade = 'F' WHERE StudID ='KN001' AND ClassCode = 'CL003';

-- After all the grades have been entered, create a query that returns Student Last Name, Student First Name, Course Title, Grade, and Number of Credits. Sort by Students Last Name

SELECT S.LastName, S.FirstName, C.Title, E.Grade, C.Credits

FROM Student S, ENROLL E, Course C, Class CL

WHERE S.StudID = E.StudID AND E.ClassCode = CL.ClassCode AND CL.CourseCode = C.CourseCode

ORDER BY S.Lastname;