Amazon interview question

Just some basic SQL questions. Group, Join