title: Write a query to display the name of the department that has the maximum student count
body: <p><a href="https://i.stack.imgur.com/DrZ8j.jpg" rel="nofollow noreferrer">this is the schema </a>Write a query to display the name of the department that has the maximum student count.</p>
  
  <p>this is what is tried.</p>
  
  <pre><code>select d.department_name,count(s.student_id)
       from department d left join student s
       on d.department_id=s.department_id 
       group by d.department_name,d.department_id
       order by d.department_name;
  </code></pre>
  
  <p>and i think there is something missing in my code</p>