sql练习（国外英文资料）.doc

sql练习（国外英文资料） The second chapter Show the full information of the department table SELECT * FROM the departments; Display department number, department name The SELECT department_id, department_name FROM the departments; Display the following fields and strings: employee name, one months salary: salary. Amys salary for a month is 8000 SELECT first_name | | | | last_name | a months salary: | | salary The FROM employees. Display employees name, take part in working hours, work The SELECT first_name, Hire_date, job_id The FROM employees emp; Display employee Name: alias Name, annual salary (13 months monthly salary) : alias is annual salary. Note: alias case SELECT first_name Name, Salary * 13 annual salary The FROM employees. Display the employee name, job, as a string SELECT first_name | | | | last_name | | job_id The FROM employees. Displays the following fields and strings: the name of the employee, s job is, the work name. Amys job is MANAGER note: single quotes need to be displayed SELECT first_name | | . | | last_name | s job is | |, | job_id MANAGER The FROM employees. Show the middle door number of the employee, the name of the job, and ask for the duplicate SELECT DISTINCT department_id, job_id The FROM employees. The third chapter Show number 10, department name The SELECT department_id, department_name FROM the departments WHERE department_id = 10 Show the names of the employees who joined the work in the past 82 years The SELECT first_name, Last_name, Hire_date, job_id The FROM employees WHERE hire_date to_date ( 98 , yy); Show the employee name of the employee named Ellen and take part in the working hours and the name of the job The SELECT first_name, Hire_date, job_id The FROM employees WHERE the first_name = Ellen Show employees names, salaries, between 2000 and 4000 The SELECT employee_id, salary The FROM employees WHERE salary BETWEEN 2000 AND 2000 Show the general managers name SELECT first_name | | | | last_name The FROM employees WHERE manager_