(5)List all courses that have over 2 credit hours or have more than 3 students.
(6)List all students who enrolled in the month of August.
(7)List student names along with the number of years they have been with the university.
(8)List student's information under user's request. [AC5.21-5.23]
(9)List students' name and address in ascending order with the state as the primary sort key and last name as the secondary sort key. [AC 3.12-3.17]
(10)Show student enrollment figures by state. [AC 3.34-3.37]
(11)Show distribution of courses taken by state. [AC 8.04-8.09]
(12)List all students living in the same city and state. [AC 8.09-8.11]
(13)List all students who currently are not taking any courses. [AC 8.11-13]
(14)Create a table called KYStudent that includes students from Kentucky only. [AC 8.16-20]
(15)Delete all KY students from the STUDENT table. [AC 8.23-26]
** Take table will be affected.Thus, create a table called KYTake first.
(16)Add all KY students back to the STUDENT table. [AC 8.20-8.23]
** Add the related records back to the Take table also.
(17)Update the Take table to include a letter grade for each record. [AC 8.26-8.30]
13.Create the following class list report:[AC4.18-4.32]
14.Create the following grade report: [AC 6.02-6.38]
