staff的定义如下 id INTEGER name CHAR(20) dept INTEGER job CHAR(20) years INTEGER salary DECIMAL(10,2) comm DECIMAL(10,2) 下面哪个语句可以按照job和salary的升序排序来返回所有员工的

ASELECT id,name,salary,dept,job,years,comm FROM staff ORDER BY 4,6

BSELECT id,name,salary,dept,job,years,comm FROM staff GROUP BY 4,6

CSELECT id,name,salary,dept,job,years,comm FROM staff ORDER BY 5,3

DSELECT id,name,salary,dept,job,years,comm FROM staff GROUP BY 5,3