Your question is Table A Not in Table B. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Grammarly Editor stores two snapshots of generated writing suggestions for a comparison job. Write a PostgreSQL query to return the complete rows that exist in grammarly_editor_suggestions_a but do not exist identically in grammarly_editor_suggestions_b.
suggestion_id in ascending order.NULL semantics correctly when comparing rows.| Column | Type | Description |
|---|---|---|
| suggestion_idPK | INTEGER | Unique suggestion identifier within snapshot A |
| document_id | INTEGER | Grammarly Editor document identifier |
| suggestion_type | VARCHAR(40) | Type of writing suggestion |
| surface_text | VARCHAR(120) | Text highlighted by the suggestion |
| severity | VARCHAR(20) | Suggestion severity |
| Column | Type | Description |
|---|---|---|
| suggestion_idPK | INTEGER | Unique suggestion identifier within snapshot B |
| document_id | INTEGER | Grammarly Editor document identifier |
| suggestion_type | VARCHAR(40) | Type of writing suggestion |
| surface_text | VARCHAR(120) | Text highlighted by the suggestion |
| severity | VARCHAR(20) | Suggestion severity |