下面哪一个like命令会返回名字像HOTKA的行?( )
A. where ename like ‘_HOT%'
B. where ename like ‘H_T%'
C. where ename like ‘%TKA_'
D. where ename like ‘%TOK%'
列出EMP表中,从事每个工种(JOB)的员工人数( )
A. select job from emp;
B. select job,count(*) from emp;
C. select distinct job,count(*) from emp;
D. select job,count(*) from emp group by job;