Analyst Developer Interview Questions

1,016 analyst developer interview questions shared by candidates

Write an SQL query that calculates the number of distinct companies each candidate has applied to using two tables: candidates (containing candidate details) and reports (linking candidates to companies via test sessions). The result should include the candidate's id, name, and the count of unique companies they applied to, sorted by id in ascending order.
avatar

Analyst Developer

Interviewed at FNZ

3.2
Jan 29, 2025

Write an SQL query that calculates the number of distinct companies each candidate has applied to using two tables: candidates (containing candidate details) and reports (linking candidates to companies via test sessions). The result should include the candidate's id, name, and the count of unique companies they applied to, sorted by id in ascending order.

Viewing 321 - 330 interview questions

Glassdoor has 1,016 interview questions and reports from Analyst developer interviews. Prepare for your interview. Get hired. Love your job.