create table employees
(ID_NUMBER NUMBER Primary Key,
NAME VARCHAR2 (30),
DEPARTMENT_ID NUMBER,
SALARY NUMBER (7,2),
HIRE_DATE DATE);
Insert into employees valyes
(1,'Rachel',7345,30000,'19-09-2001');
SELECT id_number, name, department_id, SUM(salary)
FROM employees
WHERE salary > 25000
GROUP BY department_id, id_number, name
ORDER BY hire_date;
Y3JlYXRlIHRhYmxlIGVtcGxveWVlcwooSURfTlVNQkVSIE5VTUJFUiBQcmltYXJ5IEtleSwKTkFNRSBWQVJDSEFSMiAoMzApLApERVBBUlRNRU5UX0lEIE5VTUJFUiwKU0FMQVJZIE5VTUJFUiAoNywyKSwKSElSRV9EQVRFIERBVEUpOyAKCkluc2VydCBpbnRvIGVtcGxveWVlcyB2YWx5ZXMKKDEsJ1JhY2hlbCcsNzM0NSwzMDAwMCwnMTktMDktMjAwMScpOwogClNFTEVDVCBpZF9udW1iZXIsIG5hbWUsIGRlcGFydG1lbnRfaWQsIFNVTShzYWxhcnkpCkZST00gZW1wbG95ZWVzCldIRVJFIHNhbGFyeSA+IDI1MDAwCkdST1VQIEJZIGRlcGFydG1lbnRfaWQsIGlkX251bWJlciwgbmFtZQpPUkRFUiBCWSBoaXJlX2RhdGU7Cg==