mattsornson

CASE
  WHEN employees >= 500 THEN 50
  WHEN employees >= 100 THEN 40
  WHEN employees >= 50 THEN 10
  WHEN employees >= 25 THEN 5
  WHEN employees >= 10 THEN 3
  ELSE -2
END
+
CASE

mattsornson

Information Technology & Services
Marketing
Internet
Software
Education
Construction
Real Estate
Management Consulting
Financial Services
Recruiting

mattsornson

[
  {
    "id": "f565e697-b246-402c-bb2c-3c30fd948336",
    "name": {
      "givenName": "Renee",
      "familyName": "Stroebel",
      "fullName": "Renee Stroebel"
    },
    "title": "Risk Analyst, Head of Investor Analytics at BlueMountain Capital Management",
    "email": "rstroebel@bluemountaincapital.com",