with employee_bonusas (

select employee_id, salaryas bonusfrom Employeeswhere name notlike'M%'and employee_id %2=1

),

non_employee_bonusas (

select employee_id,0as bonusfrom Employeeswhere employee_id notin (

select employee_idfrom employee_bonus

))

select*from employee_bonus

select*from non_employee_bonus

order by employee_id

| 2072|[The Winner University](https://leetcode.com/problems/the-winner-university/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_2072.sql)|| Easy|

| 2026|[Low-Quality Problems](https://leetcode.com/problems/low-quality-problems/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_2026.sql)|| Easy|

| 1978|[Employees Whose Manager Left the Company](https://leetcode.com/problems/employees-whose-manager-left-the-company/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1978.sql)|| Easy|

| 1873|[Calculate Special Bonus](https://leetcode.com/problems/calculate-special-bonus/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1873.sql)|| Easy|

| 1853|[Convert Date Format](https://leetcode.com/problems/convert-date-format/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1853.sql)|| Easy|

| 1821|[Find Customers With Positive Revenue this Year](https://leetcode.com/problems/find-customers-with-positive-revenue-this-year/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1821.sql)|| Easy|

| 1809|[Ad-Free Sessions](https://leetcode.com/problems/ad-free-sessions/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1809.sql)|| Easy|