sql练习(国外英语资料).docVIP

sql练习 Second chapters 1. displays all the information for department tables SELECT * FROM departments; 2. display department number, department name SELECT department_id, Department_name FROM departments; 3. displays the following field and string connections: employee name, 1 months salary: salary. Such as: Amy 1 months salary: 8000 SELECT first_name||||last_name|| a months salary is:||salary FROM employees; 4. show the employees name, work time and work SELECT first_name, Hire_date, Job_id FROM employees emp; 5. display employee name: alias Name, annual salary (13 months monthly salary): ali