DISTINCT to find unique values in a column
Pre-audit check — give me every distinct `account_type` value in `dim_accounts`. I want to see the list exactly as it's stored, including any weird casing. Just one column: `account_type`.
| Column | Type | Key |
|---|---|---|
| account_id | INT | PK |
| account_code | TEXT | |
| account_name | TEXT | |
| account_type | TEXT | |
| is_active | INT |
Each hint you reveal reduces the XP you can earn. Try the query first.
You want a unique list of account types — no duplicates. Think about the SQL keyword that removes repeated values from a result set.
Do NOT apply LOWER() or TRIM() — Jordan wants to see the raw values to spot casing bugs.
You should see 7 distinct rows — one of them is a miscased duplicate.