Quick Overview

Write a portable SQL query that returns every department with its student count, including departments with zero students. Sort counts descending and resolve ties deterministically by department name and identity.

Rank Departments by Student Count

Company: Oracle

Role: Software Engineer

Category: Data Manipulation (SQL/Python)

Difficulty: medium

Interview Round: Onsite

Overview: Write a portable SQL query that returns every department with its student count, including departments with zero students. Sort counts descending and resolve ties deterministically by department name and identity.

Loading…