Zaineb :
nb posts:320
nb discussions:33
inscrit le :23-01-2015
le 04-02-2015 à 11:35:53
Correction
question1:
select employee_id num, first_name nom, D.department_id, department_name from employees E inner join departments D on E.department_id = D.department_id order by department_id, employee_id
select employee_id num, first_name nom, departments.department_id, departments.department_name from departments, employees where Employees.department_id = departments.department_id order by department_id, employee_id
Question2:
select employee_id, first_name, salary, d.department_id, department_name from employees E join departments D on E.department_id = D.department_id where salary > 10000 order by salary
Question3:
select D.department_id no, department_name nomdep, first_name nom, last_name prenom from departments D left join employees E on D.department_id = E.department_id
question4:
select D.department_id no, department_name nomdep, employee_id no, first_name nom, salary salaire from departments D right join employees E on D.department_id = E.department_id
Question 5:
select D.department_id, department_name, job_title, E.job_id from departments D full join employees E on (D.department_id = E.department_id) left join jobs J on (E.job_id = J.job_id)
question 6:
select E.employee_id num , E.first_name empNom , M.first_name manager from employees E join employees M on M.employee_id = E.manager_id
Question 7:
select E.employee_id num , E.first_name empNom , M.first_name manager from employees E left join employees M on M.employee_id = E.manager_id
Question 8:
select employee_id ID, first_name NOM, salary, C.department_id from (select department_id, min(salary)min, max(salary)max from employees group by department_id) C join employees E on E.salary between (C.min) and (C.max) order by C.department_id
En partenariat avec "Positive Technologies", Esprit a l'honneur d'inviter ses étudiants à la 1ère édition de l’événement ESPRIT HACK DAYS dans les locaux d'ESPRIT Chotrana 2 et ce le 03 et le 04 Mars 2015.
La direction des stages d’ESPRIT et Ernst & Young ont le plaisir d'inviter ses étudiants à la journée de l’entreprise du mercredi 4 mars 2015 dans la salle E5 d’ESPRIT Factory.