I have the following Oracle code to convert to SQL but I am stuck, please help.
I know decode is like a case in SQL and greatest is like max ( not sure) but not sure how to convert this to SQL
(select decode(greatest(count(),2),count(),'Y','') ---Oracle
where h2.supervisor_id = ECV.EMPLID
and h2.empl_status in('A','L','S','P')
and h2.empl_type = 'H') AS Supervise_2_hourly,