SQL

Student Faculty Stuld lastName firstName major credits facID name departmentrankk $1001 S1002 S1005 S1010 F101 F105 F110 F115 F221 CSC 36 63 McCarthy OwenMatho 42 Chin Ann Math Burns Edward Art Smith $1013 S1015 S1020 Jones 9 Mary Math Enroll Class Stuld ClassNumber grade S1001 S1001 HST205A CSC201A ART103A MTH103C classNumber facld schedule room S1002 S1002C S1002 S1010 S1010 F101MWF9H221 F105 TuThF10 M110 ART103A CSC201A CSC203A HST205A MTH1018 F110 MTH103C F110 MWF11 H225 F115 MWF11 H221 CSC201A S1020 4. Find the maximum number of credits that any student has in each major 5. Find the major and the maximum number of credits above 50 that any student in each major has, providing the student has at least 30 credits. CE-GROUP BY, HAVING) What are the rules regarding the appearance of a column name in the SELECT, GROUP BY, or HAVING clauses. Give an example of a violation