...
Purge the data from the spreadsheet
Note : a sample copy of this report is provided in the attachment section
Step 3
Execute this code
...
SELECT Y02.AIRCRAFT_MARK_ID MRK ,
Y02.TC_REGION_CD || ' - ' || TR02.TC_REGION_ETXT || ' ' REGION ,
DECODE( (SELECT COUNT(Y93.AIRCRAFT_ID) FROM Y93_CCARCS_PREVIOUS_DAY Y93
WHERE Y93.AIRCRAFT_ID = Y02.AIRCRAFT_ID),1,'Y','N') REGD ,
...