i need to create a query that runs like this; all employees with an education level of 18 or 20 will receive a salary increase of 1200 and their bonus will be cut in half. List the name, education level, new salary and new bonus for these employees. Use names NEW_SALARY and NEW_BONUS for the generated columnsi need to create a query that runs like this; a
阅读背景：
- SQL生成列并从其他列自动填充 -
来源：互联网
分享到：
