select student_id, RegNo, AdmissionNo, AdmissionDate, DOJ, HostelCategory_Id_alloted, Route_Id_alloted, StageId_alloted, 
(CASE WHEN DOJ between '2012-10-01' and '2012-10-30' THEN 'NEW' ELSE 'OLD' END) AS AdmissionType, 
(CASE WHEN HostelCategory_Id_alloted is null THEN 'N' WHEN HostelCategory_Id_alloted = -1 THEN 'N' ELSE 'Y' END) AS IsHostel, 
(CASE WHEN Route_Id_alloted is null and StageId_alloted is null THEN 'N' WHEN Route_Id_alloted = -1 and StageId_alloted = -1 THEN 'N' ELSE 'Y' END) AS IsTransport 
from admission_reg where doj is not null