Notion·Software Engineer·Technical Phone Screen
- Given a blocks table and an edit_events table, write a SQL query to find the percentage of blocks that have never been edited.
“I went with a LEFT JOIN approach, grouped by block_id, counted edits per block, then wrapped it in an outer query with a CASE WHEN to flag zero-edit blocks.”