Firework Interview Question

SQL questions, nothing super tricky