To determine the total amount paid to all employees, use the COALESCE function to receive only the nonnull value found in hourly_wage, salary, and commission.

• 若要确定支付给所有雇员的金额总数,请使用COALESCE函数,它只接受在hourly_wage、salary和commission中找到的非空值。