SQL上机练习.docVIP

USERA.EMP：员工信息 USERA.DEPT：部门信息 USERA.PROJ：项目信息 用以上这三个表完成下面的练习。(可先手动书写SQL语句，再到SPUFI环境下调试) Simple SQL Queries Problem 1. List employee number, last name, date of birth, and salary for all employees. The employees should be ordered by decreasing salaries. Problem 2. List last name, first name, and the department number for all employees. The listing should be ordered by descending department numbers. Within the same department, the last names should be sorted in descending order. Problem 3. List different education levels in the company in descending order. Problem 4. List all employees (employee number) and the projects (project number) performed by them. Problem 5. List last name, salary, and bonus of all male employees. Problem 6. List last name, salary, and commission of all employees with a salary higher than $20000 and hired after 1979. Problem 7. List last name, salary, bonus, and commission of all employees with a salary higher than $20000 and a bonus of $400 or of all employees with a bonus of $500 and a commission higher than $2000. The list should be ordered by last name. Problem 8. List last name, salary, bonus, and commission of all employees with a salary higher than $20000, a bonus of $400 or $500, and a commission higher than $2000. The list should be ordered by the lats name. Problme 9. For all ‘AD’ project (project number starts with ‘AD’) with activities 10, 80, and 180, list the following: Project number Activity number Starting date for activity End date for activity The list should be sorted by project number and activity number. Problem 10. List manager number and department number for all departments to which a manager has been assigned. The list should be ordered by manager numbers. Problem 11. List employee number, last name, salary, and bonus of all employees having a bonus from $800 to $1000. The lowest bonus should appear first. Problem 12. List employee number, last name, salary, and department number of all employees of departments A00 t