Oracle 12c Sql Hands-on Assignments Solutions -

INSERT INTO members (member_id, full_name, email) VALUES (202, 'Jane Smith', 'jane@example.com');

-- 1. Overdue calculation (assuming 14-day loan period) SELECT b.title, m.full_name, br.borrow_date, (SYSDATE - br.borrow_date) AS days_out, CASE WHEN (SYSDATE - br.borrow_date) > 14 AND br.return_date IS NULL THEN (SYSDATE - br.borrow_date) - 14 ELSE 0 END AS overdue_days FROM borrowing br JOIN books b ON br.book_id = b.book_id JOIN members m ON br.member_id = m.member_id; oracle 12c sql hands-on assignments solutions