Qual o comando com a cláusula SELECT, dentre os abaixo, que está correto?

SELECT JOB | DEPT FROM Q.STAFF

SELECT JOB, CONCAT (DEPT) FROM Q.STAFF

SELECT JOB, CONCAT (DEPT) FROM Q.STAFF

SELECT (JOB, DEPT) FROM Q.STAFF