Scenario
Welcome, aspiring Data Analyst! I see you've accepted our... unique employment opportunity.
You stand among countless other professionals vying for the position of Lead Data Analyst at SQL Squid Games Incorporated (yes it's an official business). Don't worry! – unlike our core business, this recruitment process won't be quite as... elimination-focused.
We've set up our operations on a private island – and before you ask, no, not THAT kind of private island. We prefer our data ethically sourced, thank you very much.
Your journey begins as a junior analyst, given '⬤' level access working with basic metrics. Each task will test your abilities to manipulate data in ways that serve our... special requirements.
The stakes? Well, let's just say our compensation package is to die for...
...
...
Poor choice of words, perhaps.
We offer a highly competitive salary of ₩5 billion per year, full benefits, and a corner office with an ocean view. Though I should mention, swimming is not recommended. Security measures, you understand.
Your first challenge begins now:
The contestants have just finished playing Red Light, Green Light. The organizers want to identify vulnerable 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 are gamblers 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 show the schema diagram.
