SQL: Employees Who Completed Projects Lasting >90 Days

Phone ScreenSnowflakeLast reported June 2026Low Frequency

Reported: 1× across candidate reports
First seen: June 2026
Last reported: June 2026
Reported outcome: unknown

Problem Overview

Given a database with employee and project information, write a SQL query to return the names of employees who have ever completed a single project that lasted more than 90 days. The project…

1 candidate-reported follow-up — the exact probes interviewers asked, with the trigger for each
The rest of the problem statement — full requirements, constraints, and edge cases
Approach and trade-offs — what passing candidates did, and the mistakes that sink people

Unlock the full Snowflake catalog

Full problem statements, candidate-reported follow-ups, and walkthroughs — for every Snowflake question.

Unlock with Pro

Already a member? Sign in

Verified Source

Every question is reconstructed from multiple independent candidate reports. Verbatim follow-ups, not invented ones.

Codex Fact-Checked

Technical claims, formulas, and scale numbers are reviewed against primary sources.

Interviewer Follow-ups

The exact follow-ups reported by candidates, with the trigger that prompts each one — plus the mistakes that sink people.