unalivejoy

This is like your parents telling you to “clean your room or sleep in the yard” so you prepare to go camping.

Abandon technology and become a farmer.

Feel free to fork my comment.

I would make two separate views.

CREATE VIEW NiceList AS
 SELECT * FROM Children
  WHERE behavior = 'nice' 
   AND parent.income > 40000; 
CREATE VIEW NaughtyList AS
 SELECT * FROM Children
  WHERE behavior = 'naughty';