Well I have this assignment from my database class.
http://unix.rmit.edu.vn/~s3183636/debai.pdf
I have nearly finished everything except question 6th.
I wonder if anyone can help me answering it.
Don't worry, It's not for the mark because I've finished the other 9 questions so I can get like at least 80% mark already. I just feel like I need an answer for what I can not do T..T
I will be thankful a lot if someone can help me deal with this problem.
By the way, here is my sql query for 7th question ( since the requirement in 6th and 7th is exactly the same, but 7th allow us to use subquery while 6th doesn't)

SELECT acnum, givename, famname, count(panum)
FROM author natural join academic
WHERE panum in
(SELECT panum
FROM author natural join academic
WHERE famname='Makki'
and givename='Adam')
and deptnum in
(SELECT deptnum
FROM academic
WHERE famname='Makki'
and givename='Adam')
and famname!='Makki'
and givename!='Adam'
group by acnum, givename, famname;

Thank you in advance!!