题解 | #查找employees表emp_no与last_name的员工信息#

select
a.emp_no,
a.birth_date,
a.first_name,
a.last_name,
a.gender,
a.hire_date
from(
    select 
    emp_no,
    birth_date,
    first_name,
    last_name,
    gender,
    hire_date,
    case when mod(emp_no,2)=1 then '1' else '0' end  ct,
    case when last_name<>'Mary' then '1' else '0' end ct_name
    from employees
    )a
where a.ct=1 and a.ct_name=1
order by a.hire_date desc