Percentage of Blocks Never Edited
Notion● MediumFULLTIMEPHONE SCREENProblem statement
Given all blocks and their edit history, return the percentage of distinct blocks that have no edit record.
Round the percentage to two decimal places and return one row with the column never_edited_percentage.
Table schema
MySQLPostgreSQLPandas
Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.
blocks
| Column | Type | Nullable | Description |
|---|---|---|---|
| block_idPK | Integer | No | — |
| created_at | Timestamp | No | — |
block_edits
| Column | Type | Nullable | Description |
|---|---|---|---|
| edit_idPK | Integer | No | — |
| block_id | Integer | No | — |
| edited_at | Timestamp | No | — |
Foreign key: block_id → blocks(block_id)
Expected result
Your query or function must return these columns.
| Column | Type | Nullable | Description |
|---|---|---|---|
| never_edited_percentage | Decimal | No | — |
Row order: must match exactly. Numeric tolerance: 0.
Constraints
- At least one block is present.
- A block with any number of edit rows counts as edited once.
- The percentage is
100 × unedited blocks / all blocks.