Return rep and total_pay = base + bonus. A missing bonus counts as 0 (Ravi should get 28000, not NULL).
rep
total_pay
3 rows with columns rep, total_pay
Run your code to see the output here.