显示薪水在 1500 到 3000 之间,工作类别以M开头的雇员信息
M
select * from emp e where e.sal between 1500 and 3000 and e.job like 'M%';