Your question is SQL Distinct Values Query. Start with the requirements and the one table 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.
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 |