Vancomycin-Resistant Enterococcus

-- Example column naming
CREATE TABLE claims (
  claim_id VARCHAR(50),
  vre VARCHAR(100),  -- Vancomycin-Resistant Enterococcus
  ...
);

-- Example in SELECT
SELECT 
  claim_id,
  vre as vancomycin-resistant_enterococcus
FROM claims;