Table A Not in Table B | Dataford Interview Questions

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.

Requirements

Return rows based on complete row equality across all columns.
Include each result column and sort the output by suggestion_id in ascending order.
Preserve SQL NULL semantics correctly when comparing rows.

Schema

grammarly_editor_suggestions_a

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

grammarly_editor_suggestions_b

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

Your question is Table A Not in Table B. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem