Develop a set of queries as follows:
a. Find the module that has the most number of occurrences;
b. Find the total number of students on all occurrences of each module;
c. Show the number, name and credits of all modules, along with the average percentage
achieved by the students for each occurrence.
d. Show details of all student names and the titles of the modules in which they may have
e. Find the occurrences of modules where the number of students is below the average
number for occurrences of that module. Show the module number, year, block and
number of students.
Devise 5 further queries that test your design. Think about what sort of queries would be
generated by the College for the above scenario.
Credit will be given to queries that are not trivial, for example, “SELECT * FROM
Tablename” is unlikely to gain any marks. You should put into practice the advance
techniques seen in the Course Exercises for the module.