โ† Cognizant questions
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.