Solutionunvalidated
FROM tableName GROUP BY realm_id. Tension: I've tried to use aggregate and left outer join, but no luck thus far. Outcome: THEN 'active' ELSE 'inactive' END AS status FROM tableName GROUP BY realm_id order by realm_id.
69381c9b-f481-4c66-9ebf-ceecbbf956ea
FROM tableName GROUP BY realm_id. Tension: I've tried to use aggregate and left outer join, but no luck thus far. Outcome: THEN 'active' ELSE 'inactive' END AS status FROM tableName GROUP BY realm_id order by realm_id.