Cek Aktif SMS

SELECT DISTINCT d.name, t.code
FROM placement_test p, department d, term t
WHERE p.department_id = d.id
and p.term_id=t.id
order by d.name,t.code