1. For each department and each rank within each department, list the department, rank and the number of faculty members (i.e., how many) whose age is between 30 and 40. Arrange the outcome by the number of faculty members so that the largest number comes first.

2. How many faculty members does the faculty (ID 654-32-1098) supervise? List his/her last name and the number of faculty members (i.e., how many) he/she supervises.

QTTTDFNT - Standing (FR, SO, JR or SR ) FACTT.TV - Department (BINS, MGMT, ECON, MKTG, ACCT or FINC) - Rank (Assistant, Associate or Full) COURSE FNR OT.T.MFNT