CIBC interview question

Query command to grab a user name info from multiple tables and group them.