Write a query to display the block number and number of departments in each block and give an alias as NO_OF_DEPT. Sort the result based on NO_OF_DEPT in descending. Refer the below schema diagram:...

Extracted text: Write a query to display the block number and number of departments in each block and give an alias as NO_OF_DEPT. Sort the result based on NO_OF_DEPT in descending. Refer the below schema diagram: College Management System(CMS) Department Student department_id number --> PK department_name varchar(30) department_block_number number student_id number --> PK student_name varchar(30) address varchar(40) city varchar(30) department_id number --> FK PK-- Primary Key FK-- Foreign Key Subject Staff staff_id number --> PK staff_name varchar(30) department_id number-> FK subject_id number->PK subject_name varchar(30) subject_code varchar(10) Istaff id number --> FK Mark value number subject_id number--> PK,FK student_id number-->PK,FK