Person + Organization

SELECT
    FIRST_NAME_PER,
    LAST_NAME_PER,
    EMAIL_ADDRESS_PER,
    JOB_TITLE_PER,
    COMPANY_NAME_ORG,
    INDUSTRY_LINKEDIN_ORG,
    EMPLOYEE_COUNT_MAX,
    HEADQUARTERS_STATE_NAME_ORG
FROM RELEASE.VELOCITY_BASE_UNLIMITED_LATEST
WHERE JOB_LEVEL_PER IN ('VP', 'Director', 'C-Suite')
  AND INDUSTRY_LINKEDIN_ORG LIKE '%Software%'
  AND EMPLOYEE_COUNT_MAX BETWEEN 100 AND 1000
  AND HEADQUARTERS_COUNTRY_NAME_ORG = 'United States'
ORDER BY EMAIL_LAST_VERIFIED_AT_PER DESC
LIMIT 500;

SELECT
    FIRST_NAME_PER,
    LAST_NAME_PER,
    EMAIL_ADDRESS_PER,
    JOB_TITLE_PER,
    COMPANY_NAME_ORG,
    EMPLOYEE_COUNT_RANGE_ORG,
    INDUSTRY_LINKEDIN_ORG,
    HEADQUARTERS_CITY_ORG,
    HEADQUARTERS_STATE_NAME_ORG
FROM RELEASE.VELOCITY_BASE_UNLIMITED_LATEST
WHERE JOB_FUNCTION_PER = 'Marketing'
  AND EMPLOYEE_COUNT_MAX >= 200
  AND EMAIL_LAST_VERIFIED_AT_PER >= DATEADD(day, -60, CURRENT_DATE())
ORDER BY COMPANY_NAME_ORG, LAST_NAME_PER;