create table employees
(ID_NUMBER NUMBER Primary Key,
NAME VARCHAR2 (30),
DEPARTMENT_ID NUMBER,
SALARY NUMBER (7,2),
HIRE_DATE DATE);
SELECT id_number, name, department_id, SUM(salary)
FROM employees
WHERE salary > 25000
GROUP BY department_id, id_number, name
ORDER BY hire_date;
Y3JlYXRlIHRhYmxlIGVtcGxveWVlcwooSURfTlVNQkVSIE5VTUJFUiBQcmltYXJ5IEtleSwKTkFNRSBWQVJDSEFSMiAoMzApLApERVBBUlRNRU5UX0lEIE5VTUJFUiwKU0FMQVJZIE5VTUJFUiAoNywyKSwKSElSRV9EQVRFIERBVEUpOyAKIApTRUxFQ1QgaWRfbnVtYmVyLCBuYW1lLCBkZXBhcnRtZW50X2lkLCBTVU0oc2FsYXJ5KQpGUk9NIGVtcGxveWVlcwpXSEVSRSBzYWxhcnkgPiAyNTAwMApHUk9VUCBCWSBkZXBhcnRtZW50X2lkLCBpZF9udW1iZXIsIG5hbWUKT1JERVIgQlkgaGlyZV9kYXRlOwo=