A college maintains department information in one table and student information in another table. Write a SQL query to display the number of students by major in descending order.