lab10_bd | Sql | Databases

lab 4 ex 3 select min_salary "salariu min",max_salary "salariu max", max_salary+min_salary "Suma",(max_salary+min_salary)/2 "media" from jobs; ex 4 select job_id, count(emloyee_id) from emloyees !rou by job_id; ex  select count( distinct mana!er_id) "#r$%ana!eri" from emloyees

ex & select max(max_salary)' min(min_salary) "diferenta" from jobs; ex  select deartment_name,location_id, count(emloyee_id) "nr an!ajati" from deartments d,emloyees e *ere d$deartment_ide$deartment_id !rou by d$deartment_name,d$location_id

ex  select emloyee_id, last_name,a-!(salary) from emloyees *ere salary.(select a-!(salary) from emloyees) !rou by emloyee_id, last_name order by a-!(salary) desc ex  select mana!er_id,min(salary) from emloyees *ere mana!er_id is not null *a-in! min(salary).0111 !rou by mana!er_id ex 01 select d$deartment_id, d$deartment_name,max(e$salary) "salariu maxim" from deartments d join emloyees e on (d$deartment_ide$deartment_id) join jobs j on (e$job_idj$job_id) *ere j$max_salary.3111 !rou by d$deartment_id, d$deartment_name; ex 00 select min((max_salary+min_salary)/2) from jobs; select min(a-!(salary)) from emloyees !rou by mana!er_id; //00

ex02 select d$deartment_id, d$deartment_name, sum(e$salary) "Suma" from deartments d join emloyees e on (e$deartment_idd$deartment_id) *ere d$deartment_ide$deartment_id !rou by d$deartment_id, d$deartment_name; ex 03 select d$deartment_id, d$deartment_name, max(e$salary) "%" from deartments d join emloyees e on (e$deartment_idd$deartment_id) *ere d$deartment_ide$deartment_id !rou by d$deartment_id, d$deartment_name; //i!nora -alorile null, dar nu ot !asi o solutie care sa imi reol-e roblema

ex 04 select job_id,job_title, (min_salary+max_salary)/2 from jobs *ere (min_salary+max_salary)/2(select min((min_salary+max_salary)/2) from jobs) select job_id,job_title,a-!(salary) from emloyees e join jobs j usin! (job_id) *a-in! a-!(salary)(select min(a-!(salary)) from emloyees !rou by job_id) !rou by job_id,job_title; //rof ex 0 select a-!(salary) from emloyees *a-in! a-!(salary).211 ex 0& select deartment_id,job_id,sum(salary) from emloyees !rou by deartment_id,job_id; ex 0 select deartment_id,deartment_name, min(salary) from deartments join emloyees usin! (deartment_id) *a-in! a-!(salary)(select max(a-!(salary)) from emloyees !rou by deartment_id) !rou by deartment_id,deartment_name;

ex 0(a) select deartment_id, deartment_name, count(emloyee_id) from emloyees full outer join deartments usin! (deartment_id) *a-in! count(emloyee_id)54 !rou by deartment_id,deartment_name; ex 0 select deartment_id, deartment_name, count(emloyee_id) from emloyees ri!*t outer join deartments usin! (deartment_id) *a-in! count(emloyee_id)54 !rou by deartment_id,deartment_name;

ex 21 select count(count(d$deartment_name)) from deartments d join emloyees e on (e$deartment_idd$deartment_id) *ere d$deartment_ide$deartment_id *a-in! count(e$emloyee_id).0 !rou by d$deartment_name

lab 01 select count(6) from emloyees *ere mana!er_id is not null !rou by mana!er_id

//tr fct de functii a-em ne-oie de !rou by (din rima fct) //fct de fct fara alte coloane //e doar tr select 789: b 0?@#A () ex 23 select city, deartment_id, deartment_name,job_id, sum(salary) from emloyees ri!*t join deartments usin!(deartment_id) left join locations usin!(location_id) *ere deartment_id.1 !rou by city, deartment_id,deartment_name, job_id