-- Fix Michael's company to match company_intel lookup
-- Primary company is LFCS (where he works as foreman)
-- RateRight is his own business (stored in metadata)

UPDATE leads
SET
  company = 'LFCS',
  metadata = COALESCE(metadata, '{}'::jsonb) || '{
    "trade": "Formwork & Steelfixing",
    "role": "Foreman",
    "also_owns": "RateRight"
  }'::jsonb
WHERE (first_name ILIKE '%michael%' AND last_name ILIKE '%loughlin%')
   OR (first_name ILIKE '%michael%' AND last_name ILIKE '%rocco%');
