Error: SELECT SALARY_RANGE_ID, SALARY_RANGE_NAME, SALARY_RANGE_RANK, ( SELECT COUNT( P_FORHOTEL ) from HOTEL_SURVEY_ROTARY where SALARY = SALARY_RANGE_ID ) AS num_people_salary
FROM
M_SALARY_RANGE
ORDER BY SALARY_RANGE_RANK
SQLSTATE[22018]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Conversion failed when converting the varchar value '1'"' to data type int.