Write a SQL query to find the distinct values in a column.
Use the records.category column. Include each unique non-NULL value and the NULL value if it exists.
category valuedistinct_category| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Unique record identifier |
| category | VARCHAR(100) | Category value to inspect for distinct values |