Scenario
Welcome, Data Scientist! It's me, the Front Man. I see you've accepted my... unique employment opportunity.
We've set up our operations on a private island – and before you ask, no, not THAT kind of private island.
You've joined just at the right time – the first game of Red Light, Green Light finished and we've generated some fresh data to analyze and fresh bodies to harvest.
Your first challenge begins now:
The organizers want to identify vulnerable living players who might be easily manipulated for the next game. Find all players who are alive, in severe debt (debt > 400,000,000 won), and are either elderly (age > 65) OR have a vice of Gambling with no family connections.
Show us how you handle our data, and remember – in this game, there's no room for error.
Click here to view the schema.
Enter your solution
Hints
Hint 1
Think about how to combine multiple conditions using OR/AND operators. Boolean logic!
Hint 2
Break down the criteria into two main groups: mandatory conditions (alive, debt) and optional conditions (age OR gambling/family status)
