PointClickCare interview question

Write two different SQL statements to retrieve data. Knowledge of SQL functions will be tested.