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`.
Each hint you reveal reduces the XP you can earn. Try the query first.
Use `SELECT DISTINCT account_type FROM dim_accounts` to dedupe values.
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.