The schema of the DB is as follows:
Department(DeptNum, Descrip, Instname, DeptName, State, Postcode)
Academic(AcNum, *DeptNum, FamName, GiveName, Initials, Title)
Paper(PaNum, Title)
Author(*PaNum, *AcNum)
Field(FieldNum, ID, Title)
Interest(*FieldNum, *AcNum, Descrip)
Question 1:
Which fields have interests shared by academics from the same department? Output the field number, field ID and title, and the
total number of academics who have interests.
Attachment:- academics-mysql.zip