Flatiron Health Interview Question

How would you design database tables to support particular analytics queries.