下列哪个语句查出雇员表(employees)里的雇员名字(ename)是‘SMITH’的信息,并且给雇员名字(ename)列定义一个别名Name()。
A. select employeesno,ename Name,job from employees where ename=‘SMITH’
B. select employeesno,ename ‘Name’,job from employees where ename=SMITH
C. select employeesno,ename “Name”,job from employees where ename=‘SMITH’
D. select employeesno,ename ‘Name’,job frome mployees wheree name=‘SMITH&rsquo