Oracle SQL :

Write a command that retrieves the hold_id, hold_date, and expire_date columns from the hold_02 table in your tool library schema, followed by a column named days_between that uses an interval function to retrieve the number of days, hours, and seconds between the expire date and the hold date. Sort the rows by days_between column and only retrieve rows when the days-between value exceeds 2 days.

Below is hold_02 table

Please provide syntax

COLUMN NAME 1 HOLD ID 2 TOOL NO 3 TOOL DESC ID 4 EMPLOYEE ID 5 JOB ID 6 HOLD DATE 7 EXPIRE DATE 8 HOLD ACTIVE 9 HOLD STATUS CHANGE DATE DATE 10 HOLD DATE TS DATA TYPE NUMBER (8,0) NUMBER (8,0) NUMBER (8,0) NUMBER (8,0) NUMBER (8,0) DATE DATE VARCHAR2 (8 BYTE) NULLABLE DATA DEFAULT COLUMN IDCOMMENTS No No No No Yes No Yes No No Yes (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) 1 (null) 2 (null) 3 (null) 4 (null) 5 (null) 6 (null) 7 (null) (null) 9 (null) 10 (nul1) TIMESTAMP (6)