MySQL IN 두 컬럼 이상 비교

SELECT *
FROM TAB1
WHERE
  (NAME, AGE) IN 
    (SELECT DISTINCT NAME, MAX(AGE)
     FROM TAB1
     GROUP BY JOB)
-- ORDER BY JOB

WHERE (조건1, 조건2) IN (비교조건1, 비교조건2)