Flatiron Health Interview Question

Fairly straightforward SQL query.