FunctionRacerProblemsRace

Pay With Bonus

EasySQLSQLite

bonus is empty (NULL) for people who got none. Return everyone's name and pay: salary plus bonus, where no bonus counts as 0. Rows may come in any order.

Example 1

employees
idnamesalarybonus
1Ada5000400
2Ben4200NULL
3Cy39000
returns
namepay
Ada5400
Ben4200
Cy3900

Constraints

Race itor take your time

Write it in your browser, against the clock. The model query, with a note on each piece of it, comes after.

More SQL problems