Servian interview question

SQL questions on joins, group bys, aggregating functions.