Write SQL query to solve given problem: Does Thomas Carnes have an account on ballotpedia.org?. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT CASE WHEN ballotpedia_id IS NULL THEN 'doesn''t have' ELSE 'have' END AS HaveorNot FROM historical WHERE first_name = 'Thomas' AND last_name = 'Carnes'