HealthStream interview question

Gave a SQL table and asked to write queries on joins, aggregation functions.