1. a.

List the deptnum and total number of academics for CS departments, in alphabetical order of deptname. CS departments are departments whose deptname contains the phrase "Computer ... Science" or Computing Science in upper case or lower case letters. You must use the NATURAL JOIN operator.

b.

Return the research interest that has the largest number of interested academics. You must not use MAX. Note: An SQL query that lists all research interests in decreasing order of their total number of interested academics is incorrect.?

c.

The relational schema for the Academics database is as follows DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode) MIC(acnum, deptnum*, famname, givename, initials, title) PAPER(panum, title) AUTHOR(panum_acnum*) FIELD(fieldnum, id, title) INTEREST(fieldnum* acnum, descrip) Some notes on the Academics database An academic department belongs to one institution (instname) and often has many academics. An academic only works for one department. Research papers (PAPER) are often authored by several academics, and of course an academic often writes several papers (AUTHOR). A research field (FIELD) often attracts many academics and an academic can have interest in several research fields (INTEREST)