Question

Write a query to display the name of the department that has the maximum student count.

Answer 1

$\tt\it\bf\it\bm{\mathcal{\fcolorbox{blue}{yellow}{\red{Answer:-}}}}$

________________________

Select name from Department

where MAX(Student count)

________________________

Answer 2

Explanation: Use join and sub-query