Skip to content

Instantly share code, notes, and snippets.

@maulvi maulvi/soal no 1
Last active Sep 25, 2017

What would you like to do?
database minggu 3
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;
SELECT concat(first_name," ",last_name) as nama, (YEAR(hire_date)-YEAR(birth_date)) as umur
FROM employees group BY umur limit 5;
SELECT * FROM employees.salaries WHERE MONTH(from_date) = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.