题解 | #获取employees中的first_name#

一.
select
first_name
from(
select 
right(employee1.A,1) as you
,left(employee1.A,1) as zuo
,employee1.first_name
from
(select
right(first_name, 2) as A
,first_name
from employees) as employee1) as employee2
order by employee2.zuo ASC, employee2.you ASC

二.

select

employee1.first_name

from

(select

right(first_name, 2) as A

,first_name

from employees) as employee1

order by A ASC