Amazon Interview Question

SQL query databases using joins, groups, etc