Reported in a candidate post, Sep 2024
SQL queries: string prefix, grouping, and joins
Filed under Cognizant
The question
Write SQL queries for a given table schema to: find names starting with 'A', list distinct departments, count employees per department, join an events table on EmpID to list participants, and extract the first 3 or 4 letters of names.
No write-up yet. Related questions below have one.
Related Cognizant questions
Collected from public candidate posts and coding forums. Updated Nov 2026.