SELECT `ID` id, 
`FyerOrg_id` org_id,
`FyerYear` school_year,
`FyerProposedVendor` fyer_prop_vendor,
`FyerSaveName` fyer_save_name,
(CASE WHEN `FyerFinal` = 'Final' THEN 'Y' ELSE 'N' END) fyer_final,
`Survey_Date` survey_date,
`Upgrade_Date` upgrade_date,
(CASE WHEN `FyerGovtLease` = 0 THEN NULL ELSE `FyerGovtLease` END) fyer_govt_lease,
`Created` created_date,
`1 created_by,
`Modified` modified_date,
1 modified_by

FROM FYER_Group;