SELECT RPAD(id, 13) As "TransactionID",
RPAD(StartDateTime, 9) As "StartRent",
NVL(RPAD(EndDateTime, 9), 'Rented') As "EndRent"
FROM TRANSACTION;
