Oracle 12c Sql Hands-on Assignments Solutions

Alternative using MAX subquery :

SELECT last_name, salary * 12 AS "Annual Salary" FROM employees WHERE department_id = 20 ORDER BY "Annual Salary" DESC; Use code with caution. Copied to clipboard oracle 12c sql hands-on assignments solutions

INSERT INTO EMPLOYEES (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, DEPARTMENT_ID) VALUES (10, 'Lisa', 'Davis', 5); Alternative using MAX subquery : SELECT last_name, salary

-- Members who borrowed book 101 only SELECT member_id FROM borrowing WHERE book_id = 101 MINUS SELECT member_id FROM borrowing WHERE book_id = 102 UNION -- Members who borrowed book 102 only SELECT member_id FROM borrowing WHERE book_id = 102 MINUS SELECT member_id FROM borrowing WHERE book_id = 101; DEPARTMENT_ID) VALUES (10