database minggu 3

soal no 1

select employees.emp_no, first_name, last_name, count(dept_no) jml_dpt
from employees join dept_emp on employees.emp_no = dept_emp.emp_no
group by employees.emp_no, first_name, last_name
having count(dept_no) = 2;

soal no 3

SELECT concat(first_name," ",last_name) as nama, (YEAR(hire_date)-YEAR(birth_date)) as umur
FROM employees group BY umur limit 5;

wew

SELECT * FROM employees.salaries WHERE MONTH(from_date) = 1;