xrf archaeology

) Course ID (class_id) Course Name (class_name) Major in Flag (MAIN_CLASS_FLG) 100 1 Economics Y 100 2 Historical studies N 200 2 Historical studies N 200 3 Archaeology Y 200 4 Computer N 300 4 Computer N 400 5 Chemical N 5

200 3 Archaeology Y 200 4 Computer N 300 4 Computer N 400 5 Chemical N 500 6 Mathematical N Some students choose to take several courses at the same time (100,200) Some students choose only one course (300,400,500). Students taking multiple courses are asked to choose a course as their major, with t

aware of the null situation at this time.Six, use the aggregate function in the case functionSuppose you have one of the following tables School Number (STD_ID) Course ID (class_id) Course Name (class_name) Major in Flag (MAIN_CLASS_FLG) 100 1 Economics Y 100 2 Historical studies N 200 2 Historical studies N 200 3

Archaeology Y 200 4 Computer N 300 4 Computer N 400 5 Chemical N 500 6 Mathematical N Some students choose to take several courses at the same time (100,200) Some students choose only one course (300,400,500). Students taking multiple courses are asked to choose a course as their major, with the major flag writ