How many positions have a maximum salary of no more than US$1000,000?
maximum salary of no more than US$1000,000 refers to maxsalary < '100000';
SELECT COUNT(*) FROM position WHERE CAST(REPLACE(SUBSTR(maxsalary, 4), ',', '') AS REAL) < 100000