The salary raise for the other employees was_________ .
举一反三
- The salary raise for the other employee was A: 2% B: 5% C: 6% D: 10%
- 表employees中有字段title表示职务,字段salary表示工资,求各个职务平均工资的T-SQL语句是( )。 A: SELECT AVG(SALARY) FROM EMPLOYEES WHERE TITLE B: SELECT AVG(SALARY) FROM EMPLOYEES GROUP BY TITLE C: SELECT AVG(TITLE) FROM EMPLOYEES GROUP BY SALARY D: SELECT SALARY FROM EMPLOYEES GROUP BY TITLE
- 下面哪个语句关于GROUP BY 和HAVING语句的使用是正确的?() A: A.SELECT JOB_ID , DEPARTMENT_ID , AVG(SALARY)FROM EMPLOYEES GROUP BY JOB_IDHAVING AVG(SALARY) > 3000; B: B.SELECT JOB_ID , DEPARTMENT_ID , AVG(SALARY)FROM EMPLOYEES GROUP BY JOB_ID ,DEPARTMENT_IDHAVING AVG(SALARY) > 3000; C: C.SELECT JOB_ID , DEPARTMENT_ID , AVG(SALARY)FROM EMPLOYEES GROUP BY AVG(SALARY)HAVING AVG(SALARY) > 3000; D: D.SELECT JOB_ID , DEPARTMENT_ID , AVG(SALARY)FROM EMPLOYEES GROUP BY JOB_ID , DEPARTMENT_IDHAVING SALARY > 3000;
- 下面哪个语句关于GROUP BY 和HAVING语句的使用是正确的是?() A: SELECT<br/>JOB_ID, DEPARTMENT_ID, AVG(SALARY) FROM EMPLOYEES GROUP BY JOB_ID<br/>HAVING AVG(SALARY) > 3000; B: SELECT<br/>JOB_ID, DEPARTMENT_ID, AVG(SALARY) FROM EMPLOYEES GROUP BY JOB_ID,<br/>DEPARTMENT_ID HAVING AVG(SALARY) > 3000; C: SELECT<br/>JOB_ID, DEPARTMENT_ID, AVG(SALARY) FROM EMPLOYEES GROUP BY<br/>AVG(SALARY) HAVING AVG(SALARY) > 3000; D: FROM<br/>EMPLOYEES GROUP BY JOB_ID, DEPARTMENT_ID HAVING SALARY > 3000;
- 由于教育背景和工作经验不同,员工的薪水也大不相同。 A: Salary varies significantly, depended on the employees’ educational backgrounds and work experience. B: Salary varies greatly, depending on the employees’ educational backgrounds and work experience. C: Salary varies tremendously, depends on the employees’ educational backgrounds and work experience. D: Salary varies significantly, depending on the employers’ educational backgrounds and work experience.