โ† Cognizant questions

Fetch Names and Count of Professors

Filed under Cognizant

Write a SQL query to find the names of departments and the total count of professors in each, specifically filtering for departments where the professor count is strictly less than 5.

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Cognizant questions

Collected from public candidate posts and coding forums. Updated Nov 2026.